+ Reply to Thread
Results 1 to 3 of 3

Advanced Macro, sending emails in outlook

  1. #1
    Registered User
    Join Date
    08-16-2014
    Location
    dublin
    MS-Off Ver
    2010
    Posts
    24

    Smile Advanced Macro, sending emails in outlook

    Hi,

    I have a major task in front of me (sending individual emails to over 2000 vendors, asking them to fill in a form).

    I would like to try to make it simpler but my Macro level has reached its limits. I will provide you with an explanation and hopefully someone can assist.

    - I have a report capturing different information such as vendor unique ID, vendor name, email address. (main Report
    attached)
    - I have another excel book with a standard email in a text box (email and form, sheet 1)
    - I have another excel book with a standard form to send to the supplier. (email and form, sheet 2)
    Email test.xlsxEmail and form.xlsxMain Report.xlsx

    What I need its to have a Macro that will generate an email containing the below:

    - Email text should be: the text in (email and form, sheet 1)
    - Attachment should be: the form in "email and form, sheet 2" and the "supplier ID, and Name" from "main report"

    the Macro should enable me to capture to generate excel sheets attachment and then to send them to the correct email address.

    I appreciate your assistance with this and do not hesitate to come back to me for more details.

  2. #2
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: Advanced Macro, sending emails in outlook

    let me summarize your Request to see if i got it right.

    You want a macro that goes through the List (Main_Report)
    1. Grab the SupplierID and SupplierName
    2. Paste that to the RequestForm (email and Form)
    3. The Result would be (Email Test)
    4. That result Sheet should be attached to mail and send to the supplier

    Is that correct?

  3. #3
    Registered User
    Join Date
    08-16-2014
    Location
    dublin
    MS-Off Ver
    2010
    Posts
    24

    Re: Advanced Macro, sending emails in outlook

    Well, that's sounds like what i need to have, Added a few details below if this can help

    1. Grab the SupplierID and SupplierName
    2. Paste that to the RequestForm (email and Form)
    4. Generate a sheet for each vendor Unique ID
    5. Generate an email using the email address in the main report (this email should have the text f
    rom email and form sheet 1
    3. The Result would be (Email Test)
    That result Sheet should be attached to mail and send to the supplier

    cheers

+ 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. Macro help with sending emails from outlook base on excel dates
    By Wery123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2015, 12:42 AM
  2. Help with sending emails via outlook using VBA codes
    By muheebrahman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2013, 04:48 AM
  3. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  4. [SOLVED] Sending emails in outlook body
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2012, 03:34 PM
  5. Problems with outlook sending emails
    By L_ter in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2009, 06:54 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