LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Command Button - Macro to print to pdf, then send pdf to email.

Hi Travis

Code on my page for excel 2007 and a link to Ken's site for older versions
http://www.rondebruin.nl/pdf.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tdahlman" wrote in message ...
I have a command button in my Excel spreadsheet where it will look at the
email address typed into a specific field and email the excel file to that
email address.
What I want to do is when I push the button, First have the page print to a
pdf, then send only the pdf file to the email address specified.

How do I add in the step of printing to a pdf.

Thanks in advance,
Travis

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Open Spreadsheet using Command button [email protected] Excel Discussion (Misc queries) 0 August 23rd 07 01:08 PM
Excel email mode send button?? JerryCic Excel Discussion (Misc queries) 1 August 7th 07 09:25 PM
Can I send a doc to group of email addresses via a macro button? Richard F Excel Discussion (Misc queries) 6 February 5th 07 09:59 AM
Auto Send email from IF command Stuiart Excel Worksheet Functions 0 November 13th 06 02:11 AM
Send to command - change default email application? Helen Setting up and Configuration of Excel 2 August 16th 05 02:31 AM


All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"