Word Mail Merge-Email with Different From/Sender?

Question

I need to use a word mail merge document that is formatted to send emails to specific users based on a column in the source file. However, I need to know how to use a different sender from Outlook Address Book. I have permissions to send emails from the group.

For example, my name is Jim Smith, but I need to use the Group: Accounting Group as my From in the mail message.

This isn't a field I need in the actual email body but rather the actual "FROM:" in the email header.

Answer 1

You should be able to add this as a field in your database.

Answer 2

Mail Merge uses the default e-mail profile as the "from".
In the Control Panel, in E_mail setup, set the group as your default user.

Control Panel - Mail - Show Profiles
Change the "Always use this Profile" to the group or select Prompt for a profile to be used so you can select the profile.