outlook profiles
 

i have 3 different profile accounts setup in microsoft outlook. is there a
way from excel to send a email from any of the 3?
for example if the current profile in outlook is , can i through
excel send a email from ?

thanks in advance

outlook profiles
 

Yes, you login to that profile, something like

Dim oOutlook As Outlook.Application
Dim oMail As Outlook.MailItem
Dim oRecipient As Outlook.Recipient
Dim oNameSpace As Outlook.Namespace


Set oOutlook = CreateObject("Outlook.Application")
Set oNameSpace = oOutlook.GetNameSpace("MAPI")
oNameSpace.Logon "UserAll","thatpassword",True
'etc.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"choice" wrote in message
...
i have 3 different profile accounts setup in microsoft outlook. is there a
way from excel to send a email from any of the 3?
for example if the current profile in outlook is , can i
through
excel send a email from ?

thanks in advance