email merge - I need to change the sender account

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vaughn - 01 Mar 2005 17:47 GMT

I am doing an email-merge. When I send these emails, they need to come from
another email account. I do admin work for several other people and have
their email accounts on my outlook. How can I change the sender?

Reply to this Message

Graham Mayor - 01 Mar 2005 18:03 GMT

Temporarily change the default e-mail account to the required account.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am doing an email-merge. When I send these emails, they need to
> come from another email account. I do admin work for several other
> people and have their email accounts on my outlook. How can I change
> the sender?

Reply to this Message

Vaughn - 01 Mar 2005 18:19 GMT

I've done that as a temporary solution. Is there anywhere I can look for a
VBA solution? This job may be done on any one of three PCs. Each one may send
email for ony one of four counsultants.

> Temporarily change the default e-mail account to the required account.
>
> > I am doing an email-merge. When I send these emails, they need to
> > come from another email account. I do admin work for several other
> > people and have their email accounts on my outlook. How can I change
> > the sender?

Reply to this Message

Peter Jamieson - 01 Mar 2005 18:54 GMT

You are more likely to get a knowledgeable reply to this one in an Outlook
group.

Peter Jamieson

> I've done that as a temporary solution. Is there anywhere I can look for a
> VBA solution? This job may be done on any one of three PCs. Each one may
[quoted text clipped - 7 lines]
>> > people and have their email accounts on my outlook. How can I change
>> > the sender?

Reply to this Message

Vaughn - 01 Mar 2005 22:17 GMT

That's true. There is a wealth of info there. But, I need to know the timing.
I'm in a merge document and at the end I enter the email address field and a
subject. When is it that VB code is triggered? When is the email message
subject to VB code?

> You are more likely to get a knowledgeable reply to this one in an Outlook
> group.
[quoted text clipped - 11 lines]
> >> > people and have their email accounts on my outlook. How can I change
> >> > the sender?

Reply to this Message

Peter Jamieson - 01 Mar 2005 21:05 GMT

I would assume that your best bet is either to execute any code needed
before you initiate the merge, or use the MailMergeBeforeMerge event to do
it. You /might/ be able to do that on a per-message basis using mailmerge
events, but I would suspect that would only make sense if switching senders
is easy and fast. I do not think you will be able to control what Word does
with the message,only what other software does with the message.

Peter Jamieson

> That's true. There is a wealth of info there. But, I need to know the
> timing.
[quoted text clipped - 21 lines]
>> >> > people and have their email accounts on my outlook. How can I change
>> >> > the sender?

Reply to this Message

Rate this thread: