CR-T Blog

CR-T has been serving the Orem area since 1992, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tutorial: Master the Art of the Mail Merge, Part 2

Last time we spoke about creating your contact list in Excel when performing a mail merge. Of course, you can also use your Outlook contacts, and if you are running any sort of CRM software it is pretty likely it exports its own spreadsheet that can be used in a mail merge. Let's go over how to perform a mail merge now that you have your list.

Let's say you wanted to send off a letter to a few hundred recipients, but you wanted it to be customized with their name and company name. As long as that information is in your list (either the document we made in the previous article or your exported list or Outlook contacts) it can be pulled into the letter.

  1. Open up Microsoft Word. You can start with a blank document , or if you already have a letter written load that up.
  2. Go to the Mailings tab and click Start Mail Merge. If you are using an older version of Word, this option should be under the Tools menu. Under Start Mail Merge, select the Step by Step Mail Merge Wizard.
  3. On the right the wizard will ask you several questions about the type of document you are creating. In this case, select Letters and click next.
  4. You can either use the current document or load an existing one. Make your selection and click next.
  5. The wizard will now ask where your list will come from. You can either choose an existing list (like the one we created in the last article) your Outlook contacts, or it will give you the option to create a new list. We're going to select Use an existing list and click Browse to open it.
  6. Your list will display. You can select the items out of the list you want to pull, letting you exclude certain contacts if you want. There are options here to prune your list and filter things out too. Once you are ready click ok.
  7. Now you can begin writing your letter. On the right you will have a few item options for data that can be plugged into the letter, such as Greeting line. Click Greeting line.
  8. It will give you a few options for your greeting (you can have your own greeting by selecting none), and how the name displays. If your data doesn't match up quite right, use the Match Fields option to select what column in your list pertains to which item (such as matching first name with your firstname column, etc). Once the preview looks good, click Ok.
  9. This will add a <> tag into your letter which will automatically update itself with data from the list. Over on the right, click Next: Preview your letters and make sure everything reads correctly when it inserts the data.
  10. Once everything looks good you can print the letters out!

You can use Mail Merges to create labels, envelopes, custom letters, invitations, coupons, or anything that needs to pull variables from a list.

Need help performing other advanced tasks in your productivity software? Give CR-T a call at 801.222.0930 and let us know what you are trying to accomplish and we can help you work out an effective solution that saves you time and money to get things done faster!


No comments yet
Already Registered? Login Here
Friday, 21 October 2016
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Tag Cloud

Security Technology Microsoft Business Management Tip of the Week Internet Saving Money Privacy Small Business Workplace Tips Managed Service Provider Backup Software Hardware Quick Tips Mobile Office Productivity Cloud Data Social Media Best Practices Gadgets Hackers Email Business Computing Google Users Malware Mobile Devices Network Virtualization Hosted Solutions Business IT Services Windows IT Support Computer Upgrade Microsoft Office Smartphones Communication VOIP Passwords Windows 10 Miscellaneous WiFi Business Continuity Smartphone Efficiency Innovation Holiday Disaster Recovery Mobile Device Management Marketing Vendor Management User Tips Server Operating System Facebook Alert Remote Computing Best Practice Office Android Current Events Apple Going Green Bring Your Own Device Mobile Computing Spam Browser Outlook App Health Lithium-ion Battery Trending The Internet of Things Apps Remote Monitoring History Wireless Technology Customer Relationship Management IT Solutions Printer Humor Ransomware Big Data Content Filtering Gmail Information Technology Tutorials Windows 8 Excel Office Tips Password IT Consultant Fax Server Application Robot Artificial Intelligence Computer Repair Saving Time Maintenance Automation Avoiding Downtime Social Internet of Things Retail BYOD Network Security Unified Threat Management Save Money Inbound Marketing Proactive IT Router Phone System Data Management Customer Service Firewall Hard Drives Google Analytics Presentation Sports Digital Payment Antivirus Twitter PowerPoint The Cloud Administration User Error Education Virus Hacking Computers Tech Support Hacker Business Growth Money iPhone Piracy Data storage Upgrades Safety Augmented Reality Bandwidth Printing Phishing Touchscreen Net Neutrality Hosted Solution Computing Recovery Mouse Wi-Fi Settings User IBM End of Support Business Owner Tablet Search Running Cable Display Point of Sale LiFi VPN Analyitcs Cybercrime Mobile Downtime Legal Website Social Networking Samsung Cortana Chrome Employer-Employee Relationship Video Surveillance Laptop How To Risk Management Competition Tools Scheduling IP Address Law Firm IT Memory Scam Virtual Desktop eWaste Macro Hacks Hiring/Firing Business Intelligence Emoji Computer Accessories Storage Company Culture People 3D Printing Environment Black Market Dark Data Wireless Bluetooth Unsupported Software Troubleshooting It Issues Processors Mobile Device Trojan Statistics Mobile Data Webinar communications Google Wallet Refrigeration USB Notifications Webcam Training 5G Java Halloween Web Marketing Physical Security Unified Communications Drones Crowdsourcing Phone Systems Network Congestion Two-factor Authentication Help Desk Scary Stories Consumers Skype Debate Personal Information IT service ebay Budget Gaming Console Undo Collaboration Government Document Management Monitors Office 365 LinkedIn Electronic Medical Records Co-managed IT Deep Learning Text Messaging Intranet File Sharing Work/Life Balance Best Available Wearable Technology Alerts Writing PC Care Fun Buisness Specifications Entrepreneur Programming Conferencing Virtual Reality Alt Codes Domains Disaster Windows 8.1 Update Remote Support Social Engineering Leadership Encryption Gadget Managed Service Providers SaaS Typing Google Drive Public Speaking Crowdfunding Work Station Admistrator Managed IT Services Knowledge YouTube Outsourcing Licensing Value Update Cryptocurrency Keyboard Shortcuts Google Docs 3D Online Currency Print Server Recycling Experience Word Save Time Streaming Media Chromebook Bitcoin

Latest Blog Entry

How many hours a day do you work? Chances are that, as a business owner, you put in more than the average worker. Your team might put in the requisite eight hours, but you might find yourself putting ...

Latest News

  • Private Screening of The Hobbit III

    By invitation only

    CR&T’s 18th annual client appreciation event: THE HOBBIT III. This is a private pre-screening before the world premiere.

    Location: Thanksgiving Point Theater
    Time: December 16th 8:30AM (REMEMBER THIS IS 1 DAY PRIOR TO THE WORLD PREMIERE) seating is first come.


Contact Us

Learn more about what CR-T can do for your business.


Call us today    801.222.0930

116 South Mountain Way Drive
Orem, Utah 84058

facebook twitter linkedin#