Command Button that allows user to email and print specific sheet

**KT99** · 09-30-2014, 10:39 AM

Hi all,

I currently have a macro that copies information from sheet 1 to sheet 2 when a checkbox gets checked (in sheet1). What I need to be able to do is have a command button that allows the user to print and email the contents of sheet 2.

Ideally, when you hit the command button on sheet 2, I want a PDF to pop up with all the contents of sheet 2. From there, I would like the email/print function to be possible.

In addition, if with the email function I could have a predetermined email address, subject, and message- that would be great!

If anyone could help it would be much appreciated! I have been working on this for two weeks to no avail!
Thank you so very much

**pareshj** · 09-30-2014, 10:52 AM

Hi,

Check out the below link for Print and Email through VBA:

For Print : http://www.learnexcelmacro.com/wp/20...acro-to-print/

For Email : http://www.rondebruin.nl/win/s1/outlook/mail.htm

Regards,
Paresh J

**KT99** · 09-30-2014, 11:06 AM

Thank you Paresh J,

VBA code to Show Print Preview before actually printing
'Below statement will print 3 copy of the Sheet1 from Page 2 to Page no: 3
02.Worksheets("Sheet1").PrintOut From:=2, To:=3, Copies:=3, Preview:=True

Is there anyway I can add an "email" button to the print preview?
I cant seem to get both an email VBA and a print VBA to work on the same button.

Thank you!