Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2006

Tip: Looking for answers? Try searching our database.

How do I create a template & Do A Mail Merge In It?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ReneeB - 29 Jan 2006 02:37 GMT
I downloaded a template for jumbo postcards.  I need to make the front of the
card as well as part of its back so that it's not editable.  I also need to
be able to do a mail merge in the lower right area of the card.  When I tried
doing a mail merge in the post card, it only added <<Address>> a the box of
the top portion/Postcard 1 of the template, but the bottom/Postcard 2 was
left alone.  Also, when I tried to preview it, Address boxes were both blank.
Any suggestions?
Doug Robbins - Word MVP - 29 Jan 2006 06:55 GMT
See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I downloaded a template for jumbo postcards.  I need to make the front of
>the
[quoted text clipped - 8 lines]
> blank.
> Any suggestions?
Graham Mayor - 29 Jan 2006 12:24 GMT
Given that you have not told us where you got this template from we can only
make wild guesses about how it was created. If the fields you insert don't
work it is probably because the template uses text boxes. Fields in text
boxes are not seen by the merge, being in the drawing layer of the document.

The thing to do is to create a two row two column table, where the two rows
correspond to one side of the cards (you'll need another merge document for
the backs). Set this up as a form letter merge. Put your merge fields in the
right hand top cell  column and format them as you want. Copy and paste to
the cell below. Add a Next field to the start of that cell. Put your fixed
information in the left cells. Merge to a new document.

http://www.gmayor.com/graphics_on_labels.htm and
http://www.gmayor.com/mail_merge_graphics.htm

may help
Signature

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

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

> I downloaded a template for jumbo postcards.  I need to make the
> front of the card as well as part of its back so that it's not
[quoted text clipped - 4 lines]
> when I tried to preview it, Address boxes were both blank. Any
> suggestions?
ReneeB - 29 Jan 2006 16:49 GMT
We have several templates going on in this example.  The first one I spoke of
is a template I downloaded from destopsupplies.com  for the jumbo postcards
that I bought.  After saving the postcard's template, I then designed a
postcard front and back.  I would now like to save that design as a template
and use it in a mail merge.  

Keep in mind that since it's a jumbo postcard, there are 2 cards per sheet
that need to be recognized in the merge so that it will add 2 addresses per
sheet.

So, my problem is 2 pt.  How do I save the newly created designs as a
template and then do a mail merge/set up an address field that will be
recognize the top and bottom cards?

> Given that you have not told us where you got this template from we can only
> make wild guesses about how it was created. If the fields you insert don't
[quoted text clipped - 20 lines]
> > when I tried to preview it, Address boxes were both blank. Any
> > suggestions?
Doug Robbins - Word MVP - 29 Jan 2006 17:06 GMT
You use File>Save As the save the document.

For the mailmerge part, after attaching the data source to the template, you
insert the merge fields into both of the post cards on the template in the
configuration that you want the information to appear and before the first
merge field in the second post card, insert a <<Next Record>> field.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> We have several templates going on in this example.  The first one I spoke
> of
[quoted text clipped - 46 lines]
>> > when I tried to preview it, Address boxes were both blank. Any
>> > suggestions?
ReneeB - 30 Jan 2006 23:00 GMT
Thanks!  I appreciate your help.  :)

> You use File>Save As the save the document.
>
[quoted text clipped - 53 lines]
> >> > when I tried to preview it, Address boxes were both blank. Any
> >> > suggestions?
Graham Mayor - 30 Jan 2006 07:57 GMT
With the proviso that the merge will not see any fields you have put in a
text box, simply save the document as a template.
As for the data for thge second card, add a Next record field at the start
of the second card.

Signature

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

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

> We have several templates going on in this example.  The first one I
> spoke of is a template I downloaded from destopsupplies.com  for the
[quoted text clipped - 44 lines]
>>> left alone.  Also, when I tried to preview it, Address boxes were
>>> both blank. Any suggestions?
ReneeB - 30 Jan 2006 22:59 GMT
Thanks!  I appreciate the help.  :)

> With the proviso that the merge will not see any fields you have put in a
> text box, simply save the document as a template.
[quoted text clipped - 49 lines]
> >>> left alone.  Also, when I tried to preview it, Address boxes were
> >>> both blank. Any suggestions?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.