Make a Phone list from an Access Database?

[Joe]

Hello,

I want to make a phone list for a Homeowners Association.
I know how to make merged letters, merged envelopes and
merged labels, but I cannot make a multi-columned phone
list. I would also like to have it printed so it is like
a phone book - Landscape alligned and folded in half.

I have tried using labels, but that did not work well -
spacing, headers, footers - all caused too many problems.
I also want to add an image and some text at the top of
the first page, and then some more at the end of the phone
list on the last page.

I am certain there is an easy way to do this (without
knowing lots of code) but I just can't figure it out. I
appreciate any and all assistance!

Joe

 

[Doug Robbins - Word MVP]

If my name was Joe, I would use a report in Access. In fact that's also
what I would do with my present name.

If for some reason, you want to do it some other way, use a Catalog or
Directory type mailmerge in Word.

For the booklet part of it, see the article "Booklet printing" at:

http://word.mvps.org/FAQs/Formatting/BookletPrinting.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Joe,

I want to make a phone list for a Homeowners Association.
I know how to make merged letters, merged envelopes and
merged labels, but I cannot make a multi-columned phone
list. I would also like to have it printed so it is like
a phone book - Landscape alligned and folded in half.

I have tried using labels, but that did not work well -
spacing, headers, footers - all caused too many problems.
I also want to add an image and some text at the top of
the first page, and then some more at the end of the phone
list on the last page.

Merge type: catalog merge

For the headers/footers: you need a StyleRef field to make
"dictionary style" entries in the header. Format the entries
with a particular style name.

Text at the beginning and end: This either needs to be done
using IF fields. Or you add it after the merge to a new
document. For an example of how to use IF fields, take a look
at the Mail Merge FAQ on my website.

Set up newspaper type columns. Format all the paragraphs in
an "address block" with "Keep together" and "Keep with next".
Have one or two empty paragraphs following that are NOT
formatted with these settings. In this way, no address block
will "break up".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail