View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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