how to do a mail merge in outlook from excel

Word can automatically insert all the appropriate address fields at once, so you don’t have to insert the five or six merge fields yourself.Ī group of merge fields that make up the greeting line of a mail merge document, such as “Dear Mr. For example, a single address is made up of a name, street address, city, state, and zip code. An example would be: Dear «FirstName».Ī group of merge fields that make up an address in a mail merge document.

Merge fields appear with chevrons (« ») around them. For example, a single record would include a person’s first and last names, address, phone number, and date of birth.Ī merge field is where you want to insert the information from a data source into a main document. For example, the field «LastName» would only contain people’s last names.Ī record is an entire set of data fields that relate to a single thing or person. Excel spreadsheets, Access databases, or Word document tables are good examples of data sources.Ī data category that stores a specific piece of information. For example, it has records containing the names and addresses of the people a mail merge letter is sent to. The starting document contains the field names for the variable information, like the names and addresses that will be inserted.Ī file that contains the information to be inserted into the main document during a mail merge. (Main Document) A document that contains the information that is the same for each merged document.

How to do a mail merge in outlook from excel