Email 2 sheet ranges as 2 pdf files to email specified in a cell

Hello,

i have a macro that prints a range in CSS sheet into pdf and attach that pdf to a Outlook email. Also that email has a subject, destination and cc according to cells in that same sheet. It works great for my purposes.


However sometimes i have the need to send 1 email with that same pdf attached and also a pdf attached of a second sheet VSP, with same rules, range defined in VSP cell AY10, email destination, body text... The same.

First macro for CSS is great, don´t wanna change anything

I just need a second macro (very similar to first) that will create an email with first pdf (css sheet) and also a second pdf (vsp sheet), with name as in VSP cell AY16, attach both files to a Outlook email with body text as in vsp AY 14, email destination AY19, CC as in AY12.


Can someone help me with the code to create email that attach both pdf´s ?

Attached will be a example file with code working great for 1 sheet

Many thanks and hoping someone can help.

Hi,

I already copied your code to my original file and is working great! Many many thanks for the help.

Have a nice day.