Show
Use Word mail merge to send emails, with all the missing features added back in. Features like adding attachments, having a custom subject, using the CC and BCC fields, using "Send As" (e.g. send as the CEO - you know you want to), and best of all you can save to drafts to check the emails before they go out.
IntroductionWord’s mail merge feature gives you the ability to send emails, but the system lacks many essential features. Below we will provide you with a Word Macro and take you through how you can use it to create and send emails using Word mail merge with all the missing features available to you. The VideoThe Super Quick Version
Errors in the source data will cause the email to be saved as a draft with the errors listed in the body of the email (e.g. “attachment does not exist”). Major errors will cause an error box with an error number and text. If you get a popup box, please contact Imnoss. The Macro****** UPDATE! – Windows code updated from what is shown in the video ****** Original code at bottom of article. The Long VersionAdding the MacroTo add a macro to Word you will need to be able to see the Developer tab. If you don’t have this appearing, that’s perfectly normal for Word, they hide it by default. To make it appear is you just right-click anywhere in the ribbon and select “Customise the Ribbon”. In the dialogue box which appears make sure the checkbox next to Developer in the right-hand column is checked. Once done press Ok, and the Developer tab will appear in the Ribbon. This contains the Visual Basic and Macro buttons on the left-hand side. Click the Visual Basic button in the Developer tab to open the Visual Basic editor where we will add our macro. If you do not see a window called “Project” then click on the View menu and select “Project Explorer”. This will bring up the Project window. In this window right-click on “Normal” and in the contextual menu select “Insert” and then “Module”. A new file called “Module1” will appear in the Modules folder under “Normal” (the file may have a different number if Module1 already exists). The middle of the window will be a white canvas – this is the editing space for the new module. Copy the Macro from this article and paste it into the middle of the VBA editor. Finally, you will need to add two libraries: Microsoft Outlook xx.x Object Library (replace xx.x with version number) and Microsoft Scripting Runtime. To add them, use the “Tools” menu and select “References”. Tick the checkboxes next to the two libraries and press OK. Preparing the DataStart by preparing your data exactly as you would for a normal mail merge – i.e. a sheet in Excel with headers in the first row and data underneath. Add in headers for the email fields you want to add or change: To, CC BCC, Subject, Importance, Sensitivity, ReadReceipt, DeliveryReceipt, DeliveryTime, Account, SendAs, Attachment. Prepare your data exactly as you would for a normal mail merge - i.e. a sheet in Excel with headers in the first row and data underneath Add in headers for the email fields you want to change: To, CC BCC, Subject, Importance, Sensitivity, ReadReceipt, DeliveryReceipt, DeliveryTime, Account, SendAs, AttachmentPopulate mail merge data tableYou will need at least one of To, CC and BCC, and a Subject is recommended, all the other fields are optional and if omitted or left blank they will remain at your defaults. To populate these fields you can type the data in or use formulas.
Multiple “Attachment” fields (i.e. multiple columns) can be used. If you wish to give the columns different names put a number after the word Attachment and it will still work (note, only a number, so Attachment1 works, Attachment_1 does not work). The attachments are identified by their file path. Holding Shift while right-clicking on a file in Windows Explorer will give you the option to “Copy as path” which will copy that file path to the clipboard to be pasted into Excel. You can use this technique after selecting many files. Copying and pasting in multiple file paths enables you to use VLOOKUP or MATCH to check the attachments are available and to add them to the table (see video for “VLOOKUP with Wildcards” technique). Preparing the Mail Merge TemplatePrepare your mail merge template as you would any other mail merge to email. The email specific fields can be ignored. Prepare your mail merge template in Word as for a normal mail merge - there is no need to add the extra fields anywhere Running the Mail Merge to PDFIn the Developer tab click the “Macros” button. Select the macro “EnhancedMailMergeToEmail” and click Run.
Sit back and let the magic happen. Original code shown in video
This code is provided for reference. If you get an error with the updated code above you will almost certainly get an error with the code below. We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. Can you add a PDF Attachment to a mail merge?Mail Merge a PDF with Word
Step 3: Click on Start Mail Merge. Step 4: Click Select Letters. Step 5: Now click the Select Recipients option, as well as select your data source (Excel File or CSV). Step 6: Click the Insert Merge Fields option, then customize your document further if required.
Can attachments be sent through mail merge?Send personalized emails with Gmail Mail Merge. Include different file attachments, schedule emails for sending later, CC and BCC support, track email opens, clicks, and bounces messages.
Can you add a PDF Attachment to a mail merge on outlook?Go to Mailings tab -> Click on Start Mail Merge and then Select Letters. Click on “Select Recipients” and choose your data source (CSV or Excel File) Click on Insert Merge Fields and customize the document as desired. Instead of selecting Finish and Merge, select Merge to Adobe PDF.
How do I send multiple attachments in mail merge?Send multiple attachments to each recipient. Open the Google spreadsheet for the mail merge.. In Google Sheets, select Add-ons > Yet Another Mail Merge > Start Mail Merge.. Click + Alias, filters, personalized attachments.. Select Attach files in column “...” to emails sent, and click Back.. Click Send emails.. |