A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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 » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Setting minimum character limit?



 
 
Thread Tools Display Modes
  #1  
Old June 4th 10, 03:41 PM posted to microsoft.public.word.mailmerge.fields
Cindy
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!!


Ads
  #2  
Old June 4th 10, 03:54 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
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  
Old June 4th 10, 05:22 PM posted to microsoft.public.word.mailmerge.fields
Cindy
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  
Old June 5th 10, 09:58 AM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,060
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 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 07:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.