Export Outlook PDF Attachment as JPG?

Status
Not open for further replies.

Owl

Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Hello!

I'm rather new to VBA. I have working code to save pdf attachments to a folder. Is there a way to convert these attachments to an image filetype such as jpg using VBA? I've looked all over the web, but the only solution I can find is to open the pdf in PowerPoint and export it as a jpg, which sadly muddies the quality (I've tried changing the size but it always appears a bit blurry even when I set image size and quality to 330ppi and check "do not compress" and it only exports the first page of the pdf). I tried opening the pdf in Word to save as jpg but it loses some of the pdf content and again will only save the first page. Is there a way to export or convert an outlook pdf attachment to a jpg using VBA? Thank you! 😖
 
So far, I have found solutions using Adobe Acrobat Pro, or another software, or a printer driver that prints to image, but nothing utilizing just Microsoft Office software. Due to the sensitive information contained in the PDF, uploading it somewhere else to convert it really isn't an option.
 
I'm reasonably certain that it's doable with just the Office suite (specifically, Word), but it's not quick and might be a bit hit and miss...I completely understand the need to keep things off the internet, and the IT departmet at work would have a collective fit if I even asked about the possibility of installing free software on the work laptop, but how about free PDF tools that do this and do not need to be installed whatsoever?

Specifically, I'm thinking of the XPDF tools (link). There is one small exe into the tool suite that converts PDF files to PNG. If that's ok, it's a fairly trip from PNG to JPG. Is that doable?
 
I'm reasonably certain that it's doable with just the Office suite (specifically, Word), but it's not quick and might be a bit hit and miss...I completely understand the need to keep things off the internet, and the IT departmet at work would have a collective fit if I even asked about the possibility of installing free software on the work laptop, but how about free PDF tools that do this and do not need to be installed whatsoever?

Specifically, I'm thinking of the XPDF tools (link). There is one small exe into the tool suite that converts PDF files to PNG. If that's ok, it's a fairly trip from PNG to JPG. Is that doable?
Hello Dan! Thank you for your response, I've actually stumbled across XPDF and tried to utilize it before, but my company has things so tight that even that won't do - this tool still needs an installation to work. Hence, why I'm trying to figure out a pure Office workaround. I may just have to pitch this tool or Adobe Acrobat Pro and see if I will be able to utilize it with approval but if conversion can be done using Office that's my best bet at the moment so I'm still searching around and trying to mock-up my own code.
 
I remembered that I never updated this! I ended up utilizing Adobe Acrobat Pro to export pdf email attachments as JPEG images. My company had already approved the use of Acrobat Pro, so I went with it.

The code that I wrote requires that users select an email with the pdf attachment they want to convert and press a button mapped to the macro. The macro then asks what folder the user wants to save the exported JPEG images to and converts the pdf attachment. It saves the images into a new subfolder in the selected folder with the date the code was run, and a number appended to the end (to prevent the subfolder from being overwritten).

The macro marks the email as read and sorts it into the inbox folder that matches the name of the folder selected. For example, if you save the images to folder "A" on your computer, there has to be an email folder also called "A" for the program to move the email to after the conversion. This keeps things neat and tidy! I also created a rule that would alert users when they received an email that may have a pdf attachment.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
T How to Export & Import GMAIL Contacts into Outlook 2021 ? Using Outlook 4
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
J Export Zimbra to Outlook PST Using Outlook.com accounts in Outlook 1
C Export NSF Lotus Notes files in Outlook PST format? Using Outlook 1
C How to export Outlook data to csv? Using Outlook 0
T How to Export mailbox from Outlook 2019 to MBOX format? Using Outlook 1
R How To Repair OST File & Export OST File to Outlook PST ? Using Outlook 3
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
Diane Poremsky Export (Save) Outlook Contact photos Using Outlook 0
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
H How to export *all* fields from Outlook Using Outlook 2
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
M Outlook 2013/365 won't export 99% of my contacts to csv Using Outlook 2
T Outlook 2007 Export tasks to Excel Using Outlook 2
Sarge USMC Cannot import/export Outlook 13 Using Outlook 6
L Outlook 2007 Codes Export and Import Using Outlook 9
L Outlook 2007 Toolbar Export and Import Using Outlook 7
F Export Outlook contacts by One Category Using Outlook 1
M outlook shared calendar data export to excel sheet Using Outlook 1
O Export (save) Outlook Contact photos Using Outlook 2
D Export Outlook Calendar Using Outlook 1
C Outlook 200? - Script Export Rules Using Outlook 1
K outlook 2007 Export/Import Distribution lists Using Outlook 1
P Cannot export contacts with Outlook 2003 Using Outlook 10
C outlook export to excel in real time Using Outlook 3
M Why msg files are differ after export from Outlook to filesystem? Outlook VBA and Custom Forms 4
R Export email from Outlook into Access... Outlook VBA and Custom Forms 3
K Disabling import/export button to restrict PST creation Using Outlook 3
K Export Folder to PST Outlook VBA and Custom Forms 2
R Outlook 2010 How do you export 2 email Accounts' 2010 Inbox Files to new computer (2019)? Using Outlook 0
M Export-Import .pst file problems Using Outlook 2
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
S How to export urls from email to excel and check the status of the url ? Using Outlook 5
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
JohnViuf Export task list view settings to other pc Outlook VBA and Custom Forms 16
N Export details to a excel spreadsheet using macros Using Outlook 0
avant-guvnor Export Calendar, Birthdays and Holidays Outlook VBA and Custom Forms 0
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
A How to export one email data to excel Using Outlook 1
B Macro To Create Rule To Export From Certain Folder Email Information in one workbook multiple sheets Outlook VBA and Custom Forms 0
E Exchanger service export detection Exchange Server Administration 1
R Correct a wrong csv export file from WLM 2012 Using Outlook 0
K Export Organizational Forms Library Exchange Server Administration 1
E RSS export as OPML problem Using Outlook 4
A export free / busy from exchange Exchange Server Administration 0
C Export to excel missing items, but a larger total? BCM (Business Contact Manager) 6
J Opening/Archiving/Import/Export PST files Using Outlook 4
H Select one of Contact-Mailadesses to Export > Excel or Winword Outlook VBA and Custom Forms 2

Similar threads

Back
Top