mailmerge from excel with multiple worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LH - 16 Feb 2007 15:50 GMT

I'm trying to use excel as my data file & word as the formatted front end.
The excel file has many worksheets. Perhaps mail merge isn't the right tool,
but linking doesn't seem to allow me to select the specific fields from each
worksheet either. Suggestions?

Reply to this Message

Doug Robbins - Word MVP - 16 Feb 2007 20:56 GMT

Word can only use a single flat data source. If the data is scattered over
a number of sheets, you will need to create on sheet that displays all of
the data in the one place so that it can be used as a data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm trying to use excel as my data file & word as the formatted front end.
> The excel file has many worksheets. Perhaps mail merge isn't the right
> tool,
> but linking doesn't seem to allow me to select the specific fields from
> each
> worksheet either. Suggestions?

Reply to this Message