+ Reply to Thread
Results 1 to 5 of 5

VBA Code - Mass Emails

  1. #1
    Registered User
    Join Date
    07-23-2019
    Location
    Buffalo, NY
    MS-Off Ver
    Office 365
    Posts
    8

    VBA Code - Mass Emails

    Hi,

    I was hoping someone may be able to help me. I have some limited knowledge of VBA, and I need to create 2 separate scripts to do the following:

    1. Send an email with the same body, but different fields populated within the body for each email
    2. Send an email with the same body, but different attachments for each email (2 attachments per email, 1 excel document and 1 PDF document)

    *Both scripts will have to send emails to individual people, not one mass email.

    I have all of this information in an excel workbook, but have to send these emails via Outlook.

    I know this is a lot to ask, but any help at all would be so greatly appreciated! Thank you so much!

    Kirsten

  2. #2
    Registered User
    Join Date
    07-23-2019
    Location
    New Orleans, Louisiana
    MS-Off Ver
    2016
    Posts
    2

    Re: VBA Code - Mass Emails

    Hi,

    I'm looking at what you're trying to do and just wanted to throw this in your hat. A newsletter template within .php websites allow for this exact event to occur. I know that's not the answer you were looking for but I'm sure if you research how the newsletters work with TAGS and all that code that replaces brackets with data/info it may help you come up with a skeleton for what you're trying to do thru excel. Hope that helps...

  3. #3
    Registered User
    Join Date
    07-23-2019
    Location
    Buffalo, NY
    MS-Off Ver
    Office 365
    Posts
    8

    Re: VBA Code - Mass Emails

    Hi,

    Thank you for getting back to me so quickly. To be completely honest, I'm not familiar with that but I can definitely look into it. I was hoping for some sort of script that I could copy in and modify based on the attachments I had to attach because someone told me that there was a way to do it using excel/outlook.

  4. #4
    Registered User
    Join Date
    07-23-2019
    Location
    New Orleans, Louisiana
    MS-Off Ver
    2016
    Posts
    2

    Re: VBA Code - Mass Emails

    Duly noted.. I can start writing something and see if it is what you want it to do. Is it only outlook you would like it to work in? I can potentially use the web version of outlook since the coding in outlook on the local device will be unique to each device I am assuming not to mention the versions may be different. When you say different fields populating in the body I will need more clarification. The body itself in the grand scheme of things is a field and it appears the body will be the same content in each email. The subject is considered a field as you know, so is the to: the cc: and the bcc: SO with that being said let me know the fields you are referring to a little more specifically so I can write a script that populates your data.

  5. #5
    Registered User
    Join Date
    07-23-2019
    Location
    Buffalo, NY
    MS-Off Ver
    Office 365
    Posts
    8

    Re: VBA Code - Mass Emails

    Hi!

    For the first script that I mentioned, in terms of different fields I meant within the body of the text there would be different fields based on different people (ex: name, street address, city, state, zip, etc.)

    Unfortunately I do have to use Outlook in order to send the emails. Thank you so much for your help!

+ 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. [SOLVED] Sending Mass Emails on Just Single Click
    By E5254730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2016, 12:22 PM
  2. [SOLVED] Help with VBA mass find and replace code for exact numbers
    By mguti in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2016, 02:02 AM
  3. Issue Finding last row to send mass emails
    By MikeSta4ord in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2015, 03:00 PM
  4. [SOLVED] VBA code for mass email not working HELP!!!!!
    By jcushing82 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-28-2015, 04:01 PM
  5. I am using a VBA code that sends emails
    By starlev in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-20-2015, 08:28 AM
  6. Send personalized mass emails with multiple attachments
    By land_land in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2014, 01:45 AM
  7. Saving Mass Emails to My computer
    By Shazz in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 06-28-2009, 11:16 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