﻿<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://owl.unipharm.com/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Accounting_Finance%3ANew_Customer_Documents_%27Mail_Merge%27</id>
	<title>Accounting Finance:New Customer Documents 'Mail Merge' - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://owl.unipharm.com/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Accounting_Finance%3ANew_Customer_Documents_%27Mail_Merge%27"/>
	<link rel="alternate" type="text/html" href="https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:New_Customer_Documents_%27Mail_Merge%27&amp;action=history"/>
	<updated>2026-09-01T14:43:11Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.35.4</generator>
	<entry>
		<id>https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:New_Customer_Documents_%27Mail_Merge%27&amp;diff=10642&amp;oldid=prev</id>
		<title>Mikeg: Created page with &quot;==Customer Documents== *The following documents have all been combined into one single word file: ::'''-''' Waiver of Right of Setoff (UWD003) ::'''-''' Compliance Agreement (...&quot;</title>
		<link rel="alternate" type="text/html" href="https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:New_Customer_Documents_%27Mail_Merge%27&amp;diff=10642&amp;oldid=prev"/>
		<updated>2017-12-27T18:48:12Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;==Customer Documents== *The following documents have all been combined into one single word file: ::&amp;#039;&amp;#039;&amp;#039;-&amp;#039;&amp;#039;&amp;#039; Waiver of Right of Setoff (UWD003) ::&amp;#039;&amp;#039;&amp;#039;-&amp;#039;&amp;#039;&amp;#039; Compliance Agreement (...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==Customer Documents==&lt;br /&gt;
*The following documents have all been combined into one single word file:&lt;br /&gt;
::'''-''' Waiver of Right of Setoff (UWD003)&lt;br /&gt;
::'''-''' Compliance Agreement (UWD007)&lt;br /&gt;
::'''-''' General Security Agreement (UWD011)&lt;br /&gt;
::'''-''' Guarantee Agreement (UWD012)&lt;br /&gt;
::'''-''' Merchant Banking (UWD005)&lt;br /&gt;
::'''-''' Credit Card Authorization (UWD015)&lt;br /&gt;
::'''-''' Maxwell Paper Fax Form (UWD010)&lt;br /&gt;
::'''-''' Subscription Agreement – BC (UWD013)&lt;br /&gt;
::'''-''' Subscription Agreement - AB (UWD014)&lt;br /&gt;
::'''-''' Credit Card Authorization (UWD015)&lt;br /&gt;
::'''-''' MC Trademark Agreement (UWD019)&lt;br /&gt;
::'''-''' ROFR Agreement (UWD020)&lt;br /&gt;
::'''-''' Narcotic Authorization Form (2 principal contacts)&lt;br /&gt;
*It is not necessary to use all documents; discard or do not print the documents not required.&lt;br /&gt;
&lt;br /&gt;
==New Customer Application==&lt;br /&gt;
*If Customer has emailed you the Customer Application, save the Customer Application in your directory&lt;br /&gt;
*If not, Open uniPHARM-Customer Application.pdf&lt;br /&gt;
*Go to formsgeneral\membership\customer set up forms\ customer applications\new customer application\unipharm-Customer Application.pdf&lt;br /&gt;
*Fill out the application and save it in your directory&lt;br /&gt;
&lt;br /&gt;
===Copy pdf Data to Mail Merge File===&lt;br /&gt;
*Copy Page 1 of pdf file to page 1 of Mail Merge.xlsm file (trying clicking on the left top corner to highlight the enter sheet and then press '''Ctl C''')&lt;br /&gt;
*'''Move to the Mail Merge.xlsm file and place your cursor at the top right corner of Page 1 and then press Ctl V'''&lt;br /&gt;
*Copy Page 2 of pdf file to page 2 of Mail Merge.xlsm file &lt;br /&gt;
*'''Move to the Mail Merge.xlsm file and place your cursor at the top right corner of Page 2 and then press Ctl V'''&lt;br /&gt;
[[File:MM1.png|400px]]&lt;br /&gt;
&lt;br /&gt;
===Enter Date in Mail Merge File===&lt;br /&gt;
*In the Mail Merge worksheet, click '''Mail Merge''' sheet&lt;br /&gt;
*Enter Day, Month (Full description) and year&lt;br /&gt;
*Save Mail Merge worksheet&lt;br /&gt;
*Close Mail Merge worksheet&lt;br /&gt;
&lt;br /&gt;
===Shareholder Documents===&lt;br /&gt;
*Open UWD000-Shareholder Documents.docx&lt;br /&gt;
*Go to formsgeneral\membership\customer set up forms\ customer applications\new customer application/UWD000-Customer Documents.docx&lt;br /&gt;
*Click '''Yes''' to select from Mail Merge$&lt;br /&gt;
&lt;br /&gt;
===Start Mail Merge===&lt;br /&gt;
*Click '''Mailings'''&lt;br /&gt;
*Click '''Start Mail Merge'''&lt;br /&gt;
*Click '''Step by step mail merge wizard'''&lt;br /&gt;
&lt;br /&gt;
===Complete the Merge===&lt;br /&gt;
*Click '''Next: Write your letter (Step 3 of 6)'''&lt;br /&gt;
*Click '''Next: Preview your letters (Step 4 of 6)'''&lt;br /&gt;
*Click '''Next: Complete the merge (Step 5 of 6)'''&lt;br /&gt;
*Review documents and delete pages not applicable and click '''Print'''&lt;br /&gt;
&lt;br /&gt;
===Complete Checklist===&lt;br /&gt;
*Open Customer Checklist&lt;br /&gt;
*Go to formsgeneral\membership\customer set up forms\ customer applications\Customer Checklist/UWD000-Shareholder Checklist.xlsm&lt;br /&gt;
*Create new sheet for new shareholder&lt;br /&gt;
*Check off documents sent&lt;br /&gt;
*Save file&lt;br /&gt;
[[File:MM2.png|400px]]&lt;br /&gt;
&lt;br /&gt;
===Forward Documents to Customer Service===&lt;br /&gt;
*Customer Service will create Hotline incident&lt;br /&gt;
*When documents are returned, Customer Service will obtain approval for shareholders before forwarding to Finance for processing.&lt;br /&gt;
*Finance will perform credit checks and update Hotline:&lt;br /&gt;
::'''-''' Shareholder (within 4 business days)&lt;br /&gt;
*Finance will return all documents to Customer Service &lt;br /&gt;
*Customer Service will close Hotline and send email to all staff notifying everyone when account has received final approval.&lt;br /&gt;
*Customer Service will send welcoming letter and new member documents to customer.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[[Category:Workflows-Finance]]&lt;br /&gt;
[[Category:Accounts Receivable]]&lt;/div&gt;</summary>
		<author><name>Mikeg</name></author>
	</entry>
</feed>