0
Fields.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Steps of mail merge?
Mail Merge Step by Step Instructions for the PC Page 1 of 4 1. Open Microsoft Word 2003. 2. Go to Tools > Letters and Mailings > Mail Merge... If the task pane was closed, it will open the Mail Merge task pane. Step 1: Select Document Type 1. Under Select document type, choose Letters. 2. Click on Next: Starting document at the bottom of the task pane Step 2: Starting document 1. Selecting Use the current document will allow you to start from the current document shown on the screen. 2. Click Next: Select recipients. Note that you can always go between steps by clicking on the Next and Previous links at the bottom of the task pane. Step 3: Select Recipients 1. Select Use an existing list. 2. To find an already existing file, click Browse... and navigate your way to the file. 3. If your data source is an Excel worksheet that has data on multiple tabs, you need to select the tab containing the data you want. Click OK. 4. All the entries in the data source will now appear in the Mail Merge Recipients window, where you can edit the list of recipients. Mail Merge Step by Step Instructions for the PC Page 2 of 4 5. In the Mail Merge Recipients window, select the recipients you want by checking the boxes next to the recipients. To sort the list, click the column heading of the item you want to sort by. To filter items in the list click the arrow next to the column heading of the item you want to filter by and select any of the following: 1. Blanks display all the records in which the corresponding field is blank. 2. Nonblanks display all the records in which the corresponding field contains information. If your data source contains records that share the same information, and there are ten or fewer unique values in the column, you can filter by specific information. 6. If the arrow next to any column heading is blue, that category is screening out names. To display all the recipients again, click and blue arrows and select All. 7. To check all names in your recipients list, click Select All. To uncheck all names, click Clear All. 8. Click OK to return to the Mail Merge Wizard. 9. To change the file click Select a different list... 10. To edit the list click on Edit recipient list... (data source) 11. Click on Next:Write your letter. Step 4: Write Your Letter 1. If you are creating a form letter, type the text that you want to appear in every form letter. Insert merge fields where you want to merge names, addresses, and other data from the data source (i.e. recipient list) by clicking anywhere you want in the main document to insert the field. Then click on More Items and insert individual field Click More items... Mail Merge Step by Step Instructions for the PC Page 3 of 4 1. Select one of the following: (a) Address Fields will allow you to select from address fields that will automatically map to corresponding fields in your data source, even if the data source's fields don't have the same name as your fields. (b) Database Fields will allow you to select from fields that always take data directly from a column in a database. 2. In the Fields window, click the field you want. 3. Click Insert, and then click Close. 4. If the Match Fields window appears, Microsoft Word may have been unable to find some of the information it needs to insert the field. Click the arrow next to not matched, and then select the field from your data source that corresponds to the field required for the mail merge. If you are creating a form letter, click Next: Preview your letters. Step 5: Preview your letters 1. To preview the items in order, click the arrows under the Preview your letters heading. Mail Merge Step by Step Instructions for the PC Page 4 of 4 2. To locate a specific item, click Find a recipient..., and then enter the criteria in the Find field. 3. To change the list of recipients, click Edit recipient list..., and make your changes in the Mail Merge Recipients window. 4. Click on Next: Complete the Merge at the bottom of the task pane Step 6: Complete the Merge 1. Click Edit individual letters... 2. In the Merge to New Document window, select the records you want to merge. 3. Click OK. 4. Microsoft Word will create new merged document. 5. To personalize individual documents, scroll to the information you want to edit, and make your changes. 6. Print or save the document just as you would any regular document. Step 7: Save the Merged Letters Under most circumstances, you do not need to save the merged document. It is simpler and more useful to save the main document and merge it again if you need another copy. Below are examples of times when you might wish to save the merged document: • You wish to keep an archived copy of mailings, including to whom they were sent. • You have personalized individual letters or labels within the merge, and want to save those changes. If you do wish to save the merged document, collect the merged files into a single document by clicking Edit individual letters. In the Merge to New Document window, select one of the following: • To merge all the documents, click All. • To merge only the document that you see in the document window, click Current record. • To merge a range of documents, click From, and then type the record numbers in the From and To boxes. Click OK. Microsoft Word will open one new document that contains all the individual letters. Save the document just as you would any regular document.
Explain in detail mail merge in word?
expain mail merge in detail
What did Miller merge with in 2002?
In 2002, Miller agreed to merge with South African Breweries to become the world's second largest brewery
What kingdom did Egypt once merge with?
Nubiamali
How did north and south Egypt merge?
There was a war and they merged
Can excel spreadsheet be used as the data source for a word mail merge?
Yes it can be, as long as the data has been laid out properly, with the field headings in the first row and the data in the columns below that.
What is the process of combining a data source with a main document?
It frequently is known as mail merge.
When the data source you select for a mail merge is an Excel workbook that has more than one worksheet what does Word do?
It gives you a choice of where to choose the data from. It is important to set up your data in the Excel document in a structured manner with clear headings so that you can find it, whichever worksheet it is on.
When companies operating at different but related levels of an industry merge it is known as an?
vertical merge
What is the data source contains the text that varies from one merged document to the next?
The Data Source file can be a text document, a table in word, a table in a database or a file in Excel where data has been laid out in a tabular format. In all cases, you will need headings to indicate the field titles that are to be used. Then the data can be picked up in the Mail Merge process.
What is a mailing list also called in Microsoft Word?
Sometimes it is called a mail merge, and the result of a mail merge is a list of form letters.
What is contained in the merge field in a data source document?
A placeholder in the main document that marks where a value is inserted from a source.
Can you use an Excel document to merge into labels?
Yes, Excel can be used as the source of data for a Mail Merge of any kind, so that includes labels.
How do you span columns in Excel?
Select cells across more than one column. Then use the Merge Cells option to bring them together as a larger cell which will span across the column.
What is a data source created in Word saved as?
A data source refers to the data used in a mail merge. Typically it would be the list of names and addresses that might be used. They can be stored in a database, that Word can access to use them in the mail merge process.
What action do you perform on a data source in order to merge only certain records?
You would do a Merge using conditions, normally with an IF command or by filtering the records. It will depend on the application for the merging and the source data as to how specifically you would do it, as there are various options.
What is the three important steps in mail merge?
performing a mail merge involve three basic step. 1) creating a main document. 2) creating a data source. 3) merging the data source and main document
