Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge from more than one XL worksheet
Is it possible, within the one WOrd document to mail merge from more than one
XL worksheet? I have a XL workbook with several worksheets and want to pull data from several sheets into the one Word document |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge from more than one XL worksheet
Word can only use a single data source for mailmerge. Therefore, you would
need to insert a new sheet into your workbook and on that sheet reference the required columns from the other worksheets so that you get all of the data appearing in the one place. -- 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 "Steve" wrote in message ... Is it possible, within the one WOrd document to mail merge from more than one XL worksheet? I have a XL workbook with several worksheets and want to pull data from several sheets into the one Word document |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge document back to excell worksheet? | Mailmerge | |||
How do I e-mail an excel worksheet? | Microsoft Word Help | |||
Can I use more than 1 worksheet to merge info | Mailmerge | |||
Merge via worksheet converter | Mailmerge | |||
Select specific excel worksheet for mail merge | Mailmerge |