A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Setting minimum character limit?



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 03:41 PM posted to microsoft.public.word.mailmerge.fields
Cindy
external usenet poster
 
Posts: 385
Default Setting minimum character limit?

Greetings, I am merging data from an excel spreadsheet onto labels in Word
(2003). Is there anyway I can restrict a field size to only 5-6 characters
rather than the entire cell contents being merged onto the label?

Any suggestions would be greatly appreciated! Thanks!!


  #2  
Old June 4th, 2010, 03:54 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Setting minimum character limit?

You can't merge part of a field - You would have to derive a new field in
your excel sheet containing the part of the data you require and merge that
field instead.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Cindy" wrote in message
...
Greetings, I am merging data from an excel spreadsheet onto labels in
Word
(2003). Is there anyway I can restrict a field size to only 5-6
characters
rather than the entire cell contents being merged onto the label?

Any suggestions would be greatly appreciated! Thanks!!




  #3  
Old June 4th, 2010, 05:22 PM posted to microsoft.public.word.mailmerge.fields
Cindy
external usenet poster
 
Posts: 385
Default Setting minimum character limit?

I was afraid you would say that but. . .I was able to do a work around by
creating another table (1 row, 1 column, retricted size) inside the label.
It worked perfectly. Thanks.

"Graham Mayor" wrote:

You can't merge part of a field - You would have to derive a new field in
your excel sheet containing the part of the data you require and merge that
field instead.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Cindy" wrote in message
...
Greetings, I am merging data from an excel spreadsheet onto labels in
Word
(2003). Is there anyway I can restrict a field size to only 5-6
characters
rather than the entire cell contents being merged onto the label?

Any suggestions would be greatly appreciated! Thanks!!




.

  #4  
Old June 5th, 2010, 09:58 AM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Setting minimum character limit?

Hi Cindy,

If you put the mergefield into a table cell with a fixed width & height, just sufficient for the # characters you want, that will
effectively limit the displayed output to a fixed width (all the data will be in the cell, though, in case it's needed). Do note
that, with proportional fonts, the displayed character count will vary according to the individual character widths.

--
Cheers
macropod
[Microsoft MVP - Word]


"Cindy" wrote in message ...
I was afraid you would say that but. . .I was able to do a work around by
creating another table (1 row, 1 column, retricted size) inside the label.
It worked perfectly. Thanks.

"Graham Mayor" wrote:

You can't merge part of a field - You would have to derive a new field in
your excel sheet containing the part of the data you require and merge that
field instead.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Cindy" wrote in message
...
Greetings, I am merging data from an excel spreadsheet onto labels in
Word
(2003). Is there anyway I can restrict a field size to only 5-6
characters
rather than the entire cell contents being merged onto the label?

Any suggestions would be greatly appreciated! Thanks!!




.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.