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