Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to limit the number of characters in a mail merge field
I use mail merge from a database to print mailing labels. I would like to
limit the number of characters that will be entered into a field so as not to mess up my label formatting. For example, I want no more than 20 characters in the field for company name on my labels. I am willing to simply truncate the data to the first 20 characters. No fancy logic required. Thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to limit the number of characters in a mail merge field
The best place to manipulate the data is in the database. There is no way
to do it as part of the mailmerge process. -- 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 "pschatz100" wrote in message ... I use mail merge from a database to print mailing labels. I would like to limit the number of characters that will be entered into a field so as not to mess up my label formatting. For example, I want no more than 20 characters in the field for company name on my labels. I am willing to simply truncate the data to the first 20 characters. No fancy logic required. Thanks. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to limit the number of characters in a mail merge field
Not sure how to do this in Word, but it can be done if you use an Access
report instead of a Word mail-merge doc. Just make the text boxes the size you want, and any excess length will be truncated. An advantage of this method is that it limits not the number of characters, but the physical length of the field - which is what you need to control to avoid messing up your formatting. With proportional fonts, the number of characters that fit in a physical space depends on the widths of the characters. -- Ted "pschatz100" wrote: I use mail merge from a database to print mailing labels. I would like to limit the number of characters that will be entered into a field so as not to mess up my label formatting. For example, I want no more than 20 characters in the field for company name on my labels. I am willing to simply truncate the data to the first 20 characters. No fancy logic required. Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a phone number in a mail merge field? | Mailmerge | |||
Limit decimal places in mail merge document | Mailmerge | |||
How to stop Word from truncating data in an mail merge field? | Mailmerge | |||
How do I mail merge fields exceeding 255 characters from Excel to. | Mailmerge | |||
International characters in mail merge | Mailmerge |