Microsoft Office Forums Change Sender's address

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2017, 08:24 AM
Roym Roym is offline Change Sender's address Windows 10 Change Sender's address Office 2010 32bit
Novice
Change Sender's address
 
Join Date: Jan 2017
Posts: 4
Roym is on a distinguished road
Default Change Sender's address


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.
Reply With Quote
  #2  
Old 01-30-2017, 12:25 AM
macropod's Avatar
macropod macropod is offline Change Sender's address Windows 7 64bit Change Sender's address Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,536
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by Roym View Post
I have three branch offices for Sender's addresses, how can I change the sender's address dependent on a cell value.
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 01-30-2017, 12:40 AM
Roym Roym is offline Change Sender's address Windows 10 Change Sender's address Office 2010 32bit
Novice
Change Sender's address
 
Join Date: Jan 2017
Posts: 4
Roym is on a distinguished road
Default

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.

Last edited by Roym; 01-30-2017 at 12:47 AM. Reason: Delete response needs clarification
Reply With Quote
  #4  
Old 01-30-2017, 12:45 AM
Roym Roym is offline Change Sender's address Windows 10 Change Sender's address Office 2010 32bit
Novice
Change Sender's address
 
Join Date: Jan 2017
Posts: 4
Roym is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 01-30-2017, 01:11 AM
gmayor's Avatar
gmayor gmayor is offline Change Sender's address Windows 10 Change Sender's address Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,868
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

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
Reply With Quote
  #6  
Old 01-30-2017, 04:34 PM
macropod's Avatar
macropod macropod is offline Change Sender's address Windows 7 64bit Change Sender's address Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,536
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by Roym View Post
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.
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
[MS MVP - Word]
Reply With Quote
  #7  
Old 02-06-2017, 06:05 AM
Roym Roym is offline Change Sender's address Windows 10 Change Sender's address Office 2010 32bit
Novice
Change Sender's address
 
Join Date: Jan 2017
Posts: 4
Roym is on a distinguished road
Talking

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Sender's address where is the sender's address found for emails in windows 10 Mail app wondermuse Windows 1 11-25-2016 10:28 PM
email address change Barkas Outlook 0 06-21-2016 01:17 PM
Mass Change of Text to Display in Hyperlink to actual address ItsChris Excel 3 10-18-2014 01:35 PM
Change Sender's address Change of recipient/sender display name listlow Outlook 4 01-21-2010 03:54 AM
EMAIL address change warrencassell Word 8 12-10-2008 09:22 PM


All times are GMT -7. The time now is 10:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft