Export from Excel to Outlook, Outlook has to be running?

Hi,

somehow I have a weird issue here. I just set up my first macro which generates some emails out of a list. The macro works actually pretty good, however as soon as I close outlook it doesnt work correctly anymore.

The macro should (in this example) generate three emails and save them in the template folder. As long as outlook is running this is working, however if outlook is closed two emails are saved in the template folder and one email is saved in the inbox folder (see screenshots).

Does anybody have a solution for that? highly appreciated!

Code, File, Screenshots, pls see attached!

Please Login or Register  to view this content.

has nobody any idea?