Try to search your question here, if you can't find : Ask Any Question Now ?

Convert excel print page to pdf and send to email on the print page

HomeCategory: stackoverflowConvert excel print page to pdf and send to email on the print page
willson asked 3 weeks ago

I’d like to make a VBA code in excel but I’m stuck. I want it to take my worksheet where I have several pages to print (50 pages in one worksheet).

On every print page there is a sum and if that sum is greater than 0 I want to convert that page to a pdf and send the print page to the email on the page (so it’s different emails).

The sum is in F22 and email is in B8 on page 1.

The sum is in F72 and email is in B58 on page 2.

So the range changes by 50 rows every page.

The emails area is B2:F50 on first page and B52:F100 on second page, B102:F150 on the third.

I have tried but can only do it with 1 page and 1 email.

Hope you can help

1 Answers
Best Answer
Arben answered 3 weeks ago
Your Answer

15 + 0 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com