Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge from excel with multiple worksheets
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge from excel with multiple worksheets
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. -- 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 "LH" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Excel worksheets | Mailmerge | |||
How do I use multiple worksheets when doing a mailmerge | Mailmerge | |||
Linking multiple excel worksheets into Word | Microsoft Word Help | |||
Mail Merge using multiple worksheets in excel? | Microsoft Word Help | |||
Using different worksheets as sources for mailmerge | Mailmerge |