Is there a way to get around 255 char limit on catalog merge?


D

DBodell

I am trying to use the new catalog and mailmerge functions in 2003. In
particular, being able to merge pictures in with text for our garden center
signs is wonderful! However, there is a limit of 255 characters for total
merge text. Our signs have rather lengthy descriptions of plants and growing
conditions, so this is a problem. Is there any way around this through
programming?
 
Ad

Advertisements

M

Mary Sauer

Don't know about programming, couldn't you use two merge fields for the text?
 
C

Chuck Davis

-----Original Message-----
I am trying to use the new catalog and mailmerge functions in 2003. In
particular, being able to merge pictures in with text for our garden center
signs is wonderful! However, there is a limit of 255 characters for total
merge text. Our signs have rather lengthy descriptions of plants and growing
conditions, so this is a problem. Is there any way around this through
programming?
.
Mary's suggestion is correct. I have used the technique
where I have a silent auction catalog description divided
into two fields (in my case in Excel). Publisher's mail
merge tnen is used to print the catalog for the auction and
on a subsequent pass, the bid sheets. It this case the
catalog and bid sheet are required to be identical.

In Excel, I used this in the adjacent column to let me know
exactly the length of data entered. =LEN(P746) Where P is
the column and 746 is the row. A great time saver.
 
D

DBodell

Mary, I thought that the limitation on merging was that the entire length of
the record being merged was limited to 255 characters, not the length of any
one text box. If I was wrong, then of course I could have used more than one
merge field for the text... (read this as if I were saying "I coulda had a
V-8!")! I will try this out. I couldn't believe that Publisher would limit
someone to so few characters for merging. I have two Memo fields in my
database for plant descriptions and therefore have text that exceeds 255.
Please let me know if I was actually wrong in my assumption. I really
appreciate the help!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top