![]() |
|
#1
|
||||
|
||||
![]() Quote:
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
DaddyMac | Mail Merge | 4 | 06-06-2013 09:22 PM |
How to transpose the datas of part code and supplier into row and column | PRADEEPB270 | Excel | 3 | 10-26-2012 07:22 PM |
Watermark PPT prints with a series of individual names | walvis | PowerPoint | 1 | 12-16-2011 06:49 AM |
Inputting Sound files - 2 options, neither working. | msteinruck | PowerPoint | 0 | 09-16-2010 09:44 AM |
Inputting variable data | axy | Word | 0 | 09-08-2009 04:50 PM |