Creating church directory by merge document

J

Jewel-e

I am trying to create a 3-column directory of names and addresses, the data
source is an xcell spread sheet. I have been able to enter codes but can
find no way, at end of grouping to go to the next record. AND I can find
no "if" statements to help organizing. I am doing it in Publisher.
I have tried Word but ran into the same problems. FYI this is a
church directory.
Names, addresses, birthdates, etc. Thank you.
 
J

Jewel-e

I had already looked into the teaching tools and was only able to get one
record in the upper left corner of one page. Could not format page;
Wizard did NOT give me any help I couldn't figure out myself.

Then I went to your webpage (to find method of 3-column down in columns)
Found absolutely nothing there to help. I'm getting very frustrated.

I went to Walden's Books today looking for a Que Book or any teaching tool.
No Luck! None of them show / tell how to build a template for a merge
document. We are getting desperate! I could have done this very easily
in Word 95 or 97 - but now in 2003 they have basically eliminated this
service. Jewel-e
 
J

Jewel-e

When I used "merge' with earlier office version, I had no problem as it was
very user friendly. I inserted fields from another data base, then put in
instructions ("if" statements) and ended it with a "next" command to continue
on to next "record".

Now IT insists on using Publisher (which I've used for years in an earlier
version - but not for a directory). I NEED a directory that the final
version, after input from data source, can be edited. I NEED it to be in
3 columns with data that varies by record. Some records have only 5 fields
needed, while others have 10 fields in the directory.

AND, it needs to go down column one and then down column two and then down
column three and on to the next page. There are about 500 records and I am
formatting in a two page format so it can be printed back to back.

I don't know where to go to get the help I need, this looks like my last
hope. I know I can get it set up at the local printer, but we can't afford
that. Is there any MS service I can get help from. Their printed
instructions leave soooooo much out and don't allow for any variances.
I'm not anxious to go to the church and say I can't do this. I've been
making catelogs, business cards, letterheads, etc. for years and teaching as
well. I'm not stupid or uninformed. This can't be this difficult.
I just need to know what to do. Jewel-e
 
M

Mary Sauer

As I stated, Publisher will not merge down, but across. That said, in step 5 of
the merge you can create a new publication, this will allow you to edit each and
every name.
I don't remember any version of Publisher that had the "if" and "next" command.
 
J

Jewel-e

Thanks, I guess I'll have to do it in Word. There are just too many
unfriendly quirks in Publisher. But I know I'm still going to run into
the same problems (next and ifs). One of the girls at church has run a draft
copy in word but it looks horrible. I'm just going to have to see if I can
clean it up. Again thanks for your help. J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top