HI I have below code which send mail through outlook mail ( Ony working if you have a outlook account setup).
The code is working brilliant i put my mail address into Sheet1 Cell F3 and can put other mail address into Cell F4.
In Cell F5 i choose to put a formula =Today()
When it send the mail, it create a copy on the path i send it from. So if my workbook are in my desktop. It create a copy and the workbookname and send to my mail. It all works brilliant. The only thing i would really like is is it after send the mail with the copy off my workbook , that it will delete that copy. Now after it send i have a copy of my workbook example on my desktop. So i need remember to delete it. If some can make so it delete the copy after send the mail. It would be really great. The code is really good and work perfect.
So if some have time. Please have a look and put in so it will delete this copy after it send the mail.
Thanks in advance.
Sincerely
Abjac
MY code below.
![]()
Please Login or Register to view this content.
Bookmarks