In Excel you can us Save As to save a file as a pdf, but it isn’t quite as effective in Excel as it is for MS Word. Often you only want to save a single sheet or a few sheets to pdf. Try this.
I use a free Windows App called CutePDF Writer. It is OK to use it for commercial use – see image below from their website.
This app works just like a printer. You make your printing selections as per normal and then select CutePDF Writer as your printer and Print.
It opens a dialog where you can select what to call the file and where to save it.
Click the button below to see more details of CutePDF Writer and to download it.
[button href=”http://www.cutepdf.com/Products/CutePDF/writer.asp” primary=”true” centered=”true” newwindow=”true”]Go to CutePDF site for more details[/button]
If you are interested in using a macro to automate the pdf process you can check out the button below to go to Ron DeBruin’s site. His page has lots of resources on pdf and emailing.
[button href=”http://www.rondebruin.nl/win/s5/pdf.htm” primary=”true” centered=”true” newwindow=”true”]Link to Ron Debruin’s pdf page[/button]
Hi Neale,
I have been searching for a way to create a mail merge in MS Word & then e-mail the documents automatically as a PDF, but despite all my efforts, it appears that this is not possible.
Your link to Ron de Bruin’s site may have given me a workaround solution. I will just need to create the “letter” in Excel instead of in Word. I can then run Ron’s macro (with a few tweaks) to automatically e-mail the PDF from Outlook.
Thanks again for your informative posts!
Cheers
Chris
Hi Chris
Yes, Ron’s site has some excellent code. I have used it to automate email sending and pdf creation.
BTW Excel VBA can create a Word document from text in a sheet.
Glad you found the post useful.
Regards
Neale
Appreciate the recommendation. Let me try it out.