Results 1 to 16 of 16

Send mails with attachments using a macro

Threaded View

  1. #1
    Registered User
    Join Date
    03-17-2017
    Location
    Amsterdam
    MS-Off Ver
    2007
    Posts
    14

    Question Send mails with attachments using a macro

    Hey Guys,

    I'm looking for a macro which will send some emails for me using outlook. But I just can't find what I'm searching for (I've been looking for hours now).
    It's kinda complicated in my opinion, but you guys can probably figure this out. (atleast I hope so)

    This is what I want to achieve:

    I want the macro to fill in the receiver from column E
    Than I need it to fill in the CC field with a adres specified in column G
    Than I would like to add the subject from cell J5 (always the same cell so I can change the subject manually for all mails at once)
    Than I want to attach the file, from which the location (localy stored) is specified in column B

    Now the first part is done, I want to write my email message.
    There are 2 different mails, one in english and one in dutch (my main language), which language the receiver speaks is specified in column H.

    So if column H says "English" I want it to add the text from cell J1 to my mail, this cell says "Dear " (if Dutch I need it to add text from J2, saying "Geachte "
    Now I need the macro to add the name from the receiver, which is specified in column C. (this should make the first sentense say "Dear John" for example

    Now for the rest of the mail I need the macro to look up column H again, if that cell says "English" it needs to add the text from cell J3 which contains the rest of the message in HTML format. (if the cell in column H says "Dutch" it needs to add text from cell J4 which contains the same message in HTML format, but than in dutch)

    I need the macro to send a file for every row filled with information in column A. (this is column that changes, I load a list with people I need to mail into that column, all other columns have VLOOPUP's to fill in the appropiate information (email adresses names etc.)

    If someone could help me out on this it would mean the world to me.

    Thanks in advance,
    Jerry
    Last edited by Warmerfare; 03-24-2017 at 11:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I want to set up a macro? that will send e-mails from Excel based on a date
    By Chuck@kayaknw.org in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2016, 01:42 PM
  2. I want to set up a macro? or to send e-mails from Excel
    By Chuck@kayaknw.org in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2016, 01:05 PM
  3. Send multiple emails with different attachments if attachments found
    By AnkitJain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2015, 05:35 AM
  4. [SOLVED] Macro to send mails from outlook as per the email ids in excel
    By arun.sj in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-03-2015, 12:10 PM
  5. Excel containing macro to send bulk mails from outlook with multiple attachments
    By amandeep08 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 02:19 PM
  6. add attachments and send macro buttons
    By ea223 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2013, 04:14 PM
  7. Macro for lotus to send individual mails to various receiptents
    By senthilkumar.k.chinn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2011, 12:41 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