+ Reply to Thread
Results 1 to 3 of 3

Macro to send email from Excel sheet through outlook

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    355

    Macro to send email from Excel sheet through outlook

    HI,
    I need macro code to send email from excel via outlook.
    Task mentioned below.

    I have a workbook with multiple sheets.
    I want to email the sheet named as “ SLIP” as an attachment to those email ids mentioned in Sheet “EMAIL ID”
    The sheet “EMAIL ID” contains “A” with ‘”To” email id’s and “B” contains “NAME”, “C” contains CC email ids and “D” contains “BCC” email ids.
    The Sheet “Message Body contains” Message format to be in email.

    So the email should be as below.

    To: winmaxservices@gmail.com; winmaxservices2@gmail.com
    Cc: saravanan@allianceinsurance.in
    Bcc: winmaxservices1@gmail.com; winmaxservices3@gmail.com


    Message body

    Dear Mr.Savio/Mr.Peter/Mrs.Maria,

    Please find attached qlip for your consideration
    Please feel to call us.

    Regards

    Mark

    Note: we may add delete email in respective columns time to time. Also the message body in the sheet also may change time to time.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,385

    Re: Macro to send email from Excel sheet through outlook

    This link should be helpful

    http://www.rondebruin.nl/win/s1/outlook/mail.htm

  3. #3
    Registered User
    Join Date
    11-19-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    2016
    Posts
    57

    Re: Macro to send email from Excel sheet through outlook

    Yup, needed something similar a while ago and that's exactly where i found it. Ron is the man!

    If you are looking for a quick answer though, the below code should work assuming the following:
    - you are using Office 2010 or later
    - your Outlook Object Library is activated (check in Tools/References)
    - your Outlook is running
    - your "slip.xlsm" workbook is your active workbook when you run this code

    I am aware that this code is probably poorly written, stuff was hardcoded, etc., but it should hopefully give you what you are looking for.

    Please Login or Register  to view this content.

+ 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. convert excel sheet to pdf using macro and send that pdf via email using outlook
    By suresh mongam in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-25-2015, 08:51 AM
  2. [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
  3. [SOLVED] Macro to send email from excel using outlook
    By Teblol in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 02-10-2015, 06:47 PM
  4. Send a outlook email through the excel sheet
    By krishnakuma6 in forum Excel General
    Replies: 9
    Last Post: 01-12-2015, 03:58 PM
  5. Excel macro to send email through outlook when expiry nearing
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2014, 08:07 PM
  6. Macro to send notification from excel to my Outlook Email
    By savethisid in forum Excel General
    Replies: 18
    Last Post: 03-27-2014, 02:25 PM
  7. Replies: 1
    Last Post: 10-03-2012, 07:31 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