Outlook: How to print email without images
Generally printing an email in Outlook, the images will be printed as well. But sometimes, you just want to print the texts without the images, however, in Outlook, there is no built-in feature that can support this job. This tutorial provides a VBA code that will print the image-free email through Word immediately. Or when your computer doesn't have a printer, the VBA code will export the email as a PDF without images first, and then you can print the PDF after the printer is available.
VBA to print email without images
- Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
- BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
- Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
- Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
- More than 100 advanced features will solve most of your problems in Outlook 2021 - 2010 or Office 365. Full features 60-day free trial.
VBA to print email without images
1. Select an email that you want to print the text only, then press Alt + F11 keys to enable Microsoft Visual Basic for Applications window.
2. Click Insert > Module to create a new blank module, then copy and paste the below code to the module.
VBA: export email without images
Sub PrintWithoutImages()
'UpdatebyExtendoffice20220414
Dim xMail As Outlook.MailItem
Dim xFileName As String, xSubject As String
Dim xWord As Word.Application
Dim xWordDoc As Word.Document
Dim xInlineShape As Word.InlineShape
Dim InvalidArr
On Error Resume Next
If Application.ActiveWindow.Class = olInspector Then
Set xMail = ActiveInspector.CurrentItem
ElseIf Application.ActiveWindow.Class = olExplorer Then
Set xMail = ActiveExplorer.Selection.Item(1)
End If
InvalidArr = Array("/", "\", "*", ":", Chr(34), "?", "<", ">", "|")
xSubject = xMail.Subject
For i = 0 To UBound(InvalidArr)
xSubject = VBA.Replace(xSubject, InvalidArr(i), "")
Next i
xFileName = Environ("Temp") & "\" & xSubject & ".doc"
Debug.Print xFileName
xMail.SaveAs xFileName, olDoc
Set xWord = CreateObject("Word.Application")
xWord.Visible = False
Set xWordDoc = xWord.Documents.Open(xFileName)
For Each xInlineShape In xWordDoc.InlineShapes
xInlineShape.Delete
Next
xWordDoc.PrintOut
xWordDoc.Close
xWord.Quit
Kill xFileName
End Sub
3. Click Tools > References to enable References – Project 1 dialog, tick Microsoft Word 16.0 Object Library checkbox. Click OK.
4-1. Keep the cursor within the code, and press F5 key or click Run button to run the code, then the email without images will be printed immediately through Word. But if your computer doesn’t have a printer, please follow Step 4.
4-2. When your computer doesn’t have a printer, after pressing F5 key or clicking Run button to run the code, a dialog pops out for choosing a folder to place the PDF file, and name the PDF file. Click Save.
Now the email has been exported as a PDF without images. Open the PDF file, and right click to select Print to print the email.
Tip: If you want to bulk save selected emails as PDF (or Word, CSV, Excel, Txt, HTML files) with images, headers, bodies, Ccs, the Bulk Save feature of Kutools for Outlook can help you, which only need 3 steps.
1. Select emails.
2. Click Kutools > Bulk Save.
3. Choose a location and check the file format(s) you want, Click Ok.
Get 30-day free trial of Kutools for Outlook now.
Best Office Productivity Tools
Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook
✔ Email Automation: Auto Reply (Out of Office) / Schedule Send emails / Auto CC/BCC / Advanced Auto Forward / Auto Add Greating ...
✉ Email Management: Easily Recall Emails / Block Scam Emails / Delete Duplicate Emails / 🔎Advanced Search / Consolidate Folders ...
📁 Attachments Pro: Batch Save / Batch Detach / Batch Compress / Auto Save / Auto Detach / Auto Compress ...
🌟 Interface & Interaction Magic: 😊More Pretty and Cool Emojis / Brings Browser Tabs Right Into Your Outlook / Minimize Outlook Instead of Closing ...
👍 One-click Wonders: Reply All with Incoming Attachments / Anti-Phishing Emails / 🕘Show Sender's Time Zone / Send to Recipients Separately ...
👩🏼🤝👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails / Split a Contact Group to Individual Groups / Remove Birthday Reminders ...
Over 100 Features Await Your Exploration! Click Here to Discover More.