Word 2003 Email Merge w/Excel Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sharenrobert@hotmail.com - 17 Jun 2005 17:55 GMT

When using the email merge feature in Outlook 2003, I can't figure out how to
have the column of email addresses populate the "bcc" field rather than the
"To" field. Also, I need to send this blast email out from a shared mailbox
that is not my own personal mailbox, but it defaults to my personal box.

If this can't be done through Word, is there code that could be used in Excel?

Reply to this Message

Doug Robbins - 17 Jun 2005 23:46 GMT

To populate the bcc field, you will have to use a Macro that accesses the
Outlook Object Model.

Such a macro is used in the article "Mail Merge to E-mail with Attachments"
at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

To send from other than your own mailbox, you will need to be logged on as
the appropriate user.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When using the email merge feature in Outlook 2003, I can't figure out how
> to
[quoted text clipped - 6 lines]
> If this can't be done through Word, is there code that could be used in
> Excel?

Reply to this Message

Rate this thread: