Complete The Mail Merge and Then Print

The Last Step is Complete The Mail Merge and Then Print it.

Follow this steps

1. Click Complete The Mail Merge.

2. Edit Individual Letter (We can edit individually letter by letter if we want any changes)

3. Click All (All Pages Will be Shown)

4. View Your Letter Again, If no mistakes, Let's Print It.

 

That was step by step to create Mail Merge With Microsoft Word and MySQL

Preview The Microsoft Word 2007 and MySQL Database Mail Merge

After The Configuration, now let's review our Mail Merge. I Think our Mail Merge is special because unusual because it combines Microsoft Word 2007 and MySQL Database Mail Merge. I see usually we create mail merge from Microsoft Word and Microsoft Excel.

Now let's preview our  Microsoft Word 2007 and MySQL Database Mail Merge.

See the difference from three images below:

 Figure 1. For People 1

 

 Figure 2. For People 2

 

 Figure 3. For People 3

We already know that same task made we so boring. How about write 1000 letters with different Names and Units..? Use Copy Paste..? No...!!! that was an uneffective way!!

Do by Mail Merge !!!!

Ok, lets go to the Final Step. Complete The Mail Merge

Create Letter Template for Microsoft Word and MySQL Server Mail Merge

As we know, The template is important in Mail Merge. We make the letter template in Microsoft Word. Later this template can produce a variation data from the database (we use MySQL Server as Mail Merge data source).

OK, let just do our next step to create Letter Template for Microsoft Word.

1. Create the letter by manually type the word we need. We can also use Formatting Text in this Template.

2. Choose the source of data by click More Items

3. Put the Cursor at the right place to put the Data on letter, and then insert Field from the Table by click Insert.

5. Result of the Inserted Field

6. Fix your template by add neccesary field.
7. The Final Result of the Mail merge Template:

Next Step : Preview the Mail Merge Final Result.

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.

Create New DSN for Microsoft Word and MySQL Server Mail Merge

As Previous Post about Create a MySQl Data Source Name for a Database Programming in Windows XP

we can do it fast now
1. click Start -- Control Panel -- Administrative Tools -- Data Source (ODBC))
2. Double Click Data Source and You will find existing data sources.
3. Click Add New Data Source

4. Be sure You have install MySQL ODBC Connector, The indicator if you have install is a MySQL ODBC Driver in a list like below.

5. Click Finish, You will then Fill a form with MySQL user account, Give DSN Name an it's description. Be sure input Server, User and Password. Leave Port as Default.

Fill in the form. In the last step, if you correct, The list of Database will be shown. We will use a table named user on database named belanja. Fisrt, we just choose the database to make the DSN, like example below.

I Assume this was an Example, Just Pick Up an Example Database that have a Flat Table (Table that has no Relationship)

Just Click Ok. Now You Already have a Data Source Name.The DSN was named User.

We can move to Next Steps on Mail Merge With Microsoft Word and MySQL.

Mail Merge With Microsoft Word and MySQL Part 1

Part 1 Introduction

What is Mail Merge ?

Mail Merge is a software product that uses a file (or database) of names and addresses, together with a template document, to produce multiple copies of a letter, each personally addressed to a different recipient.

A Mail Merge is also a method of taking data from a database, spreadsheet, or other form of structured data, and inserting it into documents such as letters, mailing labels, and name tags. It usually requires two files, one storing the variable data to be inserted, and the other containing the information that will be the same for each result of the mail merge and the instructions for formatting the variable data.

You use mail merge when you want to create a set of documents that are essentially the same but where each document contains unique elements. For example, in a letter that announces a new product, your company logo and the text about the product will appear in each letter, and the address and greeting line will be different in each letter.

You can also print a set of mailing labels or envelopes by doing a mail merge. For labels, for example, you would construct a source document containing the addresses of the people you wish to print labels for and a main document that controls where each person's name, address, city, state, and zip code will go on the label. The main document would also contain information about how many labels are on a page, the size of each label, the size of the sheet of paper the labels are attached to, and what kind of printer you will use to print the labels. Running a mail merge with the two files results in a set of labels, one for each entry in the source document, with each label formatted according to the information in the main document.

Most major word processing packages, including Microsoft Word and Corel WordPerfect, are capable of performing a mail merge.

That was introduction from many reference about mail merge. In this special posting we will learn how to make a simple example of mail merge.by using Microsoft Word and MySQL Database Management System. Microsoft Word has a function as the mail merge template provider and MySQL Database as a the data storage provider.

Next Step, 
Part 2. Create New DSN for Microsoft Word and MySQL Server Mail Merge

Part 3. Step By Step Mail Merge Wizard on Microsoft Office 2007
Part 4. Create Mail Merge Template Letter
Part 5. Testing The Letter as Mail merge 
Part 6. Complete The Mail Merge and Then Print