Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mark1110 Mark1110 is offline
external usenet poster
 
Posts: 2
Default Determine Length Of Mail Merge Field

Hi,

I have a mail merge document that gets its information from an excel file.
Is there a function in word that will give me the length of the one of the
fields, i.e. mm_name? If not, is there a way to treat a phone number (555)
555-1212 as one word so the (555) is not on one line and 555-1212 on another.
The user won't delete the space between after the ) or will the user start
the phone number on a separate line.

I am currently adding spaces before the phone number and if the mm_name is
under 12 characters the letter looks okay, however if it is over 12
characters you something like this:

Jonathon Longname (555) 555-1212.

If not, is there a way when the letter is printed to delete all instances of
spaces that 2 or greater and just make them one space?

Here is the statement I tried but with no luck:

IF {len({MERGEFIELD FullName}+ {MERGEFIELD FirstName}) 10 AND
len({MERGEFIELD FullName}+ {MERGEFIELD FirstName}) 19 SPACE(19 -
len({MERGEFIELD FullName}+ {MERGEFIELD FirstName})}

I have never tried this in a word document. Am I using the correct syntax?


Thanks,

Mark
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Determine Length Of Mail Merge Field

See response in the VBA General newsgroup.

Please do not post questions separately to multiple newsgroups. Rather,
insert the names of all of the newsgroups into the header of a single
message.


--
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, originally posted via msnews.microsoft.com

"Mark1110" wrote in message
...
Hi,

I have a mail merge document that gets its information from an excel file.
Is there a function in word that will give me the length of the one of the
fields, i.e. mm_name? If not, is there a way to treat a phone number (555)
555-1212 as one word so the (555) is not on one line and 555-1212 on
another.
The user won't delete the space between after the ) or will the user start
the phone number on a separate line.

I am currently adding spaces before the phone number and if the mm_name is
under 12 characters the letter looks okay, however if it is over 12
characters you something like this:

Jonathon Longname (555) 555-1212.

If not, is there a way when the letter is printed to delete all instances
of
spaces that 2 or greater and just make them one space?

Here is the statement I tried but with no luck:

IF {len({MERGEFIELD FullName}+ {MERGEFIELD FirstName}) 10 AND
len({MERGEFIELD FullName}+ {MERGEFIELD FirstName}) 19 SPACE(19 -
len({MERGEFIELD FullName}+ {MERGEFIELD FirstName})}

I have never tried this in a word document. Am I using the correct syntax?


Thanks,

Mark


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Determine Length Of Mail Merge Field

Hi Mark,

Word has no field manipulation tools for this. You'll need to modify the source data. For example, you could delete the spaces and
brackets, then use field maths in Word to parse the resulting mergefield and restore them - with brackets, non-breaking spaces
and/or non-breaking hyphens.

--
Cheers
macropod
[Microsoft MVP - Word]


"Mark1110" wrote in message ...
Hi,

I have a mail merge document that gets its information from an excel file.
Is there a function in word that will give me the length of the one of the
fields, i.e. mm_name? If not, is there a way to treat a phone number (555)
555-1212 as one word so the (555) is not on one line and 555-1212 on another.
The user won't delete the space between after the ) or will the user start
the phone number on a separate line.

I am currently adding spaces before the phone number and if the mm_name is
under 12 characters the letter looks okay, however if it is over 12
characters you something like this:

Jonathon Longname (555) 555-1212.

If not, is there a way when the letter is printed to delete all instances of
spaces that 2 or greater and just make them one space?

Here is the statement I tried but with no luck:

IF {len({MERGEFIELD FullName}+ {MERGEFIELD FirstName}) 10 AND
len({MERGEFIELD FullName}+ {MERGEFIELD FirstName}) 19 SPACE(19 -
len({MERGEFIELD FullName}+ {MERGEFIELD FirstName})}

I have never tried this in a word document. Am I using the correct syntax?


Thanks,

Mark


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mark1110 Mark1110 is offline
external usenet poster
 
Posts: 2
Default Determine Length Of Mail Merge Field

I am sorry for the multiple posts. I may not be able to do what I want based
on the answers I received.

As a work around, is there a way to treat the contents of a mail merge field
as one word? For example a mail merge field myPhone contains (555) 555-1212.
If that field is at the end of a line it will be split with (555) being at
the end of one line and 555-1212 being at the beginning of the next. Is there
a way to treat the contents of myPhone as one word even though there is a
space in the field so if the mail merge field is at the end of a line the
whole phone number will be displayed on the next line without it being split.

Thanks,

Mark


  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Determine Length Of Mail Merge Field

No, there is no way to do that, hence the work-arounds that have been
suggested.

--
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, originally posted via msnews.microsoft.com

"Mark1110" wrote in message
...
I am sorry for the multiple posts. I may not be able to do what I want
based
on the answers I received.

As a work around, is there a way to treat the contents of a mail merge
field
as one word? For example a mail merge field myPhone contains (555)
555-1212.
If that field is at the end of a line it will be split with (555) being at
the end of one line and 555-1212 being at the beginning of the next. Is
there
a way to treat the contents of myPhone as one word even though there is a
space in the field so if the mail merge field is at the end of a line the
whole phone number will be displayed on the next line without it being
split.

Thanks,

Mark


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
Merge Field varies in length nancyc Mailmerge 3 February 3rd 10 05:27 PM
set length of a mail merge field lborshard Mailmerge 2 February 12th 07 08:39 PM
Merge field length limitation Reggie Microsoft Word Help 1 December 4th 06 12:08 PM
can you limit the length of a mail merge field? d warren Mailmerge 1 January 6th 06 04:52 PM
determine label sheet used in mail merge MattinPhx Mailmerge 1 November 5th 05 06:16 AM


All times are GMT +1. The time now is 05:41 PM.

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

About Us

"It's about Microsoft Word"