mailmerge

[dasadler]

Is there a way to do mailmerge with Outlook so that the To: field uses an Excel worksheet as the data source? Similar to how mailmerge in Word does it?

[HansV]

There's no built-in support for this. I'd do a mailmerge to e-mail in Word.

[dasadler]

Word mailmerge to email? Never heard of that? How does that work? can it pull the email address from Excel?

[HansV]

Activate the Mailings tab of the ribbon in Word.
Click Start Mail Merge | E-mail messages.
You can use an Excel sheet as data source, and when you execute the mailmerge, Word will ask you which field from the data source should be used for the To: field.

[dasadler]

Cool. Now, I have several email accounts in Outlook - how does it know which one to use? Does it simply use the default account or give a choice?

[HansV]

I guess it'll use the default account, but why not perform a small experiment to check?