Hello,
I am sending e-mails through an Excel Macro.
I want the sent e-mail to be taken from Outlook “Sent Items” and copy it to a certain folder on my computer.
Could anyone advise?
Thanks
Hello,
I am sending e-mails through an Excel Macro.
I want the sent e-mail to be taken from Outlook “Sent Items” and copy it to a certain folder on my computer.
Could anyone advise?
Thanks
Do you need the actual emails? Or just the details in text format from the Subject, To, Body? If so, you can easily create text files from the code you are using to send the emails.
I figured it out.
I wrote this just before the ".send":
itmMail.SaveAs (Filelocation & "\EmailToSave.msg")
Where "Filelocation" is where my current open Excel File resides.
It works smoothly;
Thank you for the response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks