Hello everyone,
I am trying to find out if there is a way to first create a PDF document from the Print_Area (colored range) of the Worksheet named "Chavo". Secondly open outlook and attach the PDF document. Email it to the supervisor in column J and carbon copy to all of the emails from K to M column of that particular employee by looking in cell IA. I believe in order to accomplish this the macro or function should first copy the colored area, then look up the value in cell I4 in the EmailAddress Column A:A and match from J to M column.
See attachment
Again,
Thanks to everyone who contribute to this wonderful forum.
Bookmarks