Mail Merge in Excel 2000

M

Murtaza

I have a Form in Sheet2 like:

Name: B2
Company B3
Department B4
Emp #: B5

and list of Employees A2:D123 (more than 100 employees) with above details
in Sheet1.

I want to Print Sheet2 for each of the employee with its details. It can be
easily done with Word Mail Merge option but my form is in excel.

Is there any solution.

Regards.
 
A

Arvi Laanemets

Hi

You can do Mail Merge from Word, using your Excel table as Data source. You
have to:
1. transpose your table - so that employees info will be stored row-wise
(the best way will be using PasteSpecial Transpose option for this);
2. (optionally) to be sure, that the sheet with your table is 1st in
worksheet;
3. save the workbook;
4. in Word, start Mail Merge;
5. after seting the main document, in OpenData dialog select OpenDataSource,
set file type to Excel files, and open your Excel table;
6. continue as usually.

(When you next time open your mail merge main document, your Excel table is
opened automatically)
 
M

Murtaza

Thanks for the suggestion.

Well, I have used the Mail Merge feature before.

The problem is that I have created a Form in Excel Sheet & it could not be
transformed as Word doc EASILY. So, I want to use my Excel Form.
 
A

Arvi Laanemets

Hi

Then add a sheet, where data are read from original sheet through links, but
in proper layout for Mail Merge.
 
Top