Step By Step Mail Merge Wizard on Microsoft Office 2007

Open The Mail merge Wizard by click Mailings -- Start Mail Merge -- Step by Step Mail merge Wizard.

2. Choose the Letter Size, Let's just choose Letters Size, then Click Next.

3. How we set up our letters? Just Use Current Document, then Click Next.

4. Open a database or Data Source. Click Browse.

6. Choose a new source. We must prepare / make a DSN to connect to MySQL database that become the source of data. We have do that step, Now just click New Source.

7. Choose the other Data Connection.

8.Choose Microsoft OLE DB Provider for ODBC Driver

9. Choose The DSN. We use DSN named User in this example.

10. Test the Connection.

11. Click OK at Data Link Window at Step 9. Now configure the table.

12. Save DSN Configuration

13. View Example Data, You also can edit if any  mistakes.

OK, Configuration about Source of Data have finished. Now Write the Letter to make Mail Merge.

Possibly Related Article