If you have completed a Mail Merge in Word it is time to take things to the next level and create an Email Merge! An Email Merge is very similar to a Mail Merge but instead of Letters you are creating Outlook Emails. The Email Merge function helps you send a large number of emails to a list of recipients quickly out of Microsoft Word. The Email Merge feature is a collaboration across the big three applications Excel, Outlook, and of course Word! You will prepare an Excel spreadsheet with the recipient information and email addresses along with unique information that will populate into the email body. Then utilizing the Mail Merge Wizard in Word, you can indicate that you are generate E-mail messages. After completing the Email Merge Outlook will send each recipient their own personalized email.
Watch this video to see how to do this on your computer.
Follow this step by step guide to do this on your computer.
Get started using Excel VBA by allowing the Macro Recorder to generate the code for you! This tutorial will show you how to record a macro in Excel that will create a new Worksheet. With some additional steps you can have this VBA code fire every time the Workbook opens.
Outlook gives you the ability to create memorized actions called Quick Steps. One helpful Quick Step you can create is a standard email to send to all recipients of your department. Using this Quick Step, you can quickly email your entire department keeping everyone informed. Think of Quick Steps as a toolbox that you add tools to over time. Leverage & Lean is here to help fill your Outlook toolbox!
Looking for more?
Subscribe as an Insider to receive additional rights.