Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy Cindy is offline
external usenet poster
 
Posts: 66
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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy Cindy is offline
external usenet poster
 
Posts: 66
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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
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!!




.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink Character limit RSC Microsoft Word Help 5 November 3rd 14 07:24 AM
Hyperlink character limit mohill Microsoft Word Help 8 February 2nd 06 01:38 AM
Character limit LMB New Users 4 December 2nd 05 02:35 PM
Cell character limit? Sara Tables 3 October 11th 05 08:28 PM
Sql Query: 255 character Limit Mark Olbert Mailmerge 2 January 31st 05 08:33 PM


All times are GMT +1. The time now is 03:37 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"