Afternoon all, here's hoping that someone might know off hand something
that's perplexing me.

I'm running some code that creates e-mails and sends (no attachment). I'm
using the SendKeys method to bypass the Outlook security warning, as
3rd-party apps aren't suitable, and using CDO isn't an option due to needing
to keep a copy in "Sent".

However, just to mix it up, I need to be able to amend the "From" field in
the Mail to be sent.

Currently it generates and sends ok using:

With OutMail
.To = addressees
.CC = ""
.BCC = ""
.Subject = "Password to Access File to Follow"
.Body = strbody
.Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%S"
End With

Adding a line stating ".From = unusualaddress" doesn't amend the From field
in the message, sending instead with the default sender options for the
Outlook account - ie my personal one rather than a specific other address
(which I can send from normall).

Had a look through RDB's site where I would normally go for this kind of
thing, but couldn't find anything about amending the From field.

Anyone got any ideas to save what's left of my hair?

TIA

See the Tips page
You can find a link on each example mail page I have on my site
http://www.rondebruin.nl/mail/tips2.htm


If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
.SentOnBehalfOfName = """SenderName"" <(E-Mail Removed)>"





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DS" <(E-Mail Removed)> wrote in message news:26099A5C-9079-4670-8222-(E-Mail Removed)...
> Afternoon all, here's hoping that someone might know off hand something
> that's perplexing me.
>
> I'm running some code that creates e-mails and sends (no attachment). I'm
> using the SendKeys method to bypass the Outlook security warning, as
> 3rd-party apps aren't suitable, and using CDO isn't an option due to needing
> to keep a copy in "Sent".
>
> However, just to mix it up, I need to be able to amend the "From" field in
> the Mail to be sent.
>
> Currently it generates and sends ok using:
>
> With OutMail
> .To = addressees
> .CC = ""
> .BCC = ""
> .Subject = "Password to Access File to Follow"
> .Body = strbody
> .Display
> Application.Wait (Now + TimeValue("0:00:02"))
> Application.SendKeys "%S"
> End With
>
> Adding a line stating ".From = unusualaddress" doesn't amend the From field
> in the message, sending instead with the default sender options for the
> Outlook account - ie my personal one rather than a specific other address
> (which I can send from normall).
>
> Had a look through RDB's site where I would normally go for this kind of
> thing, but couldn't find anything about amending the From field.
>
> Anyone got any ideas to save what's left of my hair?
>
> TIA

Ron, you are an absolute legend amongst men. Works like a charm.

Many Thanks,
DS

"Ron de Bruin" wrote:

> See the Tips page
> You can find a link on each example mail page I have on my site
> http://www.rondebruin.nl/mail/tips2.htm
>
>
> If you want to change the sender name and reply address add this code line
>
> 'The receiver can see the original mail address in the properties if he want
> .SentOnBehalfOfName = """SenderName"" <(E-Mail Removed)>"
>
>
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "DS" <(E-Mail Removed)> wrote in message news:26099A5C-9079-4670-8222-(E-Mail Removed)...
> > Afternoon all, here's hoping that someone might know off hand something
> > that's perplexing me.
> >
> > I'm running some code that creates e-mails and sends (no attachment). I'm
> > using the SendKeys method to bypass the Outlook security warning, as
> > 3rd-party apps aren't suitable, and using CDO isn't an option due to needing
> > to keep a copy in "Sent".
> >
> > However, just to mix it up, I need to be able to amend the "From" field in
> > the Mail to be sent.
> >
> > Currently it generates and sends ok using:
> >
> > With OutMail
> > .To = addressees
> > .CC = ""
> > .BCC = ""
> > .Subject = "Password to Access File to Follow"
> > .Body = strbody
> > .Display
> > Application.Wait (Now + TimeValue("0:00:02"))
> > Application.SendKeys "%S"
> > End With
> >
> > Adding a line stating ".From = unusualaddress" doesn't amend the From field
> > in the message, sending instead with the default sender options for the
> > Outlook account - ie my personal one rather than a specific other address
> > (which I can send from normall).
> >
> > Had a look through RDB's site where I would normally go for this kind of
> > thing, but couldn't find anything about amending the From field.
> >
> > Anyone got any ideas to save what's left of my hair?
> >
> > TIA
>