Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here are different combos that I can think of that should set the account
and then the errors I get with them. Sub A_SendUsingAccount() Dim oAccount As Outlook.Account Dim outacct As Outlook.Account Set OutApp = CreateObject("Outlook.Application") Set OutNS = OutApp.GetNamespace("MAPI") OutNS.Logon Set OutMail = OutApp.CreateItem(0) ' Set outacct = ") '" Run-time error '450': Wrong number of arguments or invalid property assignment" ' Set oAcct = OutNS.Session.Accounts(21) '" Run-time error '450': Wrong number of arguments or invalid property assignment" 'Set oAccount = OutNS.Accounts(21) '" Run-time error '450': Wrong number of arguments or invalid property assignment" 'Set oAcct = OutNS.Session.Accounts(21)'" Run-time error '450': Wrong number of arguments or invalid property assignment" ' oAccount = OutApp.Session.Accounts(21) '" Run-time error '450': Wrong number of arguments or invalid property assignment" ' Set oAccount = OutApp.Session.Accounts(21) '" Run-time error '450': Wrong number of arguments or invalid property assignment" ' oaccountcnt = Application.Session.Accounts.Count ' MsgBox oAccount ' MsgBox oaccountcnt ' For Each oAccount In OutApp.Session.Accounts If oAccount.AccountType = olPop3 Then Dim oMail As Outlook.MailItem Set oMail = OutApp.CreateItem(olMailItem) oMail.Subject = "Sent using POP3 Account" oMail.Recipients.Add ") oMail.Recipients.ResolveAll oMail.SendUsingAccount = oAcct oMail.Send End If 'Next End Sub "Keith74" wrote in message oups.com... Hi Don't really know outlook VBA but Set oAccount = Application.Session.Accounts(21) would still think its running in excel try Set oAccount = OutApp.Session.Accounts(21) instead. And make sure you have the reference to the MS Outlook object library selected. hth Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP: Setting CNTL-SHIFT-F to invoke Excel2007 macro | Excel Discussion (Misc queries) | |||
HELP: Setting CNTL-SHIFT-F to invoke Excel2007 macro | Excel Programming | |||
converting Lotus 123 macro to Excell macro | Excel Discussion (Misc queries) | |||
Converting XL4 Macro Sheet to VBA | Excel Programming | |||
Converting to macro | Excel Programming |