Results 1 to 16 of 16

Macro to create a draft email from Excel

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2022
    Location
    London, England
    MS-Off Ver
    Ms. Office 2013
    Posts
    79

    Exclamation Macro to create a draft email from Excel

    Hi all, so I want to create a macro that could draft an email, but not immediately sending it because I want to do a one last checking before sending.

    So I created 3 sheets in the file I've attached:

    1. Setup -> This is to setup the date and month that's written in the email, it's editable. Basically the Setup sheet is to cross-check if the day the email sent is not on either Saturday/Sunday. I've created a little button to check, so there's no issue there.
    2. Heading -> This is to insert Subject and put the list of To and Cc the people to send the emails to
    3. Email Content -> The content I want on the emails that I'd send

    I'm confused to create a macro that could:
    1. Input the Subject, To and Cc
    2. Everything written in Sheet "Email Content" is what I want in the email. The contents in that sheet is changeable. In the sample email I have a 8-row table, but it can also be a 2-row table and others
    3. Not immediately sending, just draft first so I can check if the contents are already good to go

    Can anyone help me on this? I've attached the sample file that I've created with all the sheets.

    Oh yeah, as a note, I use Ms. Outlook.

    Thank you so much in advance!
    Attached Files Attached Files
    Last edited by nettadecoco; 12-06-2022 at 12:04 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create MS Outlook Email from Excel and Save to Draft Folder
    By jski21 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2020, 05:55 AM
  2. Draft email create from vba, body to contain worksheet
    By rbeech23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2020, 11:54 AM
  3. [SOLVED] A macro to copy a worksheet to a new workbook and create an email draft with the new ws
    By skylinekiller in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2018, 07:25 PM
  4. Macro to automatically draft email and save in a Folder
    By Mr.India in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2015, 12:16 PM
  5. Copy data from excel to Outlook new email and create draft.
    By G.Bregvadze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2013, 03:31 AM
  6. Create Outlook Draft along with attachment via Excel Macro
    By sekar.suman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 07:37 AM
  7. Create Lotus Notes Draft email from filtered or unfiltered List
    By Jimmy0306 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-07-2009, 09:03 PM

Tags for this Thread

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