How do I change an Excel merge data source in Word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan - 03 Jul 2005 16:45 GMT

I have created a form in word and have merged it with an Excel workbook. My
problem is that I want to merge data from more than one worksheet in the
workbook. Can anyone tell me how to do this or suggest another solution?

Reply to this Message

Anne Troy - 03 Jul 2005 17:05 GMT

Hi, Bryan. Depending on the version of Word (please always include version
when asking questions), you just need to change the data source. If you're
viewing the mail merge toolbar, you can choose Open Data Source, and choose
a different one.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> I have created a form in word and have merged it with an Excel workbook. My
> problem is that I want to merge data from more than one worksheet in the
> workbook. Can anyone tell me how to do this or suggest another solution?

Reply to this Message

Bryan - 03 Jul 2005 22:43 GMT

Thanks for the reply!
Microsoft Office 2000 SR-1 Professional

> Hi, Bryan. Depending on the version of Word (please always include version
> when asking questions), you just need to change the data source. If you're
[quoted text clipped - 10 lines]
> > problem is that I want to merge data from more than one worksheet in the
> > workbook. Can anyone tell me how to do this or suggest another solution?

Reply to this Message

Anne Troy - 03 Jul 2005 23:13 GMT

So, if you show the mail merge toolbar, then you should click the button to
Open Data Source. Then you can go get the different sheet.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> Thanks for the reply!
> Microsoft Office 2000 SR-1 Professional
[quoted text clipped - 13 lines]
> > > problem is that I want to merge data from more than one worksheet in the
> > > workbook. Can anyone tell me how to do this or suggest another solution?

Reply to this Message

Bryan - 03 Jul 2005 23:40 GMT

Open Data source is not on my tool bar nor is it in the add buttons helper.
That's my problem - there is no where for me to select the page from Excel
that I want. My only choice is entire workbook.

> So, if you show the mail merge toolbar, then you should click the button to
> Open Data Source. Then you can go get the different sheet.
[quoted text clipped - 27 lines]
> > > > workbook. Can anyone tell me how to do this or suggest another
> solution?

Reply to this Message

Anne Troy - 04 Jul 2005 00:06 GMT

Then go to the other sheets, select your data and type in named ranges. For
instance, call sheet2's data sheet2data or something like that.

Try resetting your mail merge toolbar, too:

http://www.officearticles.com/word/reset_toolbars_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> Open Data source is not on my tool bar nor is it in the add buttons helper.
> That's my problem - there is no where for me to select the page from Excel
[quoted text clipped - 31 lines]
> > > > > workbook. Can anyone tell me how to do this or suggest another
> > solution?

Reply to this Message

Bryan - 04 Jul 2005 23:13 GMT

Thanks Anne

> Then go to the other sheets, select your data and type in named ranges. For
> instance, call sheet2's data sheet2data or something like that.
[quoted text clipped - 46 lines]
> > > > > > workbook. Can anyone tell me how to do this or suggest another
> > > solution?

Reply to this Message

Doug Robbins - 04 Jul 2005 05:32 GMT

Mailmerge can only use a single flat data source. You will have the create
a new sheet in your Excel file that replicates on that one sheet (by
reference to the appropriate cells on the other sheets) ALL of the data that
you wish to be merged. Then you use that sheet as the 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

> Thanks for the reply!
> Microsoft Office 2000 SR-1 Professional
[quoted text clipped - 19 lines]
>> > workbook. Can anyone tell me how to do this or suggest another
>> > solution?

Reply to this Message

Bryan - 04 Jul 2005 23:08 GMT

Thanks Doug!

> Mailmerge can only use a single flat data source. You will have the create
> a new sheet in your Excel file that replicates on that one sheet (by
[quoted text clipped - 24 lines]
> >> > workbook. Can anyone tell me how to do this or suggest another
> >> > solution?

Reply to this Message

Rate this thread: