Help!

How do I print names and addresses on a preprinted postcard?

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields RSS
Next:  try to use word 2007  
Author Message
A Noblitt
External


Since: Oct 18, 2005
Posts: 5



PostPosted: Wed Mar 14, 2007 12:48 am    Post subject: How do I print names and addresses on a preprinted postcard?
Archived from groups: microsoft>public>word>mailmerge>fields (more info?)

I have a file that originated in MS Excel with names and addresses. I want
to send each of them a preprinted 4.25" x 5.5" postcard, and have the printer
print the address on each postcard. Using the mail merge function of MS Word
doesn't seem to be working and is just frustrating me. Any ideas on steps to
take to get this working right?
Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Wed Mar 14, 2007 8:04 am    Post subject: Re: How do I print names and addresses on a preprinted postcard? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

If they are individual postcards this is a straightforward letter merge. If
they are microperforated cards 3 or 4 to a sheet then it would be a label
merge. For either - http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
should help.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

A Noblitt wrote:
> I have a file that originated in MS Excel with names and addresses.
> I want to send each of them a preprinted 4.25" x 5.5" postcard, and
> have the printer print the address on each postcard. Using the mail
> merge function of MS Word doesn't seem to be working and is just
> frustrating me. Any ideas on steps to take to get this working right?
Back to top
A Noblitt
External


Since: Oct 18, 2005
Posts: 5



PostPosted: Fri Mar 16, 2007 6:12 pm    Post subject: Re: How do I print names and addresses on a preprinted postcard? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you Graham. That was a wonderful write-up that you had, and it cleared
up a lot of my mail merge questions.

I wasn't able to make this work with letters (due to page size), so chose
the label route, and found a postcard in that menu that matches the size that
I have. Everything is working except that I can't get the name and address
to print in the lower right quarter of the postcard. MS Word wants to print
it near the top or middle right, and nothing that I do seems to correct that.
Any suggestions?

"Graham Mayor" wrote:

> If they are individual postcards this is a straightforward letter merge. If
> they are microperforated cards 3 or 4 to a sheet then it would be a label
> merge. For either - http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
> should help.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
> A Noblitt wrote:
> > I have a file that originated in MS Excel with names and addresses.
> > I want to send each of them a preprinted 4.25" x 5.5" postcard, and
> > have the printer print the address on each postcard. Using the mail
> > merge function of MS Word doesn't seem to be working and is just
> > frustrating me. Any ideas on steps to take to get this working right?
>
>
>
Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Sat Mar 17, 2007 8:01 am    Post subject: Re: How do I print names and addresses on a preprinted postcard? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Text in a table is subject to the same formatting commands as any other
text. By means of a combination of cell alignment and paragraph formatting
you can place the text anywhere in the cell. Start with the cell alignment
to 'Top' use spacing before the first paragraph around 2" and if you want it
on the right set a tab stop.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

A Noblitt wrote:
> Thank you Graham. That was a wonderful write-up that you had, and it
> cleared up a lot of my mail merge questions.
>
> I wasn't able to make this work with letters (due to page size), so
> chose the label route, and found a postcard in that menu that matches
> the size that I have. Everything is working except that I can't get
> the name and address to print in the lower right quarter of the
> postcard. MS Word wants to print it near the top or middle right,
> and nothing that I do seems to correct that. Any suggestions?
>
> "Graham Mayor" wrote:
>
>> If they are individual postcards this is a straightforward letter
>> merge. If they are microperforated cards 3 or 4 to a sheet then it
>> would be a label merge. For either -
>> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm should help.
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>> A Noblitt wrote:
>>> I have a file that originated in MS Excel with names and addresses.
>>> I want to send each of them a preprinted 4.25" x 5.5" postcard, and
>>> have the printer print the address on each postcard. Using the mail
>>> merge function of MS Word doesn't seem to be working and is just
>>> frustrating me. Any ideas on steps to take to get this working
>>> right?
Back to top
A Noblitt
External


Since: Oct 18, 2005
Posts: 5



PostPosted: Mon Mar 19, 2007 3:34 pm    Post subject: Re: How do I print names and addresses on a preprinted postcard? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Graham,

Thank you. My formatting seems to be okay left-to-right. It is the
distance from the top that is causing me problems. I had thought that I
could fix it with a Format-Paragraph command or something in page setup, but
it doesn't seem to be working. On my screen, I can see four postcards that
are correct in every other way.

Thanks again for your help. Sorry to be a bother.

"Graham Mayor" wrote:

> Text in a table is subject to the same formatting commands as any other
> text. By means of a combination of cell alignment and paragraph formatting
> you can place the text anywhere in the cell. Start with the cell alignment
> to 'Top' use spacing before the first paragraph around 2" and if you want it
> on the right set a tab stop.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
> A Noblitt wrote:
> > Thank you Graham. That was a wonderful write-up that you had, and it
> > cleared up a lot of my mail merge questions.
> >
> > I wasn't able to make this work with letters (due to page size), so
> > chose the label route, and found a postcard in that menu that matches
> > the size that I have. Everything is working except that I can't get
> > the name and address to print in the lower right quarter of the
> > postcard. MS Word wants to print it near the top or middle right,
> > and nothing that I do seems to correct that. Any suggestions?
> >
> > "Graham Mayor" wrote:
> >
> >> If they are individual postcards this is a straightforward letter
> >> merge. If they are microperforated cards 3 or 4 to a sheet then it
> >> would be a label merge. For either -
> >> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm should help.
> >>
> >> --
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> Graham Mayor - Word MVP
> >>
> >> My web site www.gmayor.com
> >> Word MVP web site http://word.mvps.org
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>
> >> A Noblitt wrote:
> >>> I have a file that originated in MS Excel with names and addresses.
> >>> I want to send each of them a preprinted 4.25" x 5.5" postcard, and
> >>> have the printer print the address on each postcard. Using the mail
> >>> merge function of MS Word doesn't seem to be working and is just
> >>> frustrating me. Any ideas on steps to take to get this working
> >>> right?
>
>
>
Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Tue Mar 20, 2007 9:02 am    Post subject: Re: How do I print names and addresses on a preprinted postcard? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Select the first line of the address. Right click > paragraph > in the space
before box type (say) 2". This will drop that line by two inches. The rest
will surely follow. Propagate the labels to add the changes to the other
labels.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

A Noblitt wrote:
> Graham,
>
> Thank you. My formatting seems to be okay left-to-right. It is the
> distance from the top that is causing me problems. I had thought
> that I could fix it with a Format-Paragraph command or something in
> page setup, but it doesn't seem to be working. On my screen, I can
> see four postcards that are correct in every other way.
>
> Thanks again for your help. Sorry to be a bother.
>
> "Graham Mayor" wrote:
>
>> Text in a table is subject to the same formatting commands as any
>> other text. By means of a combination of cell alignment and
>> paragraph formatting you can place the text anywhere in the cell.
>> Start with the cell alignment to 'Top' use spacing before the first
>> paragraph around 2" and if you want it on the right set a tab stop.
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>> A Noblitt wrote:
>>> Thank you Graham. That was a wonderful write-up that you had, and
>>> it cleared up a lot of my mail merge questions.
>>>
>>> I wasn't able to make this work with letters (due to page size), so
>>> chose the label route, and found a postcard in that menu that
>>> matches the size that I have. Everything is working except that I
>>> can't get the name and address to print in the lower right quarter
>>> of the postcard. MS Word wants to print it near the top or middle
>>> right, and nothing that I do seems to correct that. Any suggestions?
>>>
>>> "Graham Mayor" wrote:
>>>
>>>> If they are individual postcards this is a straightforward letter
>>>> merge. If they are microperforated cards 3 or 4 to a sheet then it
>>>> would be a label merge. For either -
>>>> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm should
>>>> help.
>>>>
>>>> --
>>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>>> Graham Mayor - Word MVP
>>>>
>>>> My web site www.gmayor.com
>>>> Word MVP web site http://word.mvps.org
>>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>>>
>>>> A Noblitt wrote:
>>>>> I have a file that originated in MS Excel with names and
>>>>> addresses. I want to send each of them a preprinted 4.25" x 5.5"
>>>>> postcard, and have the printer print the address on each
>>>>> postcard. Using the mail merge function of MS Word doesn't seem
>>>>> to be working and is just frustrating me. Any ideas on steps to
>>>>> take to get this working right?
Back to top
A Noblitt
External


Since: Oct 18, 2005
Posts: 5



PostPosted: Tue Mar 20, 2007 11:28 pm    Post subject: Re: How do I print names and addresses on a preprinted postcard? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Graham,

I wasn't able to get that to work. However, I think that I found a
work-around by having the postcards pretend to be envelopes. Thanks again
for all of your assistance.

Sincerely,
Alan Noblitt

"Graham Mayor" wrote:

> Select the first line of the address. Right click > paragraph > in the space
> before box type (say) 2". This will drop that line by two inches. The rest
> will surely follow. Propagate the labels to add the changes to the other
> labels.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
> A Noblitt wrote:
> > Graham,
> >
> > Thank you. My formatting seems to be okay left-to-right. It is the
> > distance from the top that is causing me problems. I had thought
> > that I could fix it with a Format-Paragraph command or something in
> > page setup, but it doesn't seem to be working. On my screen, I can
> > see four postcards that are correct in every other way.
> >
> > Thanks again for your help. Sorry to be a bother.
> >
> > "Graham Mayor" wrote:
> >
> >> Text in a table is subject to the same formatting commands as any
> >> other text. By means of a combination of cell alignment and
> >> paragraph formatting you can place the text anywhere in the cell.
> >> Start with the cell alignment to 'Top' use spacing before the first
> >> paragraph around 2" and if you want it on the right set a tab stop.
> >>
> >> --
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> Graham Mayor - Word MVP
> >>
> >> My web site www.gmayor.com
> >> Word MVP web site http://word.mvps.org
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>
> >> A Noblitt wrote:
> >>> Thank you Graham. That was a wonderful write-up that you had, and
> >>> it cleared up a lot of my mail merge questions.
> >>>
> >>> I wasn't able to make this work with letters (due to page size), so
> >>> chose the label route, and found a postcard in that menu that
> >>> matches the size that I have. Everything is working except that I
> >>> can't get the name and address to print in the lower right quarter
> >>> of the postcard. MS Word wants to print it near the top or middle
> >>> right, and nothing that I do seems to correct that. Any suggestions?
> >>>
> >>> "Graham Mayor" wrote:
> >>>
> >>>> If they are individual postcards this is a straightforward letter
> >>>> merge. If they are microperforated cards 3 or 4 to a sheet then it
> >>>> would be a label merge. For either -
> >>>> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm should
> >>>> help.
> >>>>
> >>>> --
> >>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>>> Graham Mayor - Word MVP
> >>>>
> >>>> My web site www.gmayor.com
> >>>> Word MVP web site http://word.mvps.org
> >>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>>>
> >>>> A Noblitt wrote:
> >>>>> I have a file that originated in MS Excel with names and
> >>>>> addresses. I want to send each of them a preprinted 4.25" x 5.5"
> >>>>> postcard, and have the printer print the address on each
> >>>>> postcard. Using the mail merge function of MS Word doesn't seem
> >>>>> to be working and is just frustrating me. Any ideas on steps to
> >>>>> take to get this working right?
>
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum