Sending excel as a PDF Attachment

D

daffyyd

New Member
Joined
May 11, 2011
Messages
4
Hi Good People,

Am trying to use Excel 2007 to send documents as PDF attachment. I have noticed that the system generates all the sheets into a single PDF while I need each sheet to be a separate PDF attachment.

Is it possible?

Regards
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
Hi Daffyd,

If you click on the "Office Button" in excel and click "Print" change the printer in the drop down box to "Adobe Printer" and choose "Active Sheets" then click OK - it'll PDF just the sheets you have selected.

J
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question Question
Emailing from Excel and automatically attaching pdf
Replies
1
Views
344
dermie_72
D
D
  • Question Question
Save sheet as PDF to a set folder and then email it in outlook using set credentials
Replies
1
Views
65
Logit
Logit
A
  • Question Question
Sending Automated Emails with Attachments via Outlook
Replies
1
Views
270
Micron
M
T
  • Question Question
Printing to PDF use VBA - Was working but now different sheets are different widths
Replies
1
Views
268
Tanquen
T
K
  • Solved
Macro : Email Worksheet As PDF
Replies
3
Views
478
Domenic
D

Forum statistics

Threads
1,224,506
Messages
6,179,158
Members
452,892
Latest member
yadavagiri

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top