If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
return address
Is there a way to merge return addresses from one list and recipient
addresses from another ? |
#2
|
|||
|
|||
return address
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 ? |
#3
|
|||
|
|||
return address
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 ? |
Thread Tools | |
Display Modes | |
|
|