+ Reply to Thread
Results 1 to 1 of 1

Automatically match Email ID & send email

  1. #1
    Registered User
    Join Date
    03-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2016
    Posts
    46

    Automatically match Email ID & send email

    I have a macro in my workbook which gives me a report in a particular format (as seen in the data sheet of the attached workbook).
    I need to send daily emails to the party listing them their outstanding dues. I'm looking for a macro which can sort out all the data pertaining to a specific party, select all the pertaining data and send that specfic table via MS Outlook email by pasting the selected table in the body of the email. The email ids can be automatically extracted by vlookup or similar function since the email ids are available in the contacts sheet of the workbook.
    Thanks in advance.
    Attached Files Attached Files

+ 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] Macro to automatically send email
    By silversurfa23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2014, 02:56 PM
  2. Workflow with signatures (if cell=x then send email, if signed then send email)
    By Kate2811 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 05:37 AM
  3. Need help with getting excel to automatically send out email....
    By glynjara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 06:57 PM
  4. Email will not automatically send
    By cgduck21 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-11-2013, 03:22 PM
  5. Send New Email W/ Body of Received Email, Then Delete Sent Email
    By edneal2 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 07-01-2013, 12:45 AM
  6. Need Excel to send Automatically an Email
    By japorms in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-20-2011, 02:57 AM
  7. Macros to send email automatically
    By prague in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-17-2006, 07:50 AM

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