Hi Everyone

I'm using a MS 2010 Excel spreadsheet to link in to MS Word 2010 Mail Merge.
At present I'm stuck on the following - assuming it's possible.
I have three branch offices for Sender's addresses, how can I change the sender's address dependent on a cell value.


For example, the west branch FROM address would be called up for a client in the west of the county. Any help much appreciated.

You can't. What you would need to do is filter the merge by 'sender' email address and combine that with the approach described in: https://www.msofficeforums.com/mail-...tml#post109253

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Macropod

Many thanks for the quick response. I'm not sure how this would help as my query is nothing to do with "email"; it's a standard business letter whereby head office can respond and just change the FROM address at the top of the letter.

Hi Macropod

Thanks for your quick response. I'm not sure how this helps, perhaps I need to clarify this is nothing to do with "email". I'm in Head Office and trying to respond to a client using our branch address of the client's area.

While not strictly mailmerge, http://www.gmayor.com/ManyToOne.htm in one to one mode will emulate a merge to e-mail and allow the selection of an e-mail account to be used for that merge. You could use they filter to determine which of your records to send. Then merge the records for each account separately.

It is not exactly ideal, but short of creating a dedicated custom e-mail process to select the accounts in real time, it's probably as good as you are going to get.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Your initial post implied a merge to email was being done. If that's not the case, and you're sending letters, you can use an IF field to test the Sender's addresses and vary the content in the letter accordingly. See, for example, Mailmerge String Testing in the Mailmerge Tips and Tricks thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Apologies for delay in responding.

I've looked into your suggestion and seemed to have resolved my issue using a nested IF statement, similarly for the Branch signatory at the bottom of the letter.