[Lynbak]

Is there a way to merge return addresses from one list and recipient
addresses from another ?

[Doug Robbins - Word MVP]

No, Word can only use a single "flat" file as a data source. Would you be
wanting a varying return addresses though?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Lynbak" wrote in message
...
Is there a way to merge return addresses from one list and recipient
addresses from another ?

[Peter Jamieson]

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 ?