Your options are in essence
a. "join" the two lists prior to or during the merge
b. set up one list (probably the recipient list) to be the mail merge
data source, and insert the related return address for each record using
a { DATABASE } field
c. set up one list to be the mail merge data source and use VBA and
Word Mailmerge Events to retrieve the related data from the other list
and insert it
d. "roll your own" merge.
How easy/appropriate each of those things would be depends on the format
of the lists, how the data in the two lists is related, and your ability
with VBA etc. For (a) and (b) you really need to have a field in one
list that uniquely identifies the associated record in the other list.
(c) might be a reasonable approach if there was no such linking field
but, for example, record 1 in list 1 corresponded with record 1 in list
2, and so on.
Peter Jamieson
http://tips.pjmsn.me.uk
On 13/04/2010 23:17, Lynbak wrote:
Is there a way to merge return addresses from one list and recipient
addresses from another ?