+ Reply to Thread
Results 1 to 4 of 4

Working code to send mail automatic in outlook mail need little change

  1. #1
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Working code to send mail automatic in outlook mail need little change

    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.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Working code to send mail automatic in outlook mail need little change

    Add this at end of code...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Working code to send mail automatic in outlook mail need little change

    Hi Sintek.
    Tes i knew it properly was a little thing. I played with delete and other but did not think i could the kill version.
    Super thanks its working perfect.
    Sincerely
    Abjac

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Working code to send mail automatic in outlook mail need little change

    All good...tx for rep +

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Send an automatic mail from outlook when file updated
    By PRADIPHH in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2021, 07:54 AM
  2. [SOLVED] Code to send mail copying from Excel to a new outlook mail.
    By paz1987 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-11-2015, 07:54 AM
  3. VBA code to send mail automatically from outlook
    By aravindkm in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-28-2014, 08:07 AM
  4. Send e-mail with image on body (.html) on e-mail manager <> outlook
    By mariotnc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2012, 09:28 PM
  5. Send Mail - Code to test whether Lotus Notes / Outlook is used
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2005, 11:05 AM
  6. How can I use Outlook express to send mail rather than Outlook by VBA code
    By new.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2005, 11:05 AM
  7. [SOLVED] How can I use Outlook express to send mail rather than Outlook by VBA code
    By new.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1