Pages

Jumat, 30 November 2012

How to make merge mail in microsof word

Linking to the Data Source File

As with many tasks, Microsoft created a helpful wizard. Before starting, make sure you have created your recipient list with the fields you wish to use.
1. Open Word with a blank document or your letterhead.
2. From the Tools menu, select Letters and Mailings
3. From the sub-menu, select Mail Merge....The Mail Merge task pane will appear on the right side of your screen.
Word's mail merge task pane
4. Click the Next: Starting document link at the bottom of this panel. The Wizard advances you to Step 2.
5. Keep the default option for Current document and click the Next: Select recipients link at the bottom.
6. Click the Browse … link in the middle of the panel. This opens the Select Data Source dialog.
Select Data Source dialog
7. Navigate to your Excel file and click Open. This opens the Select Table dialog. If you named your Excel worksheet, the name will show. Otherwise, it will appear as Sheet1$.
8. Check the box at the bottom for First row of data contains column headers.
9. Click OK. Your file name should show where the Browse… link was on the Mail Merge task pane.
10. Click Next again.

Adding your Address Merge Codes

The Mail Merge wizard should be on Step 4 of 6. Now that we’ve assigned the data source, we can insert the merge fields in our letter. The first code most people start with is the address. While you can insert merge codes for each address element, Word allows you to enter all the fields with an Address block.
1. On the Mail Merge task pane, click Address block… .The Insert Address Block dialog should appear.
Insert Address block dialog
2. Check the options that best suit your addresses.
3. Click the Match Fields… button in the lower left.
4. Fix any address fields that you’ll use which show as (not matched) by selecting the appropriate field using the arrow control.
5. Click OK.
On your Word document, you should see «AddressBlock». This code represents the address fields you selected. And no, you can’t wrap chevrons around your field names. You won’t see any real data until you merge the information.

Adding Other Merge Codes

While adding address information is useful, you probably want some custom fields. These fields should have been defined on the Excel spreadsheet you linked. As example, you might inform people of an upcoming event. The process of inserting additional fields is similar to the address block.
1. From the Mail Merge task pane go to Step 4 of 6.
2. Add your letter text up to the point where you want to insert the field.
3. Click More Items… from the task pane. The Insert Merge Field dialog appears.
Insert Merge Fields dialog
4. Highlight your field.
5. Click Insert.
Your merge field should show next to your cursor. As before, the chevron’s are wrapped on either end.

Tidak ada komentar:

Posting Komentar