Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing From Address before sending mail
Hi,
I am trying to automate sending emails through excel which works fine however, one of the requirement is that, before a mail is sent, i need to change the From address for the mail, since we use different generic mail ids for sending mails to our customers. Currently i have to manually enter the From ID before i click on Send. Below is the code, i am using to create a mail item: Set olapp = CreateObject("Outlook.Application") Set olmail = olapp.CreateItem(olMailItem) olmail.Subject = "" With olmail .BodyFormat = olFormatHTML .HTMLBody = .To = '.Display .Send End With Please help!!! Thank you in advance. Navin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E-Mail attachment to same e-mail address in Outlook | Excel Discussion (Misc queries) | |||
e-mail address via outlook address book | Excel Programming | |||
E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) |