Forum

Filter Table and se...
 
Notifications
Clear all

Filter Table and send to filtered values a table as atachment to Oulook

8 Posts
2 Users
0 Reactions
132 Views
(@meglicma)
Posts: 13
Active Member
Topic starter
 

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

 
Posted : 15/04/2023 8:46 am
(@keebellah)
Posts: 373
Reputable Member
 

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

 
Posted : 16/04/2023 2:28 am
(@meglicma)
Posts: 13
Active Member
Topic starter
 

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.

 
Posted : 18/04/2023 5:34 am
(@keebellah)
Posts: 373
Reputable Member
 

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

 
Posted : 19/04/2023 2:12 am
(@meglicma)
Posts: 13
Active Member
Topic starter
 

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

 
Posted : 19/04/2023 5:41 am
(@keebellah)
Posts: 373
Reputable Member
 

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

 
Posted : 20/04/2023 2:35 am
(@meglicma)
Posts: 13
Active Member
Topic starter
 

Exactly and that is the problem.

Every filtered value should get only 1 excel sheet containing filtered data in it

 
Posted : 21/04/2023 10:29 am
(@keebellah)
Posts: 373
Reputable Member
 

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.

 
Posted : 22/04/2023 2:24 am
Share: