Question:
how does mail merge work? include details please.?
Princess Penguin
2008-05-14 08:55:57 UTC
how does mail merge work? include details please.?
Four answers:
Number 11
2008-05-14 09:06:01 UTC
To start the mail merge process:



Start Word.

A blank document opens by default. Leave it open. If you close it, the next step won't work.



On the Tools menu, point to Letters and Mailings, and then click Mail Merge.



Note In Word 2002, on the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard.



The Mail Merge task pane opens. By using hyperlinks in the task pane, you navigate through the mail-merge process.



This step in the mail-merge process involves two choices. First, you choose the type of document that you want to merge information into. Then, you choose the main document that you want to use. The main document is the document that you start with. It's the model for all of the merged documents that you eventually create.



Note Remember, we're using form letters as the example in this article series. If you are creating a set of merged labels or envelopes, the process is a little different. To go directly to information about labels or envelopes, click a link in the See Also section of this column.



Choose the type of document you want to merge information into

The Mail Merge task pane opens with a question about what type of merged document you are creating. After you choose, click Next at the bottom of the task pane.





Note If you don't see the Mail Merge task pane, on the Tools menu, point to Letters and Mailings, and then click Mail Merge (or Mail Merge Wizard, if you're using Word 2002).



If you have fax support set up on your computer and a fax modem installed, you will also see Faxes in the list of document types.



Choose the main document you want to use

If your main document (called the starting document in the task pane) is already open, or you are starting with a blank document, you can click Use the current document.





Otherwise, click Start from a template or Start from existing document, and then locate the template or document that you want to use.



To merge unique information into your main document, you must connect to (or create and connect to) the data file where the unique information is stored. If you don't want to use all the data in the file in your merge, you can choose the records that you want to use.



Connect to the data file

In this step in the mail-merge process, you connect to the data file where the unique information that you want to merge into your documents is stored.





If you keep complete, up-to-date information in your Microsoft Office Outlook® Contacts list, that is an excellent data file to use for customer letters or e-mail messages. Just click Select from Outlook contacts in the task pane, and then choose your Contacts folder.



If you have a Microsoft Office Excel worksheet or a Microsoft Office Access database that contains your customer information, click Use an existing list, and then click Browse to locate the file.



If you don't have a data file yet, click Type a new list, and then use the form that opens to create your list. The list is saved as a mailing database (.mdb) file that you can reuse.



Note If you're creating merged e-mail messages or faxes, make sure that your data file includes a column for the e-mail address or fax number. You will need that column later in the process.



Choose the records in the data file that you want to use

Just because you connect to a certain data file doesn't mean that you have to merge information from all the records (rows) in that data file into your main document.



After you connect to the data file that you want to use or create a new date file, the Mail Merge Recipients dialog box opens. You can select a subset of records for your mail merge by sorting or filtering the list.





Do any of the following:



To sort the records in a column in ascending or descending order, click the column heading.

To filter the list, click the arrow beside the column heading that contains the value on which you want to filter. Then, click the value that you want. Or, if your list is long, click (Advanced) to open a dialog box where you can set the value. Click (Blanks) to display only records that contain no information or (Nonblanks) to display only records that contain information.



Tip



After you filter the list, you can display all the records again by clicking the arrow and then clicking (All).





Clear the check box next to a record to exclude that record.

Use the buttons to select or exclude all the records or to find specific records.



Tip



If you created the data file as part of the mail-merge process, the Edit button is available in this dialog box. You can make changes to the records if you want to update the file.



After you choose the records that you want, you're ready for the next step.



After you connect your main document to a data file, you're ready to add fields that indicate where the unique information will appear in each copy of the document that you generate when you merge. To make sure that Word can find a column in your data file that corresponds to every address or greeting element, you may need to match fields.



Add fields

If your main document is still blank, type the information that will appear in each copy. Then, add fields by clicking the hyperlinks in the task pane.



Fields are placeholders that you insert into the main document at locations where you want unique information to appear. For example, you can click the Address block or Greeting line links in the task pane to add fields near the top of a new product letter, so that each recipient's letter contains a personalized address and greeting. Fields appear in your document within chevrons, for example, «AddressBlock».





If you click More items in the task pane, you can add fields that match any of the columns in your data file. For example, your data file might include a column called Personal Note. By putting a Personal_Note field at the bottom of a form letter, you can further personalize each copy. You can even customize envelopes by adding a postal bar code — if you are using the English (U.S.) language version of Word — or electronic postage (if you have an electronic postage program installed).



Match fields

If you insert an address block field or a greeting line field into your document, you are prompted to choose the format that you prefer. For example, the illustration shows the Greeting Line dialog box that opens when you click Greeting line in the task pane. You use the lists under Greeting line format to make your choices.





If Word can't match each greeting or address element with a column from your data file, the addresses and greeting lines will not be merged correctly. To help avoid problems, click Match Fields. The Match Fields dialog box opens.





The elements of an address and greeting are listed on the left. Column headings from your data file are listed on the right.



Word searches for the column that matches each element. In the illustration, Word automatically matched the data file's Surname column to Last Name. But Word was unable to match other elements. From this data file, for example, Word can't match First Name or Address 1.



By using the lists on the right, you can select the column from your data file that matches the element on the left. In the illustration, the Name column now matches First Name, and the Address column matches Address 1. It's okay if Courtesy Title, Company, and Spouse First Name aren't matched, because they aren't relevant in the documents that you are creating.





When you finish adding and matching the fields in your main document, you are ready for the next step.



Next step



After you add fields to your main document, you are ready to preview the merge results. When you're satisfied with the preview, you can complete the merge.



Preview the merge

You can preview your merged documents and make changes before you actually complete the merge.





To preview, do any of the following:



Page through each merged document by using the next and previous buttons in the task pane.

Preview a specific document by clicking Find a recipient.

Click Exclude this recipient if you realize you don't want to include the record that you are looking at.

Click Edit recipient list to open the Mail Merge Recipients dialog box, where you can filter the list if you see records that you don't want to include.

Click Previous at the bottom of the task pane to go back a step or two if you need to make other changes.

When you are satisfied with the merge results, click Next at the bottom of the task pane.



Complete the merge

What you do now depends on what type of document you're creating. If you are merging letters, you can print the letters or modify them individually. If you choose to modify the letters, Word saves them all to a single file, with one letter per page.





No matter what type of document you are creating, you can print, transmit, or save all or just a subset of the documents.



Tip about e-mail messages



If you're creating merged e-mail messages, Word sends the messages immediately after you complete the merge. Therefore, after you choose which messages you want to send, you are prompted to indicate the column in your data file where Word can find e-mail addresses for the recipients. You also are prompted to type a subject line for the message.



Remember that merged documents that you save are separate from the main document. It's a good idea to save the main document itself if you plan to use it for another mail merge.



When you save the main document, in addition to its content and fields, you also save its connection to the data file. The next time you open the main document, you're prompted to choose whether you want the information from the data file to be merged again into the main document.



If you click Yes, the document opens with information f
bljzzgrl
2008-05-14 09:09:24 UTC
I am guessing that you mean when you create a letter that you want to send to different people but you want it personalized not just a "form letter" like say "Dear Parent".



Example:



You have a class of 25 students. You want to send a letter to each of the parents about an upcoming event at school but you don't want it to feel like a form letter (Dear Parent, Your Student, and the time and date have to written in).



So you create a "form" where the letter is written using "merge" codes to plug in the information you want to use. Example codes for:

Parent's Name

Student's Name

Date of the Activity

Time of the Activity



Now you create a data form that includes all this information. Example:

Mr. and Mrs. Smith

Jennifer

March 15, 2008

5 p.m.



Ms. Young

Peter

March 15, 2008

3:30 p.m.



You then create a merge file (depends on your word processing program exactly how this is done) and the letter comes out as such:



Dear Mr. and Mrs. Smith



I am pleased to let you know that your daughter(this would also be a merge field) Jennifer will be presenting her school project to the committee on March 15, 2008 at 5 p.m. We hope to see you there and are excited to see what Jennifer has to share with us.



Sincerely,





etc.
Ms.D.
2008-05-14 09:11:49 UTC
I have used word 2000. Mail Merge is where you can send mail to a group of people instead of just one. Sort of like when you send an email to all the people in your address book by (going to the bottom of the address book and checking (check all) then you go back to your message and see that all the email addresses have been added to your (to:) section, you can send (cc) carbon copy where every one gets there own copy but the receiver can see who else got the email or (bcc) where each gets their own but cannot see who else may have received the email. Now using (word)

With mail merge you can prepare envelopes and letters each one will be individual and each will come out with the correct name and address. Then you can just mail them using the postal service. You can use it for a whole host of items, invitations ,letters, labels etc.

I hope that helps.............
anonymous
2016-10-21 11:44:39 UTC
It relies upon the way you go with to exhibit it. this might combine your documents right into a unmarried textual content fabric string. In A11 positioned =A1&A2&A3&A4&A5&A6&A7&A8&A9&A10 and drag this formula around the 14 columns. you may desire to place an area between each and every cellular with =A1&" "&A2 (etc.)


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...