Prev: To see document page number at bottom of monitor screen
Next: Macro checkbox
From: MikeB on 5 Feb 2010 08:28
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!
From: Suzanne S. Barnhill on 5 Feb 2010 10:01
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" <mpbrede(a)gmail.com> wrote in message
news:fff84235-e4b1-4c50-bc55-773f39d54c08(a)m16g2000yqc.googlegroups.com...
> 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!
>

From: Jay Freedman on 5 Feb 2010 10:21
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.


On Fri, 5 Feb 2010 05:28:36 -0800 (PST), MikeB <mpbrede(a)gmail.com>
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!
From: MikeB on 5 Feb 2010 10:23
On Feb 5, 9:01 am, "Suzanne S. Barnhill" <sbarnh...(a)mvps.org> 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" <mpbr...(a)gmail.com> wrote in message
>
> news:fff84235-e4b1-4c50-bc55-773f39d54c08(a)m16g2000yqc.googlegroups.com...
>
> > 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?
From: Terry Farrell on 5 Feb 2010 10:33
Yes, create a template containing a table to match your custom cards
(essentially labels are just a table).

--
Terry Farrell - MSWord MVP

"MikeB" <mpbrede(a)gmail.com> wrote in message
news:cad13681-1df7-4e27-9474-a5f12a34317e(a)f15g2000yqe.googlegroups.com...
> On Feb 5, 9:01 am, "Suzanne S. Barnhill" <sbarnh...(a)mvps.org> 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" <mpbr...(a)gmail.com> wrote in message
>>
>> news:fff84235-e4b1-4c50-bc55-773f39d54c08(a)m16g2000yqc.googlegroups.com...
>>
>> > 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?

 |  Next  |  Last
Pages: 1 2
Prev: To see document page number at bottom of monitor screen
Next: Macro checkbox