One Click Excel Information and send out thru Email

[TraceyNoe]

Can you please help me with making this happen?

1.) Just to keep this simple...Here is the raw Data from Excel (These cells are formatted with boarder lines surrounding each cell)

[TABLE="width: 642"]
[TR]
[TD]PO Date[/TD]
[TD]Po#[/TD]
[TD]Vendor[/TD]
[TD]Provide Tracking#[/TD]
[TD]Vendor Email[/TD]
[/TR]
[TR]
[TD]3/15/19[/TD]
[TD]WZ-54244-P[/TD]
[TD]NISSAN[/TD]
[TD][/TD]
[TD]tracey.noe@abc.com[/TD]
[/TR]
[TR]
[TD]2/12/19[/TD]
[TD]WZ-12574-P[/TD]
[TD]VALLEN[/TD]
[TD][/TD]
[TD]tracey.noe@xyz.com[/TD]
[/TR]
[TR]
[TD]4/7/19[/TD]
[TD]WZ-65544-P[/TD]
[TD]VALLEN[/TD]
[TD][/TD]
[TD]tracey.noe@xyz.com[/TD]
[/TR]
[TR]
[TD]5/5/19[/TD]
[TD]WZ-32711-P[/TD]
[TD]NEATNOE[/TD]
[TD][/TD]
[TD]ttt@yahoo.com[/TD]
[/TR]
[TR]
[TD]2/27/19[/TD]
[TD]WZ-85117-P[/TD]
[TD]VALLEN[/TD]
[TD][/TD]
[TD]tracey.noe@vallen.com[/TD]
[/TR]
[TR]
[TD]2/12/19[/TD]
[TD]WZ-12574-P[/TD]
[TD]NISSAN[/TD]
[TD][/TD]
[TD]tracey.noe@abc.com[/TD]
[/TR]
[/TABLE]

2.) These rows are in no particular order. The end result that I need to make happen is....(In BEST case scenario...each day open the excel report and click 1 button and all lines associated with the same email address all get sent to those emails individually at one time That would include the exact subject, body and signature ....or in the next best scenario...If I have to I could first sort by the email addresses and then click one email address and it would pull all rows associated with that email address and send it. Then I would go to the next email address and send and so forth.

3.) I need this to be as automated as possible. Please assist on how this can be done.

Thank you,
Tracey Noe

 

[BigDawg15]

Tracey,

Try the attached. Adapt as necessary.

 

[BigDawg15]

sorry Tracey I have a working file but am unable to upload.

BigDawg15

 

[BigDawg15]

I will post the code and specifics later this evening.

BigDawg15

 

[BigDawg15]

Tracey,

Sent you a PM, check our Inbox.

Regards,

BigDawg15

 

[BigDawg15]

Check your inbox not our.

BgDawg15

 

[Joe4]

Sent you a PM, check our Inbox.

BigDawg15,

Please post all code/solutions to the thread, and do not send them via PM, per rule 4 here: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Thank you.

 

[Joe4]

Tracey,

I removed the email address from your original post, and "dummied up" all the email addresses in your table.

We strongly advise that you do NOT post real email addresses to the public forums, as Spambots patrol internet forums looking for email addresses to harvest and Spam.

Likewise, also be sure to never post any personal or sensitive data to the public forums.

Thank you.

 

[BigDawg15]

Joe4,

I've tried to post the codes 5 times and every time the site crashes halfway through typing the post and restarts this page.
In the interest of aiding the OP I went the PM route.

Don't know why it continue to crash.

BigDawg15

 

[Joe4]

I've tried to post the codes 5 times and every time the site crashes halfway through typing the post and restarts this page.
In the interest of aiding the OP I went the PM route.

It sounds like you may have a corrupt cookie on your computer. Try deleting your cookies, cache, and temporary internet files to see if that fixes it.

Also, to prevent from "timing out", you can click on the "Remember Me" check box when you log in. Just make sure that you only do that from a personal computer/device (and not from a publicly shared computer).