Merge Document / Lock Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shan - 13 Jul 2005 19:58 GMT

I am trying to create a merge document that I have created myself for our
sales group. This is not a letter or labels to be used for a mailing although
the merge fields contain the same data such as name, address, phone, etc.

Once I merge, it throws off the formatting (i.e., borders around merged area
such as name / phone / email address, etc., takes up 2 pages, instead of 1,
etc.

How do I prevent this? Are borders around merge fields a no-no?

Thanks!

Reply to this Message

Anne Troy - 13 Jul 2005 21:13 GMT

Hi, Shan. When you "design around" a merge field, you need to design around
the largest possible value that will populate it. So if you design around
<<mergefield company name>> and the company name is Acme Explosives and
Other Combustibles, then you could definitely have problems. Something that
MIGHT help, is in Excel, suppose your company names start in A1, somewhere
else in your workbook, you can put =len(a1) and copy that down to find the
longest value you have and then accomodate for it.
*******************
~Anne Troy

www.OfficeArticles.com

> I am trying to create a merge document that I have created myself for our
> sales group. This is not a letter or labels to be used for a mailing although
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Doug Robbins - 13 Jul 2005 21:14 GMT

A table with fixed cell dimensions might be the go, but if the information
that is being merge won't fit in the space that you have allowed then ......

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 am trying to create a merge document that I have created myself for our
> sales group. This is not a letter or labels to be used for a mailing
[quoted text clipped - 10 lines]
>
> Thanks!

Reply to this Message

Shan - 14 Jul 2005 15:35 GMT

I never thought of that, it worked! I feel so silly.

Thanks for your quick responses!

> I am trying to create a merge document that I have created myself for our
> sales group. This is not a letter or labels to be used for a mailing although
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message