printing a specific worksheet everytime

T

Trevor

I have made a quoting program in excel 07 that has 5 different worksheets
involved in it. I would like to send it as an e-mail attachment every time
as a .pdf. I see the option for "send e-mail as .pdf attachment" but I can't
figure out how to only send the worksheet that I want to send (just 1 of the
5 worksheets needs to get sent).
 
D

Don Guillett

If all else fails>save the worksheet as a copy to a NEW workbook and send
that. Do by macro if desired.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I print a specific worksheet everytime? 1
Mail Merge skipping records/sending one at a time 0
Drop down list control value in vba 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Email a single Excel worksheet instead of the whole workbook. 2
Sending e-mails from specific email address 2
Printing a specific date & hour in project 0
e-mail a worksheet from a spreadsheet 2

Top