Microsoft Word
(1)
Word 2007
(1)
Word
(1)
Database
(1)
OfyoutSuzanne
(1)
Barnhill
(1)
Fairhope
(1)
Alabama
(1)

Mail merge multiple times on one page?

Asked By MikeB
05-Feb-10 08:28 AM
Hi, I have an interesting problem that I cannot figure out.  I have to
create small cards that are provided 4 to a "normal" page. Each card
has individual information on it and each card changes weekly (almost
like time cards, but not the same).

Is there a way that I can set up Word such that I can use Mail merge
to pull the information from a spreadsheet or Access database (or even
a table in another Word document) to merge into the standard text?  It
would be absolutely too tedious to have to create all these cards on a
weekly basis.

Thanks!

This is a "label" merge.

Suzanne S. Barnhill replied to MikeB
05-Feb-10 10:01 AM
This is a "label" merge. If you are using Avery "post cards" or the
equivalent, look in the Envelopes and Labels | Label Options dialog list of
product numbers for Avery 8387 (landscape) or 5845 (portrait) or whatever
other stock number may be on the product you have bought. If you are using
Word 2007, there is a layout for 1/4 Letter (portrait or landscape) when you
select Microsoft as the vendor.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

Read the appropriate page for your version of Word:http://www.gmayor.

Jay Freedman replied to MikeB
05-Feb-10 10:21 AM
Read the appropriate page for your version of Word:

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
http://www.gmayor.com/merge_labels_with_word_2007.htm

--
Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

ofyoutSuzanne, thank you!

MikeB replied to Suzanne S. Barnhill
05-Feb-10 10:23 AM
of
you
t

Suzanne, thank you! As usual you have gotten me on the right track.
One teensy question though, I am not using standard card stock. Can I
modify the MS template?
Yes, create a template containing a table to match your custom
Terry Farrell replied to MikeB
05-Feb-10 10:33 AM
Yes, create a template containing a table to match your custom cards
(essentially labels are just a table).

--
Terry Farrell - MSWord MVP
I think you will find that if you are using the entire page divided in
Suzanne S. Barnhill replied to MikeB
05-Feb-10 11:42 AM
I think you will find that if you are using the entire page divided in four,
the Avery/MS templates will work just fine. If you are using just part of the
page, then you will need to create a 2x2 table and modify margins and such
accordingly. it is still helpful to start with one of the built-in label
definitions and customize it because Word's label definitions have some
magic properties that are not present in user-created templates (such as
suppressing messages about text outside the printable area).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org


Suzanne, thank you! As usual you have gotten me on the right track.
One teensy question though, I am not using standard card stock. Can I
modify the MS template?
Post Question To EggHeadCafe