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

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