+ Reply to Thread
Results 1 to 4 of 4

Send email if criteria in a column, matches name in a lookup table

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    76

    Send email if criteria in a column, matches name in a lookup table

    Hi

    Attached is my workbook, one tab has the lookups with email addresses and the other tab has the data, both data sources are in tables.

    I would like the table 'ExpenseData' in the Data tab, to be emailed to the relevant person in column U.

    I have no idea where to start with this code, please help.

    Secondary question - is best practice the way my data is laid out now or should I split the data into different tabs, based on column U?

    Thank you
    Attached Files Attached Files
    Last edited by MushroomFace; 02-02-2021 at 12:17 PM.
    If you like my answer please *Add Reputation

  2. #2
    Registered User
    Join Date
    06-04-2009
    Location
    Stourbridge
    MS-Off Ver
    Excel 2013
    Posts
    26

    Re: Send email if criteria in a column, matches name in a lookup table

    Hi,

    Attached is the xlsm workbook version of your file with a macro that filters the Data table based on the name (Column A) on the lookup sheet.
    It loops through each name in the Lookup sheet column A and sends the table data to them.

    I don't know if this is the way around you want to determine a mail.
    Attached Files Attached Files
    Last edited by daverunt; 02-02-2021 at 10:48 AM.

  3. #3
    Registered User
    Join Date
    05-31-2013
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    76

    Re: Send email if criteria in a column, matches name in a lookup table

    Hi,

    Fab, it works! I will now reverse engineer what you have done. Much appreciated!

  4. #4
    Registered User
    Join Date
    06-04-2009
    Location
    Stourbridge
    MS-Off Ver
    Excel 2013
    Posts
    26

    Re: Send email if criteria in a column, matches name in a lookup table

    Great. Thanks for the feedback.

+ 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] send nested table/list in email from list based on name criteria
    By Excelidiot01 in forum Outlook Formatting & Functions
    Replies: 7
    Last Post: 11-13-2020, 08:28 AM
  2. [SOLVED] Return Lookup value online if column matches criteria?
    By rgunter in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-19-2017, 02:06 PM
  3. Code to send email with table on the email body via gmail
    By ivhee00 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2017, 12:24 AM
  4. VBA should not allow to send an email if criteria is not met.
    By sat1591 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2014, 12:15 PM
  5. Send email when criteria is met
    By ball32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2014, 05:36 PM
  6. VBA code to send email to the people whose email address is in the Access table
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2014, 05:11 AM
  7. Macro to send email based on lookup of user column
    By ccomito1223 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2010, 03:19 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