VBA Generated Outlook Templates fail to send

Good Morning All,

I've spent a hour going through the forum trying to find a solution to this but no luck - so I ask humbly for your help.

I've created a spreadsheet that creates reports and saves them to a folder as an .xls. I have also made buttons for different mailing groups that load an OFT Outlook Template, modifies the subject, attaches the report and displays it ready for the user to review and then hit send if they're happy. (Outlook and Excel Version 2010, Win 7)

Please Login or Register  to view this content.

Now it all seems to work fine until I actually click 'Send', where it just disappears into the ether never to be seen again. I checked my Outbox, Sent Emails and clicked Send/Receive a hundred times but no luck. If anyone has any clue to why this would fail please help me - this is the last problem I have to solve before completing this project.

Best,

Mike

Try moving the Display after the End With.

I have seen a few examples of code, very similar to yours, that add a .Save inside the with.

I have seen other posts suggesting that disappearing messages were from duplicate message ID's. Could it be that the message ID is not generated until the message is saved?

You might change the .Display to .Send, if review is not required.

Display pauses the Outlook box for a last look. Send doesn't display the windows, it just sends it.