Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - trim field lengths
Hi Guys
I have created a label in Word 2003 using Mail Merge from a database. Everything is fine, it all pulls through fine, formatted correctly, prints fine etc etc but the issue i have is that one field can exceed a certain length and drop down onto the next line which then makes the label print over two labels. Example: Cook Adam - displays fine on one line PatientSurname Forname1 - is to long and drops the Forname1 onto the next line which pushes the label down onto two labels. Is there anyway i can restrict the length of this field and maybe insert a * to show the field has been trimmed down? Any help/suggestions would be great. Thanks in advance Adam Submitted via EggHeadCafe - Software Developer Portal of Choice IIS Network Load Balancing, Sessions and IP Affinity http://www.eggheadcafe.com/tutorials...-balancin.aspx |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - trim field lengths
Hi Adam,
Word provides no field manipulation tools (eg switches/filters) for this. However, if you place the fields into a table in which the cell heights & widths are fixed, you can prevent the text wrapping from changing the label heights - anything that doesn't fit the space provided will simply be truncated. Note too that, with a table, you have the option of formatting cells so that the text size auto-adjusts to fit the space available. -- Cheers macropod [Microsoft MVP - Word] "adam cook" wrote in message ... Hi Guys I have created a label in Word 2003 using Mail Merge from a database. Everything is fine, it all pulls through fine, formatted correctly, prints fine etc etc but the issue i have is that one field can exceed a certain length and drop down onto the next line which then makes the label print over two labels. Example: Cook Adam - displays fine on one line PatientSurname Forname1 - is to long and drops the Forname1 onto the next line which pushes the label down onto two labels. Is there anyway i can restrict the length of this field and maybe insert a * to show the field has been trimmed down? Any help/suggestions would be great. Thanks in advance Adam Submitted via EggHeadCafe - Software Developer Portal of Choice IIS Network Load Balancing, Sessions and IP Affinity http://www.eggheadcafe.com/tutorials...-balancin.aspx |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
thank you
Brilliant! that worked a treat. Thank you
Adam macropod wrote: Hi Adam,Word provides no field manipulation tools (eg switches/filters) for 08-Jan-10 Hi Adam, Word provides no field manipulation tools (eg switches/filters) for this. However, if you place the fields into a table in which the cell heights & widths are fixed, you can prevent the text wrapping from changing the label heights - anything that does not fit the space provided will simply be truncated. Note too that, with a table, you have the option of formatting cells so that the text size auto-adjusts to fit the space available. -- Cheers macropod [Microsoft MVP - Word] Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Converting a Collection into a DataTable using Generics http://www.eggheadcafe.com/tutorials...lection-i.aspx |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge using calculation field in an IF field | Mailmerge | |||
How do I trim input fields in Word 97 mail merge | Mailmerge | |||
mail merge incorrect page lengths with custom page size | Mailmerge | |||
Mail merge field different in datasource & insert a field menu | Mailmerge | |||
Mail merge field isn't displaying all the text in a field. Can I . | Mailmerge |