correcting errors in mail merge field
Answers
Answer:
Here u go mate
Pls mark as brainlist and like pls
Explanation:
Method 1
Use Dynamic Data Exchange (DDE) to connect to the Excel worksheet that contains the data that you want to use. To do this, follow these steps.
Word 2002 and Word 2003
Start Word, and then open a new blank document.
On the Tools menu, click Options, and then click the General tab.
Click to select the Confirm conversion at Open check box, and then click OK.
On the Tools menu, point to Letters and Mailings, and then click Mail Merge Wizard.
In the Mail Merge task pane, select the type of document that you want to work on, and then click Next.
Under Select starting document, select the starting document that you want to use, and then click Next.
Under Select recipients, click Use an existing list, and then click Browse.
In the Select Data Source dialog box, locate the folder that contains the Excel workbook that you want to use as your data source, select the workbook, and then click Open.
In the Confirm Data Source dialog box, click MS Excel Worksheets via DDE (*.xls), and then click OK.
In the Microsoft Excel dialog box, under Named or cell range, select the cell range or worksheet that contains the data that you want to use, and then click OK.
NOTE: Your data now appears in the Mail Merge Recipients dialog box with the same formatting that appears in the Excel worksheet.
Word 2007 and Word 2010
Start Word, and then open a new blank document.
Go to Word Options
In Word 2007, click the Office Button, and then click Word Options.
In Word 2010, click File, and then click Options.
On the Advanced tab, go to the General section.
Click to select the Confirm file format conversion on open check box, and then click OK.
On the Mailings tab, click Start Mail Merge, and then select Step By Step Mail Merge Wizard.
In the Mail Merge task pane, select the type of document that you want to work on, and then click Next.
Under Select starting document, select the starting document that you want to use, and then click Next.
Under Select recipients, click Use an existing list, and then click Browse.
In the Select Data Source dialog box, locate the folder that contains the Excel workbook that you want to use as your data source, select the workbook, and then click Open.
In the Confirm Data Source dialog box, click to select the Show all check box. Click MS Excel Worksheets via DDE (*.xls), and then click OK.
In the Microsoft Excel dialog box, under Named or cell range, select the cell range or worksheet that contains the data that you want to use, and then click OK.
NOTE: Your data now appears in the Mail Merge Recipients dialog box with the same formatting that appears in the Excel works