Q: How to specify the From email address when doing a Word mail merge? This thread is locked from future replies

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?



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 , 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)
For more Word tips and downloads visit my web site

Did this solve your problem?

Sorry this didn't help.

Question Info

Views: 5,504 Last updated: March 22, 2018 Applies to: