Send As PDF Attachment

  • Thread starter Thread starter SnackBar
  • Start date Start date
S

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
 
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.
 
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
 
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
 
Back
Top