Data Source (Publisher 2003)

[Jessica]

I have created a data source in excel that has several worksheets. When I do
the merge it only merges one of the worksheets and all the others I have to
merge idividually. Is that normal or is there something that I have done
incorrectly. Please Advise

 

[Mary Sauer]

You can only use one data source at a time. (one worksheet)

Data sources
http://office.microsoft.com/en-us/publisher/CH063580651033.aspx

 

[Jessica]

Oh my God....

So Mary,

Out of all of the worksheets that I have created in the one book, you are
saying that I will need to move that "data" from the many sheets to one
worksheet? Huh...Now the multiple worksheets they all have different names,
so that I would know where to enter the new data, but with everything on one
worksheet, how would I determine where to put the new information? Please
advise. I hope am explaining myself correctly

 

[Mary Sauer]

Might try Word. It is far more powerful than Publisher. May have more choices.
When I setup a list it usually is a simple name, address type. I think you can
merge databases together but you will have to ask in an Excel group to find out
how or read the help entry.
Help here
http://office.microsoft.com/en-us/excel/results.aspx?qu=merge+worksheet&sc=9&av=ZXL110

 

[Ed Bennett]

Might try Word. It is far more powerful than Publisher. May have more choices.
When I setup a list it usually is a simple name, address type. I think you can
merge databases together but you will have to ask in an Excel group to find out
how or read the help entry.

Publisher 2007 will merge from multiple sources at the same time, but I
think the data still has to be set up in the same format in each one.

 

[Mary Sauer]

I did do a mail merge in 2007 and Publisher does ask you to match fields. It is
easy...

 

[Jessica]

Mary,

hummm I don't have 2007. Also you said match fields I am not clear on that
because, remember I have one workbook but multiple sheets, that will requires
me to merger every single she into a data source. Could you please clear
things up.

Thanks
--
Amy

I did do a mail merge in 2007 and Publisher does ask you to match fields. It is
easy...

 

[Mary Sauer]

Amy,
In Publisher 2003 you can merge with one database.

Ed & I were discussing the merge changes in 2007. We probably shouldn't have in
this thread.

The Office articles are your best source of help. If you can combine your data
then your merge will be a success.
http://office.microsoft.com/en-us/publisher/CH062524751033.aspx
--
Mary Sauer MSFT MVP
http://office.microsoft.com/

Mary,

hummm I don't have 2007. Also you said match fields I am not clear on that
because, remember I have one workbook but multiple sheets, that will requires
me to merger every single she into a data source. Could you please clear
things up.

Thanks