View Single Post
 
Old 05-22-2014, 04:31 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote