Changing From field in a mail merged word document

L

Larry

I am using Word 2002 and Outlook 2002 and am looking to creat a mail merge
document to be sent out to 500 users. My question is:

Is it possible to change the "From address" that appears on the e-mailed
messge?
We want to send e-mails to a group of users and have it appear to come from
a maile enabled public folder.

Thanks for the help.
 
P

Peter Jamieson

This is what I think is feasible/infeasible from experiments here:
a. when you use the out-of-the-box merge to e-mail, you have to be logged
in to the account you want to send from. If there's some way to be logged in
as a Public Folder, I guess you could do it that way (but I don't know of
such a way)
b. if you use an approach such as the one Doug Robbins describes at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

then I think you can specify the "Send As" mailbox by specifying

objMailItem.SentOnBehalfOfName = "the mailbox name you want to use"

What happens then depends on what permissions the Exchange Admin. has give
to the currently logged in User. If they have permission to Send on Behalf
As, the mail is sent out with a "Sent on behalf of" address. If they have
permission to Send As, it goes out as if it was from the specified user.

c. Although a mail-enabled Public Folder has an SMTP and Exchange (X.400)
E-mail address, I don't think it's actually also an Exchange Mailbox. And I
suspect that therefore, if you set the SentOnBehalfOfName to be the name of
a public folder (or, for example, its SMTP address), you may just get errors
back from exchange.
d. If (c) is correct, then all I can suggest is that you probably need to
set up a Mailbox whose incoming mail is redirected to a Public Folder.
However, my experience of Exchange is now from the early days of the product
(around 10 years ago) and I cant advise how to do that, or whether in fact
there is a way to do (c).

Finally, since a public folder does have an SMTP address, there may be some
other way of generating e-mails that completely bypasses Outlook (perhaps
using Windows "NT" CDO directly but which will work with Exchange. But
again, if so, I can't advise what that might involve.

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top