Send As PDF Attachment

[SnackBar]

Hi

I would like to send a single page from a work book that multiple sheets as
a PDF. Is this possible?

At the moment when i attempt to send by PDF it sends the entire work book.
As i said i would just like to send one page from a sheet.

Is this possible?

Thanks guys.

Adam

 

[Ron de Bruin]

Excel 2007 ?

Try my add-in
http://www.rondebruin.nl/mail/add-in.htm

 

[SnackBar]

Yes Excel 2007

Excel 2007 ?

Try my add-in
http://www.rondebruin.nl/mail/add-in.htm

 

[Ron de Bruin]

You can use the add-in or use this code example
http://www.rondebruin.nl/pdf.htm

 

[SnackBar]

Should i use the code in a Macro? So it literaly just sends the active sheet?
Could i tweak the code to just send the first page of the sheet?

Never really dont anything as complex as that before but it looks good.
Thank you for the help.

 

[SnackBar]

Hi Ron

Code is fantastic! Thank you again.

In your notes it says it is easy to change it to send a range, how would i
go about doing this?

Kind Regards

Adam

 

[Ron de Bruin]

Hi Adam

If you want to send the first page

Change

ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=FilenameStr, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False


To

ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=FilenameStr, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
From:=1, _
To:=1, _
OpenAfterPublish:=False


See also the other examples in the macros above the mail macro