Solved

Converting Outlook email with attachments to PDF

Posted on 2014-01-23
6
858 Views
Last Modified: 2016-02-11
I have a folder in Outlook that I would like to convert the emails to PDF, this isn't so difficult however the attachments end up as links, how do we extract the links to PDF files?

Using Adobe Pro XI
0
Comment
Question by:WORKS2011
  • 3
  • 2
6 Comments
 
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39803467
What file types are the attachments that you want to convert to PDF?
0
 
LVL 17

Author Comment

by:WORKS2011
ID: 39803518
mostly PDF's or word documents.
0
 
LVL 53

Accepted Solution

by:
Joe Winograd, EE MVE earned 500 total points
ID: 39803790
I suggest the following process:

(1) Save or detach the attachments from all emails. There are many ways to do this. Here are two ideas:

(a) Use some VBA code, as shown here:
http://gallery.technet.microsoft.com/Save-attachments-from-5b6bf54b

(b) Get a commercial product. I've been using MessageSave from TechHit for many years – it is an excellent product. The same company has a product called EZDetach:
http://www.techhit.com/ezdetach/outlook_attachments.html

Note the comment, "Easily save attachment(s) from one or multiple messages (or folders) with a mouse click." I haven't used EZDetach, but based on my many years of successful usage of MessageSave, I'd recommend giving EZDetach a try (and they offer a download for a 30-day free trial).

(c) Here's another example of a commercial product, from a recommendation by a Microsoft MVP that I saw on the MS Office Forum:
http://www.howto-outlook.com/addin/sperry_attachsave.htm

Note the comment, "...you can scan all your previous email messages for attachments, not just new ones that come in". I cannot vouch for this product as I haven't used it.

(2) After saving all of the attachments in a single folder, you would, presumably, leave the PDF files as-is and convert the other files (Word, Excel, whatever) to PDF. Once again, there are many ways to do this, including VB or VBA code that loops through all of the files in the folder. Here's just one example that may not work exactly as you need, but should be tweakable:
http://www.mobileread.com/forums/showthread.php?t=138076

And, again, you could look for a commercial solution. Here's one:
http://www.a-pdf.com/office-to-pdf/index.htm

I use several A-PDF products, although not this particular one. But based on my success with their other products, I wouldn't hesitate to give it a try – and there's a free trial version, so you can see if it works for you. It supports the newer office formats (such as DOCX and XLSX) in addition to the old ones (such as DOC and XLS). It has GUI, Command Line, and Watched Folder interfaces.

Regards, Joe
0
 
LVL 17

Author Closing Comment

by:WORKS2011
ID: 39810469
thanks for the quick response
0
 
LVL 53

Expert Comment

by:Joe Winograd, EE MVE
ID: 39810527
You're welcome. Happy to help. Regards, Joe
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Pop culture is prime bait for hackers seeking to infect user’s computers and mobile devices with malicious malware. Hackers know exactly what the latest trends are online and know how to use them to their advantage.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question