Excel merge to Publisher 2003

[Jessica]

Hello,

I would like to create a directory by merging my excel spreadsheet data to
Publisher, with the end result being a directory that includes contact
information. Within the spread that are 15sheets that I would have to merge.

Please advise

 

[Mary Sauer]

For a directory I'd recommend the catalog merge.

Lots of help here
Mail and catalog merge
http://office.microsoft.com/en-us/publisher/CH062524751033.aspx

 

[Jessica]

Hello,

Thanks for the link, however I have attempted to follow the instructions as
best I can, but now once I have merged the data and I do see the pages at the
bottom of the screen but know data hows up an any of the 52 pages

Please advise

 

[Mary Sauer]

Could you explain to me what the 15 sheets are? What entries have you inserted
into the merge block if you are using the catalog merge?

 

[Jessica]

Yes. I started our with a blank document, the mail and catalog merge, catalog
merge| I selected catalog Merge| selected data source that was created in
Excel 2003| For the create my template I browsed to the data source
spreadsheet that was designed.... and then I create the New Publication

Thanks--

Nancy

 

[Mary Sauer]

Nancy,
After you create a catalog merge block, insert your text box(es) into the block.
Insert your fields in the text boxes as how you would like to have the finished
directory to look. In step five create a new publication. You can edit these
pages, move objects around.

It sounds like you are doing the correct thing. What is going wrong for you?

 

[Jessica]

Well, I decided to just create re-create the data, even more so when the data
that was merged over appear to have some issues... I think this is the best
thing anyways is to have clean data to prevent any future problems.

However, the problem that I am having now is that once I merge the data, it
all goe on different pages instead of filling up one page and then going to
the next page. I created another object and I still experience the same name
poping up. I did double check my entries and the names are all different.

Thanks,

Nancy

 

[Mary Sauer]

Nancy, When you do a merge you can only have one merge area on your screen. The
merge block should tell you how many entries will fit on your page.

 

[Jessica]

Mary,

Things are still not working out. When I access my data source which is an
excel spreadsheets that has 12 sheets with10 heading fields, so once the data
is access to create the "Catalog Record" I will then merge the catalog
records and only 10 records show up in the "catalog records" and about 10
boxes with checks in there only, but know data within the "Catalog Records".
I have a lest 2000+ pieces of data that needs to be merge into a catalog

Please advise,

Nancy

 

[Mary Sauer]

Might be the batch size?
The Registry Fix
for changing the Mail Merge Batch Size
http://ed.mvps.org/Static.aspx?=Publisher/registryfix

You can only use one data sheet for your merge. The data sheet can have any
number of fields.

 

[Jessica]

Nancy,

I changed the registry settings and rebooted, launched publisher, opened a
new page, set the page to print a booklet, selected yes to automatically
insert new pages, selected the mail and merge catalog wizard, selected the
merge type, which was catalog, step one: selected my data source "excel",
selected use an assisting list etc. Please advise

Nancy

 

[Oceaneer]

Sounds like you need all of the data on one sheet. I don't think you will be
able to pull data from different sheets into one merge.