Quote:
Originally Posted by Aron19
What I need to do is have a supplier name input into Word for 339 different suppliers for the same letter that is going out.
I just want to be able to have the supplier names listed in Excel come over into Word and create an individual letter for each supplier without having to do all 339 myself by copying and pasting.
Is this possible?
|
That is quite possible using a letter mailmerge in Word.
To use this, your Excel data would need to be organised in columns, with a column for the supplier names and at least one column for each separate address line. The first row in Excel would be a header row and each subsequent row would have the supplier details. Thus, for the header row, you might have:
Supplier, Address1,Address2,Locality,State,Zip
It doesn't matter if some suppliers only have one address line - the blank ones can be suppressed in the mailmerge.
In Word, you'd write the letter as if it were going to just one supplier. having done that, you'd use Word's mailing tools to create the mailmerge. See:
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
http://office.microsoft.com/en-au/wo...102809678.aspx
http://support.microsoft.com/kb/294683/en-us