Can't initiate Outlook 'Send/Receive All Folders' from Excel

Hi Guys,

I really need some help here. My situation is that I need to use a computer which has Outlook 2016 with the 'Send immediately when connected' option unticked (so all emails go to the Outbox when they're initially sent) and I can't do anything about that.

I'm trying to write a really simple macro that performs the following steps:

1) Construct an email message from within Excel
2) Transfer the message from Excel to Outlook 2016 and 'send' it from the default email account
3) Move it from the Outbox to the Sent Items folder (i.e. properly sending it)

All of my somewhat limited VBA experience has been within the Excel application and I'm not really familiar with automation of other apps. I've borrowed code from other threads (many thanks!) and I've managed to complete steps 1 & 2 with no problems. However, I'm stuck on step 3.

I've obtained some code for this which I thought would work but it just doesn't seem to do anything at all. When I step through the code line by line, I don't get any error whatsoever but the email that was created and sent at steps 1 and 2 just remains stuck in the Outbox. The same is true whether Outlook is closed or running at the start of the macro.

Does anybody have any ideas as to where I'm going wrong? I'd really appreciate you taking a look - my code is as follows:

Please Login or Register  to view this content.

Thanks very much for your reply 6StringJazzer but I really need to try and automate this so that it doesn't require user-intervention in Outlook. The computer will be unattended whilst the macro runs and I need the emails to automatically send at the point they're created by Excel.

I've seen a few snippets of code in various forums that claim to do the trick but I just can't seem to get any of them to work. I don't really understand what GetNamespace("MAPI") is all about and I think I'm probably trying to use it in a way that it's not supposed to be used.

Any thoughts? Thanks again!

Thanks again 6StringJazzer but I get Run-time error 450 (Wrong number of arguments or invalid property assignment) when I use your line of code as follows:

Please Login or Register  to view this content.

Just by way of an update, I've actually discovered that the code in my original post does in fact work, but only if my 'send-from' email account is designated as being included in a Send/Receive Group in Outlook.

For some reason, by default, my email account isn't included in any Send/Receive Group, yet I can still send and receive emails with no problem by clicking Send/Receive (or hitting F9). Therefore, I'd assumed that SyncObjects would just emulate me initiating a Send/Receive and hence send and receive the account too, but it clearly doesn't!

So, I think my issue is less Excel and more Outlook related and, whilst I'd still be extremely interested to hear any ideas from ExcelForum, I've posted a related thread with the good people at Slipstick. I'm a newbie and so I'm not allowed to post any links but, if you want to follow up further, you can search Slipstick for "Email not leaving Outbox when using Excel VBA to sync Outlook account"

Cheers, Mattypuss

I would ask that you enter the link, click on Go Advanced below the edit box,and uncheck "Automatically parse links in text". This will prevent the link from being hot, and I think it will be allowed.

It still wasn't allowed!

I can't help with the above problem

Lewis, you've actually completely solved my problem!!! I integrated your lines below into my original code as my Step 3 and it now works perfectly:

Please Login or Register  to view this content.

So, whilst I still don't understand why my original method doesn't work, I do now have an alternative working solution.

A thousand thanks to you Lewis... I can now move forward and your assistance is really appreciated.

Mattypuss