Mail merge multiple times on one page?

M

MikeB

Hi, I have an interesting problem that I can't 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!
 
S

Suzanne S. Barnhill

This is a "label" merge. If you're 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're 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
 
M

MikeB

This is a "label" merge. If you're 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're 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 USAhttp://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?
 
T

Terry Farrell

Yes, create a template containing a table to match your custom cards
(essentially labels are just a table).
 
S

Suzanne S. Barnhill

I think you'll find that if you're using the entire page divided in four,
the Avery/MS templates will work just fine. If you're using just part of the
page, then you'll need to create a 2x2 table and modify margins and such
accordingly. It's 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

This is a "label" merge. If you're 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're 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 USAhttp://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?
 

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