March 22, 2023
HI All
Again i need some help because i can´t find any useful answers on the net.
Problem:
Filter table in column A and then send the filtered table to the address in separate sheet (DSP EMAILS) based on filtered values in column A.
Ideally with the file name set as filtered value and the date from column E!
I lost a whole day searching for a solution. 😀
Macro for SORT is done. joust the mail macro is the tricky one
Trusted Members
October 17, 2018
March 22, 2023
The issue is when i run my macro it does a loop but also sends an email with attached excel to all the filtered values - that means that every value in the filtered data (DSP) gets an email and that means if there are 3 identical names with different values it sends out 3 mails.
Trusted Members
October 17, 2018
Trusted Members
October 17, 2018
Trusted Members
October 17, 2018
You mention several mails but not how many attachments per mail.
Please be more specific else set the macro to save the mail instead of display or send, that way you can actually check wht's being sent.
When you select .Save the mail is saved in the Draft folder
Like I mentioned, I do not have Outlook installed locally so cannot test for you.
1 Guest(s)