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
What is now your question?
I understand you have an issue but it's not clear from your question and there's nothing in the file explaining what you want en what the question is.
Don't make us guess what you want tell is what you're trying to achieve
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.
Or I did not read your question correctly or you did not explain it correctly
You will need an extra loop in case there are more than one recipients in the SendTo cell
You can create an array loop using the ; as separator for each item.
If you don't know how let me/us know
So if you run now my send code it will generate 5 emails instead of joust 3 for each DSP. it generates as many emails as there are rows
If I take a look at your file (the last one I have here) for each DSP:
Filter ASME will send 4 E-mails
Filter EGET will send 3 E-mails
Filter RAPK will send 4 E-mails
Exactly and that is the problem.
Every filtered value should get only 1 excel sheet containing filtered data in it
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.