Change the "From" field when using VBA to email from Outlook

[kgkev]

Using Excel 2000 & Outlook 2003


I have this all working but would like to change the "from" on the email to invoice@mycompany.com

I took a guess that it might be

omail.from = "invoice@mycompany.com"

but this didn't work

my code

    With oMail
        .to = MailTo
        '.Cc = MailCC
        '.Bcc = MailBCC

        .Subject = MailSub
        .Body = MailTxt
        .Attachments.Add filepath
        .Attachments.Add "\\server\company\shipping\invoices\@T&C.pdf"
        .Display
        '.send
    End With

 

[daverunt]

You can't change the From field but I think you can use the
SentOnBehalfOfName = """SenderName"" <REPLY@ADDRESS.COM< font>>"


See:
http://www.rondebruin.nl/mail/tips2.htm

 

[kgkev]

thanks - Thats worked.

Did go through rons site but couldn't find that one - It was well hidden.