Merge Document / Lock Formatting

[Shan]

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!

 

[Anne Troy]

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

 

[Doug Robbins]

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 ......

--
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

 

[Shan]

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

Thanks for your quick responses!