CR-T Blog

This is some blog description about this site

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Tags
    Tags Displays a list of tags that has been used in the blog.
  • Archives
    Archives Contains a list of blog posts that were created previously.
Posted by on in IT Blog

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!

Last modified on
My Background has been developing CR&T, an IT services MSP (managed services) and enterprise fulfillment company. I enjoy helping companies and individuals find their way through the thick of things. I think technology is only as good as it is used.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Tuesday, 02 September 2014

Archive

Categories

Tag Cloud

Admistrator Save Money Antivirus Bring Your Own Device Browser The Internet of Things IT Consultant Users Excel Disaster Recovery Business Management Holiday IT Services Mouse Cloud Unified Threat Management Value Mobile Device Privacy Remote Computing Hardware Phone System Wearable Technology Mobile Productivity Office Money Lithium-ion Battery Firewall Mobile Device Management Business Computing Vendor Management Microsoft Office Business Intelligence User Error Video Surveillance History Computer Upgrade Best Available Co-managed IT Net Neutrality Smartphones Marketing Conferencing Operating System Macro Web Marketing LinkedIn Smartphone Congratulations Intranet Keyboard Shortcuts Augmented Reality Point of Sale Hosted Solutions Software The Cloud Company Culture Computer Accessories Virus Social Networking Microsoft File Sharing Mobile Office PC Care Alerts Social Media Display Innovation Windows IBM Tutorials Gadgets Printer Tablet Windows 8.1 Update It Issues User Tips Passwords Social Wireless Technology Best Practice WiFi Law Firm IT Backup VPN Remote Support Outsourcing Gadget Webcam Internet Mobile Devices Miscellaneous Managed Service Provider Java App Hard Drives Leadership People 3D Virtualization IT Support Samsung Current Events Facebook Best Practices Scheduling IT Solutions Gaming Console Router Digital Payment Fax Server Efficiency Online Currency Security Memory Managed Service Providers Phone Systems Thank You BYOD Crowdfunding Training Communication ebay Quick Tips Big Data Google VOIP Inbound Marketing Bluetooth Trending Analytics Health Small Business Twitter Text Messaging Mobile Computing iPhone Data Alert Malware Apps Proactive IT Sports Information Technology Tools Content Filtering Touchscreen Piracy Tech Support Downtime Apple Trojan Hackers Artificial Intelligence Document Management Saving Time Business Continuity Android Statistics Maintenance Server Work Station Spam Avoiding Downtime Email Administration Print Server Outlook Computer Repair Recycling Windows 8 Network Skype Remote Monitoring Webinar Scam Streaming Media Going Green Customer Relationship Management Help Desk Saving Money Humor Technology Application PowerPoint Workplace Tips

Twitter

Latest Blog Entry

Almost Half of Business Owners Reply to Work Email While on Vacation
You're on vacation with your family and your smartphone notifies you about a work email entitled "URGENT!" What do you do? Checking the message could mean hours spent putting out a fire at the office....
Continue Reading...

Latest News

Our Site Has Launched!

flag

Welcome to Our New Site!
We are proud to announce the unveiling of our new website at CR-T!

Read more...

Contact Us

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

callphone

Call us today    801.222.0930

116 South Mountain Way Drive
Orem, Utah 84058

facebook twitter linkedin#