Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail merge multiple times on one page?
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! |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail merge multiple times on one page?
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 "MikeB" wrote in message ... 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! |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail merge multiple times on one page?
Read the appropriate page for your version of Word:
http://www.gmayor.com/mail_merge_lab...th_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. On Fri, 5 Feb 2010 05:28:36 -0800 (PST), MikeB wrote: 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! |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail merge multiple times on one page?
On Feb 5, 9:01*am, "Suzanne S. Barnhill" wrote:
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 "MikeB" wrote in message ... 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! 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? |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail merge multiple times on one page?
Yes, create a template containing a table to match your custom cards
(essentially labels are just a table). -- Terry Farrell - MSWord MVP "MikeB" wrote in message ... On Feb 5, 9:01 am, "Suzanne S. Barnhill" wrote: 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 "MikeB" wrote in message ... 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! 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? |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Mail merge multiple times on one page?
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 "MikeB" wrote in message ... On Feb 5, 9:01 am, "Suzanne S. Barnhill" wrote: 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 "MikeB" wrote in message ... 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! 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge multiple times in same doc | Mailmerge | |||
Merge database into document multiple times | Mailmerge | |||
Merge recipient multiple times | Mailmerge | |||
Word Mail Merge, Print Selected Pages or Sections Multiple Times | Mailmerge | |||
Duplicating same box multiple times on one page | Microsoft Word Help |