I am using a VBA macro to send e-mails from Excel.
I want the macro to save a copy the sent email in a folder (say C:\MySent Emails).
What would be the code for this?
Thank you.
I am using a VBA macro to send e-mails from Excel.
I want the macro to save a copy the sent email in a folder (say C:\MySent Emails).
What would be the code for this?
Thank you.
Have you tried setting up your email account to save send emails? You can probably also set up a rule that will save specific emails to a specific folder
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbins,
Right now I am using a macro which has this code:
- I want to save the e-mail not before is going out, but after (so it would show that the e-mail was sent).![]()
Please Login or Register to view this content.
I tried something like:
I don't know how to Set the SentMail - like SentMail=OutApp.CreateItem(0)- or how...?![]()
Please Login or Register to view this content.
... and I don't know how to write it into the With .... End With
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks