MAIL MERGE TIPS FOR PC USERS

Transcription

1 How do I create a DATA SOURCE for my merge? Mail merges require a DATA SOURCE. The data source represents the information which you want to merge into letters, name tags, labels, etc. The data source document must be a TEXT format (.txt &.csv are the most common formats) file. The file should consist of a HEADER row and one or more DATA records: The DATA SOURCE consists of data fields with delimiters between fields. These delimiters are usually tabs or "," (know as a.csv file or quote-comma-quote delimited file). The sample above was arranged for easy viewing but the tab delimited version would like this: The Header and Data do not appear to have any format yet they do. All the information in a row is separated by one tab stop. Each row is separated by a carriage return. Your DATA SOURCE file will generally be a Notepad (which by default is tab delimited) or Excel text file: You don't have to use every field from you data source in your merge. If your merge file contains first, middle and last name and you don't need to use "middle" in you merge, then don't. Mail merge does not force you to use every column from your data source If you create the data source in Excel, be sure to save it as a.txt or.csv file. To save as a text file select File>Save as: Page 1 of 6

2 When you save an excel file as text you will get the message: Select "Yes". This message will appear again when you close the file you created. Select "Yes" again. If your data source contains fields with leading zeros such as a zip code i.e , be sure to format the column as "custom" and enter the appropriate format before saving: Page 2 of 6

3 How do I create a MAIL MERGE? Begin by opening a new word document. Word has a Mail Merge Wizard to help you step-by-step to create a merge file. To start the mail merge wizard, open WORD and select Tools>Letters and Mailings>Mail Merge: A Mail Merge task pane will open on the right of your screen where you can select your document type and follow the "Step 1 of #" to guide you through the rest of the process: DO NOT use the messages option if available. We recommend purchasing an inexpensive mass tool if you want to personalize messages There is a Mail Merge toolbar: but we recommend using the mail merge wizard so you don't miss any vital steps. Once you completed the merge we recommend you select "Edit Individual letters" and not "Print". This gives you a chance to review the merge and make any changes if need be: Page 3 of 6

4 What can I do with my document or template once I have completed the merge? When you select "Edit individual letters" you have created a new word document. If you will need to refer to the merged document you will want to save it. If you want to save the merge template for future use with another data source you will need to save it separately. If you want to print a sampling of records remember that each merged letter is a section and not a page. For example, to print the first and third pages in merge you would select s1,s3: If you need to forward the merged document to someone else for printing you will need to first save the completed merge as a.doc file and forward it to the appropriate party. If you have created a useful merge template that someone else may find useful, you can forward the template to them. The template is the document with the merge fields, not the data fields. Page 4 of 6

5 HELP! What am I doing wrong! I m inserting my mail merge fields but it doesn t look right! Instead of seeing I see This simply means that you have a word setting called Field Codes turned on. Change this setting by going to Tools>Options and selecting the View tab. Make sure the check box beside Field Codes is unchecked. When I load my data source I get the message that Record # contained too few data fields or too many data fields for row! How I get out of this and how do I fix it! Usually this problem occurs when you have created a tab delimited file and forget to insert a tab or inserted too many tabs in a row of data. Or it could be that data you obtained from another source contains field used as delimiters within a data field. You need to go back to your data source and make the necessary corrections. To get yourself out of the merge source continue hitting enter until you reach the end of the data file (if it is short file) or you can force quit out of the merge if you have a large file. I saved a merge file as a template (.dot file) but now I can t find it! What happened? By default, word saves templates to a predefined template folder. You can create your own folder for storing templates then change the default in word by going to Tools>Options and going to the File Location tab. Select User Templates then the Modify button to browse to the folder where you want to store your templates. Page 5 of 6

6 I want to merge new data into a merge file I saved but the header row has slightly different name. For example, my merge file contains the field Last but my new data source calls the same column Last Name. Do I have to recreate the document from scratch? You have two options here. You can look at the field names in your merge and then go back and change the headers in you data source to match By default the mail merge wizard will prompt you with an Invalid Merge Field. This will give you the opportunity to replace "Last" with "Last Name". Page 6 of 6

Intro to Mail Merge David Diskin for the University of the Pacific Center for Professional and Continuing Education Contents: Word Mail Merge Wizard Mail Merge Possibilities Labels Form Letters Directory

Microsoft Word 2007 - Mail Merge Mail merge is a tool which allows you to create form letters, mailing labels and envelopes by linking a main document to a set of data or data source. It is the process

MAIL MERGE USING WORD & EXCEL 2003 Open Excel. Create a database with the names for mailing labels & letters. Consider using the following fields as your column headings. Create the headings without spaces

Mail Using Categories 1. Select the message that for the category. 2. Select the appropriate category. 3. The category color displays next to the message. Renaming Categories 1. Select a message. 2. Select

Six Steps to Completing a Mail-Merge Mail merging means to plug data from an address table into form letters, e-mail messages, envelopes, address labels, or a directory (a list or catalog, for example).

Mail Merge Tutorial (for Word 2003-2007) By Allison King Spring 2007 (updated Fall 2007) What is mail merge? You've probably heard it mentioned around the office or at an interview (especially for a temp

NDUS Training and Documentation What is a Mail Merge? A mail merge is generally used to personalize form letters, to produce mailing labels and for mass mailings. A mail merge can be very helpful if you

MICROSOFT WORD 2010 How to Do a Mail Merge Documented by: Vincent J. Yanusauskas Computer Training Coordinator Weinberg Memorial Library Introduction If you have used any of the Office 2007 applications

Mail Merge - Microsoft Word and Excel Queries Scott Kern Senior Consultant This session is an introductory course into the features and functions offered by the MS Query component of Microsoft Excel and

Create a New Database in Access 2010 Table of Contents OVERVIEW... 1 CREATING A DATABASE... 1 ADDING TO A DATABASE... 2 CREATE A DATABASE BY USING A TEMPLATE... 2 CREATE A DATABASE WITHOUT USING A TEMPLATE...

How to Mail Merge PDF Documents A step-by-step guide to creating personalized documents Table of Contents What is a mail merge?... 2 What do I need to start?... 2 Step 1: How to create a PDF document?...

Creating and Managing Online Surveys LEVEL 2 Accessing your online survey account 1. If you are logged into UNF s network, go to https://survey. You will automatically be logged in. 2. If you are not logged

Using Mail Merge in Microsoft Word Creating the main document On the menu bar, click on Tools. From the pull down menu, select Letters & Mailings, then select Mail Merge... A task pane will appear on the

emarketing Manual- Creating a New Email Create a new email: You can create a new email by clicking the button labeled Create New Email located at the top of the main page. Once you click this button, a

WhatCounts Newsletter System Manual Last Updated: November 21, 2008 This instruction manual describes the basic steps required to create, edit, and manage a mailing list for use with the WhatCounts Email

USING MS OUTLOOK WITH FUSEMAIL In this tutorial you will learn how to use Microsoft Outlook with your FuseMail account. You will learn how to setup an IMAP account, and also how to move your emails and

MAIL MERGE TUTORIAL (For Microsoft Word 2003-2007 on PC) WHAT IS MAIL MERGE? It is a way of placing content from a spreadsheet, database, or table into a Microsoft Word document Mail merge is ideal for

Access(ing) A Database Project PRESENTED BY THE TECHNOLOGY TRAINERS OF THE MONROE COUNTY LIBRARY SYSTEM EMAIL: TRAININGLAB@MONROE.LIB.MI.US MONROE COUNTY LIBRARY SYSTEM 734-241-5770 1 840 SOUTH ROESSLER

How to create Labels and other word documents using Mail merge 1. What is mail merge? It is a way of placing content from a spreadsheet, database, or table into a Microsoft Word document. Mail merge is

Why should I back up my certificate? You should always keep a backup copy of your ACES Business Certificate on a location external to your computer. Since it s stored locally on your computer, in the Windows

Create a Simple Website Intel Easy Steps 1 2012 Intel Corporation Website Creating a Simple Website As more and more people are using the Internet to get information, it has become very important for businesses

introduction to emarketing emarketing is typically used for promotional campaigns for attendee generation and for attendee communication. It works closely with ereg which also includes email capabilities

Microsoft Access to Microsoft Word Performing a Mail Merge from an Access Query Performing a Query in Access Before performing a mail merge, we need to set up a query with the necessary fields. Opening

Creating an Excel Spreadsheet for Mail Merge Excel Spreadsheet Mail Merge 1 of 9 Creating an Excel Database for a Mail Merge 1. To create a database for a mail merge you will first need to open Microsoft

The Ribbon: Home tab New Email to send a new mail New Items to send a new mail, a new appointment, a new meeting, a new contact, a new task, a new Lync Meeting Ignore to ignore a request Clean Up to clean

SupportDesk and Customer Relationship Management 1 Introduction The CRM Module is a SupportDesk optional extra, available in the Windows and Web interfaces. It is intended for those supporting external

User Manual - Overview The Leads module of MVI SLM allows you to import, create, assign and manage their leads. Leads are early contacts in the sales process. Once they have been evaluated and assessed,

Access 2003: Office Links, Importing, & Exporting USING WORD AND ACCESS TOGETHER Use Access to Merge It With MS Word Merge data from a table or query using the Microsoft Word Mail Merge Wizard. First open

CREATING A MAIL MERGE DOCUMENT The Mail Merge function provides the ability to create a personalized document that you will send to multiple recipients. To complete all the steps of the Mail Merge process,

Sending Email on Blue Hornet STEP 1 Gathering Your Data A. For existing data from Advance or Outlook, pull email address, first name, last name, and any other variable data you would like to use in the

HOW TO CREATE AN HTML5 JEOPARDY- STYLE GAME IN CAPTIVATE This document describes the steps required to create an HTML5 Jeopardy- style game using an Adobe Captivate 7 template. The document is split into

Using Mail Merge to Create Form Letters and Labels 1. Open the word document on your floppy: Practice letter 2. Go to Tools > Mail Merge. The Mail Merger Helper appears. We are going to create form letters,

Creating Mailing Labels in Microsoft Word Address data in a Microsoft Excel file can be turned into mailing labels in Microsoft Word through a mail merge process. First, obtain or create an Excel spreadsheet

Creating a Participants Mailing and/or Contact List: The Limited Query function allows a staff member to retrieve (query) certain information from the Mediated Services system. This information is from

Word 2010: Mail Merge to Email with Attachments Table of Contents TO SEE THE SECTION FOR MACROS, YOU MUST TURN ON THE DEVELOPER TAB:... 2 SET REFERENCE IN VISUAL BASIC:... 2 CREATE THE MACRO TO USE WITHIN

Mail Merge: Create Mailing Labels Using Excel Data and Filtering the Contents in the Data Prior to starting this, please save the.csv file that you exported as an excel file (example: xxxx.csv will now

Table of Contents Table of Contents... 1 Hot New Reports... 1 Event Name Tags with Logo... 2 Member Directory with Logos... 3 Member Longevity Report... 4 Hot Deals by Member and Date... 5 Create a Custom

USING OUTLOOK WITH ENTERGROUP In this tutorial you will learn how to use Outlook with your EnterGroup account. You will learn how to setup an IMAP or POP account, and also how to move your emails and contacts

Information used to create labels in the Client Data System (CDS) can be exported out of CDS and used to create labels in Microsoft Word, making it possible to customize the font style, size, and color.

Mail Merge Course Description The Mail Merge feature allows you to combine items from a data source into a document. This allows you to create form letters, mailing labels, envelopes, etc. You also have

(or, Why You Don t Need MS Project) Using Microsoft Office to Manage Projects will explain how to use two applications in the Microsoft Office suite to document your project plan and assign and track tasks.

Importing to Access MaryJo Webster Revised: Jan 2016 Data to import: PCDogs.txt Step One: The data you want to import: What format is it in? Where is it stored? --Be sure the data is on your computer (not

Mail Merge Step by Step Mail Merge is a handy feature that incorporates data from both Microsoft Word and Microsoft Excel and allows you to create multiple documents at once, such as letters, saving you

Page 1 of 14 Access 2010 Home > Access 2010 Help and How-to > Getting started Search help More on Office.com: images templates Access 2010: database tasks Here are some basic database tasks that you can

Quick Start Guide DocuSign Retrieve 3.2.2 Published April 2015 Overview DocuSign Retrieve is a windows-based tool that "retrieves" envelopes, documents, and data from DocuSign for use in external systems.

Creating a Database in Access Microsoft Access is a database application. A database is collection of records and files organized for a particular purpose. For example, you could use a database to store

Microsoft Access 2010 handout Access 2010 is a relational database program you can use to create and manage large quantities of data. You can use Access to manage anything from a home inventory to a giant

The Conveyancer and PCLaw Quick Start Guide Do you create your Statement of Accounts from The Conveyancer for all your real estate transactions? Do you or your bookkeeper then manually enter each of these

Converting from Netscape Messenger to Mozilla Thunderbird Logging into Thunderbird When you open Thunderbird for the first time, you will be asked for your email password. If you want Thunderbird to remember

USING MS OUTLOOK In this tutorial you will learn how to use Microsoft Outlook with your EmailHosting.com account. You will learn how to setup an IMAP account, and also how to move your emails and contacts

How to transfer your Recipient Address Book from FedEx Ship Manager at fedex.ca to FedEx Ship Manager Software There are three phases to completing the transfer process. Phase I Phase II Phase III Export

Converting an Excel Spreadsheet Into an Access Database Tracey L. Fisher Personal Computer and Software Instructor Butler County Community College - Adult and Community Education Exceeding Your Expectations..