+ Reply to Thread
Results 1 to 8 of 8

send nested table/list in email from list based on name criteria

  1. #1
    Registered User
    Join Date
    10-21-2020
    Location
    london
    MS-Off Ver
    10
    Posts
    5

    send nested table/list in email from list based on name criteria

    Hi

    not sure if I have described correctly, I have a list of parts in Column A (longlist) and a list of names in column B and I want to consolidate parts in A by NAME send in list or table of parts in one email to each name. I have looked at macros but can not find how to do this. the site would not let me attach example so have put below. email name and email address column E & F

    For ATD = one email listing 33131, 1321321,21654868,2346546 to ATDEMAILADDRESS

    PART NAME
    121212 TASS
    33131 ATD
    121321 MLA
    546456 BWY
    1321321 MLA
    32121 ATD
    21654868 ATD
    2346546 ATD


    THANK YOU FOR YOUR HELP

  2. #2
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,570

    Re: send nested table/list in email from list based on name criteria

    It would be best if you could attach a sample file, as per yellow banner above.

  3. #3
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,570

    Re: send nested table/list in email from list based on name criteria

    Here you go

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-21-2020
    Location
    london
    MS-Off Ver
    10
    Posts
    5

    Re: send nested table/list in email from list based on name criteria

    thank you - that macro is well above my understanding level

    it does send the filtered emails but it sends all emails to the first email address in the list rather than match the email address to name. I'm not sure how to change this?

  5. #5
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,570

    Re: send nested table/list in email from list based on name criteria

    Please provide a sample file as per the yellow banner above so I can see what you mean. Right now the file structure assumes each line has the email. Does the name list only have the name and email and is independent of the list?

  6. #6
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,570

    Re: send nested table/list in email from list based on name criteria

    Alright, here is an updated macro. Let me know if you need anymore help

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,570

    Re: send nested table/list in email from list based on name criteria

    If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  8. #8
    Registered User
    Join Date
    10-21-2020
    Location
    london
    MS-Off Ver
    10
    Posts
    5

    Re: send nested table/list in email from list based on name criteria

    thank you this works perfectly, thank you for helping me !

+ 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. VBA: Automatically send email based on a Criteria
    By cinnamorolls in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2020, 11:38 PM
  2. [SOLVED] Need to be able to send email with attached PDF file based on a list
    By jkhuskies in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2019, 03:55 AM
  3. Replies: 0
    Last Post: 10-03-2017, 08:22 AM
  4. Replies: 1
    Last Post: 08-01-2016, 10:50 AM
  5. send email through Lotus Notes, with attachment, based on exce list address and path
    By ABDULLAHHATMI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2013, 11:11 AM
  6. send email from XL list of email address
    By pauluk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2009, 11:36 AM
  7. send email from address list
    By garfield in forum Excel General
    Replies: 1
    Last Post: 06-14-2007, 08:22 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