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

[Excelidiot01]

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

[maniacb]

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

[maniacb]

Here you go

Please Login or Register  to view this content.

[Excelidiot01]

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?

[maniacb]

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?

[maniacb]

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

Please Login or Register  to view this content.

[maniacb]

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.

[Excelidiot01]

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