![]() |
#8
|
||||
|
||||
![]()
In that case, you should create an Excel file with a list of names in once column and credentials in another. Then, when you get a new list from the client you can either:
a) use a lookup formula to retrieve the credentials for each entry and add them to the new file before merging; or b) use a DATABASE field in the mailmerge to query the credentials workbook for the credentials that go with each name.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
![]() |
beej | Outlook | 1 | 11-02-2012 12:19 PM |
Mail Merge Duplication of address on merge | RICKY | Mail Merge | 1 | 09-26-2012 03:14 PM |
![]() |
Llewella | Word | 4 | 05-12-2012 02:22 PM |
![]() |
Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |