![]() ![]() This isn’t an issue with the VBA macro itself but a bug in Windows 7. Outlook becomes inaccessible and Save As dialog doesn’t showĪ common issue is that the Save As dialog doesn’t take the foreground, especially on Windows 7, and as a result Outlook becomes “unresponsive”. Troubleshootingīelow you’ll find a couple of common issues which you could run into when using this macro and how to resolve them. If the message holds external images (such as newsletters), the processing time could increase even more as the images are being downloaded. This can take about 3-5 seconds for a modern computer and 5-10 seconds for older/slower computers. It could take some time before the Save As dialog is shown as the macro first needs to load Word in the background. Add a button for easy access to the macro.Ī button can be added to the main Outlook window or to any of the open item windows.Sign your code so you won’t get any security prompts and the macro won’t get disabled.Note: The word “ ” stands for your version number of Word.Add a reference to: Microsoft Word Object Library.If you copied the code, paste it into a new module. Extract the zip-file and import the SaveAsPDF.bas and/or SaveAllAsPDF.bas file via File-> Import….Open the VBA Editor (keyboard shortcut ALT+F11).Download this code-file ( saveaspdf.zip) or copy the code below.Use the following instructions to configure the macro in Outlook You’ll be prompted to select the folder to save the messages to.īy assigning a button to the macro, you can save messages as a pdf-file as easy as you would have saved it before. The SaveAllAsPDF macro works in the same way but allows you to select more than one email to convert to the pdf-format in one go. In short, it saves the selected message (or any other Outlook item) in the mht-format which is then opened in the background in Word where a Save As operation is initiated for the pdf-format. The SaveAsPDF macro uses Word’s capabilities to save documents as pdf-file. If you decide to order use BH93RF24 to get a discount. ![]() It can also monitor specified folders and automatically save messages as pdf-files in the background for archiving purposes. For instance, it can save a message together with its attachments into a single pdf-file. The available options go well beyond what the macro in this guide or any pdf-printer can do. SaveAsPDF by Sperry Software is an add-in to quickly archive your emails into pdf-files. This is for instance also not possible with a pdf-printer and can be quite a timesaver when you regularly need to save e-mail messages as pdf-files. This guide also contains modification examples to control the default file name for the pdf-file. There are of course alternatives such as a pdf-printer (like “Microsoft Print to PDF” or a 3rd party pdf-printer), using Adobe Acrobat or a 3rd party add-in such as SaveAsPDF by Sperry Software.Īnother way is to use the VBA macro in this guide which uses Word’s capabilities to save documents in the pdf-format.Ī benefit of this macro over most pdf-printers is that any hyperlinks within the message will continue to work and any Internet images are automatically downloaded too.Ī second macro is provided which allows you to select multiple emails, or even all emails within a folder, and save them as pdf-files all at once. Sadly, this option is not available in Outlook, not even in Outlook for Microsoft 365. Word, Excel and PowerPoint files can be saved directly as pdf-files. ![]()
0 Comments
Leave a Reply. |