How to specify the From email address when doing a Word mail merge?

I'm using both Outlook, Word, and Excel 2010. I have a list of contacts with names and emails in an excel file. I was using Word's mail merge in order to broadcast a large number of emails but I have Outlook configured with several email accounts and Word used the wrong email address as the From (i.e. sender) address for the mail merge broadcast. I even changed the default email account prior to the merge, although in hindsight perhaps I should have also rebooted outlook. Word's mail merge wizard doesn't have any apparent option for configuring which email to use as the sender.

So my questions are:

1. How do you specify which email address sends the Word email mail merge broadcast? (assume BCC is off the table)

2. Fortunately, I changed my passwords to my other email accounts just prior to the merge as well. So they can't be sent but they will continuously attempt to send. I'm not entirely convinced that deleting them from the outbox alone will do the job of making certain that they won't be sent. What is the best way to purge these emails or do I pretty much have to delete and recreate the account?

Answer
Answer
Changing the default e-mail account temporarily to the required account for the duration of the merge should work, or you could use a third party add-in such as http://www.gmayor.com/ManyToOne.htm , which, in one to one mode, will emulate an e-mail merge and will allow you to select the sending account, and you can use multiple recipients associated with each record using BCC if you wish. The only real proviso is that your data source must be an Excel worksheet. Read the web page instructions before starting.
Graham Mayor (Microsoft Word MVP 2002-2019)
For more Word tips and downloads visit my web site
https://www.gmayor.com/Word_pages.htm

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 25, 2024 Views 6,857 Applies to: