Mail merge within MS Excel 2000 (9.0.6926 SP-3)

Topic

New Reply

I have a worksheet that I wish to print out with names of 62 individuals prior to distribution. If this was a Word document I woould use the facility therein; Excel doesn’t seem to have such.

The data is in another worksheet. Can I `mailmerge’ in Excel? And if so how?

Reply | Quote

Replies

Does this article help HOW TO: Use an Excel Data Source for Mail Merge in Word 2000?

Steve

Reply | Quote

I’m sorry that you seem to have misunderstood.

I am very capable of using an Excel database for a MailMerge to a Word document & often do so. What I want to do is use an Excel worksheet database as a source for a MailMerge to an Excel worksheet.

Reply | Quote

Excel has no mail merge capabilities. You’d have to write code to loop through the ‘records’ of the data source and plug the ‘fields’ into the appropriate locations, then either print the workbook or save it under a new name.

Reply | Quote

I understood. And as Hans mentioned in excel it is not straightforward.

My thought was to use excel in mail merge would be easiest to use the builtin capabilities of word…

Steve

Reply | Quote