+ Reply to Thread
Results 1 to 5 of 5

Basic VBA for Email - No Attachment Needed - Only Subject, Email, Greeting & Body

  1. #1
    Registered User
    Join Date
    02-28-2017
    Location
    Atlanta, GA
    MS-Off Ver
    Office 2016
    Posts
    6

    Basic VBA for Email - No Attachment Needed - Only Subject, Email, Greeting & Body

    I have looked at a solution throughout the forum but haven't found exactly what I am looking for.

    I want to be able to send multiple personalized emails where I have the option of updating the Subject, Email, Greeting, and Body.

    See attached. I also want the option to automatically send or to save as a draft in Outlook. For example, in the attached, the Subject in B1 is "Thank You", and Auto Send set to "No". The Email, Greeting, and Body are in Columns B,C, and D. You shouldn't have to hard code anything in the VBA for the email and there will be no attachment. Also, how would this work with an Email Signature? Should this be hard coded or will the Signature automatically appear based on your Outlook settings?

    In the attached example, for Row 4, I want the Outlook email to generate the following:

    To: (Email Address in Cell B4)
    Subject: Thank You

    Marie,

    Thank you for your business. Please let us know if we can further assist your business needs.
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Basic VBA for Email - No Attachment Needed - Only Subject, Email, Greeting & Body

    .
    Here is something to more than get you started.

    Please Login or Register  to view this content.
    You'll need to add the code to include your Email Signature. You can Google for "vba outlook add signature". Should return tons of examples.

    Also, you'll need to edit the code so it refers to your present sheet layout (references to columns, cells locations, etc.). Or you can accept the project as is and change how your sheet is laid out to correspond
    to this one.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-28-2017
    Location
    Atlanta, GA
    MS-Off Ver
    Office 2016
    Posts
    6

    Re: Basic VBA for Email - No Attachment Needed - Only Subject, Email, Greeting & Body

    Quote Originally Posted by Logit View Post
    .
    Here is something to more than get you started.

    Please Login or Register  to view this content.
    You'll need to add the code to include your Email Signature. You can Google for "vba outlook add signature". Should return tons of examples.

    Also, you'll need to edit the code so it refers to your present sheet layout (references to columns, cells locations, etc.). Or you can accept the project as is and change how your sheet is laid out to correspond
    to this one.
    Hey Logit,

    Thanks again for the post. I wasn't able to get your example to work.

    Is there any way that you could use the attachment that I originally had for the example?

    I want to be able to have the option to either send automatically or to save as a draft.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Basic VBA for Email - No Attachment Needed - Only Subject, Email, Greeting & Body

    .
    This is one method :

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

    Re: Basic VBA for Email - No Attachment Needed - Only Subject, Email, Greeting & Body

    Please Login or Register  to view this content.
    Last edited by sintek; 08-09-2021 at 03:08 AM.
    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!!!

+ 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. Replies: 0
    Last Post: 02-11-2019, 08:45 AM
  2. [SOLVED] VBA to send email using data from the EXCEL including email address, subject and body text
    By ec4excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2016, 11:07 AM
  3. Hyperlinks into email subject (or body)
    By lcartwright in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2014, 12:59 AM
  4. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  5. Cell value in email subject and cell selection in email body
    By xatomicx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2013, 12:31 PM
  6. export outlook 2007 email into excel with subject and body of email
    By akulka58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 02:37 PM
  7. Replies: 6
    Last Post: 12-02-2011, 02:14 PM

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