I am using the following code to send emails, it's from Ron DeBruin's site. It works, but how can I edit so that it doesn't send the file, but saves it to your drafts??
Please Login or Register to view this content.
I am using the following code to send emails, it's from Ron DeBruin's site. It works, but how can I edit so that it doesn't send the file, but saves it to your drafts??
Please Login or Register to view this content.
Last edited by erock24; 05-20-2009 at 10:44 PM.
Hello erock24,
When you create a new item in Outlook, in your case a mail item, it will be saved to the default folder for the item type. The default folder for a new email is the Drafts Folder. Adding Save before you send will place a copy in the Darfts Folders. I have made the addition marked in blue.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you for the help and info.....I'll be able to try it first thing in the morning..I assume that if I get rid of the ".Send" line and only keep the ".Save" line I will in fact not send but save, which is ideal..
Thanks.
Hello erock24,
You are correct. Changing .Send to .Save will place the email in the Drafts Folder.
Hi,
What if instead of saving the email in the defaut draft folder I need to save it in another folder.
Any idea how to choose the file through vba?
Thank you.
Balacio,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks