Tutorial Mailmerge From Excel to Word

TUTORIAL MAKE MAILMERGE 

1. Excell to Word

1.      Make data or table in msc. Excel or Acces, an example of NIM, Name, Department, Address, like the example below: <do not forget to save it first. And then close ms. Excel or Access.

 

2.      After that, open msc. Word, types title on the document same word in Excel or acces like this:

3.      Select mailing menu, select recipients, and then choose "Use an Exsisting File"

Then the menu will appear as shown below. Select the pre-made file, and then select "Open". And the dialog box will appear as below, select OK.

. Select the "insert merge field" menu, adjust it with the title in the column. For example NIM insert merge field with NIM, and so on.

Then it will fill automatically, as in the picture.

To display the data, select the "Preview Result" menu, then the data will Look like the following. To move to the next or previous record, click the arrow to the right of the Preview Result.

2. Acces To Word

In this discussion we will discuss how to create mail merge using data from Ms. Access.

As for the steps as follows:

1. Open Ms. Access.

2. create data with file name Lp3i.

3. rename the table with the Student table.

4. input data with No, NIM, Name, Department

 .      After that, open msc. Word, types title on the document same word in Excel or acces like this:

3.      Select mailing menu, select recipients, and then choose "Use an Exsisting File"

Then the menu will appear as shown below. Select the pre-made file, and then select "Open". And the dialog box will appear as below, select OK.

. Select the "insert merge field" menu, adjust it with the title in the column. For example NIM insert merge field with NIM, and so on.

Then it will fill automatically, as in the picture.

To display the data, select the "Preview Result" menu, then the data will Look like the following. To move to the next or previous record, click the arrow to the right of the Preview Result.