Re: mail merge if statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Unfortunately you cannot use number switches on text fields and there is no
way to extract part of a text field using fields. You need to change the
type of data source field to a number field. How readily this can be
achieved would be determined by your data application.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

kyle''s wrote:
Hi Graham,

thanks for you quick response! I have another questions for you
(lucky you). lol

The way all of our users enter the phone number into our database
system is 07 5555 5555 or (07) 5555 5555. The country code is ok
cause we will only be using the one eg. +61. Is there a way of the
phone number being displayed as

{ Mergefield Phone \# "0' '0000' '0000" }

without having to amend all our records in our database to 0755555555?

many thanks.



"Graham Mayor" wrote:

It rather depends on what the phone number field produces in Word
during a merge

If it produces the number 0755555555 then what you ask is fairly
straightforward, if it doesn't it would be worth amending the data to
achieve that. If you only have the one country code to consider then
you don't need a conditional field, you need a field switch and the
+61 ewntered as text before it.

+61 { Mergefield Phone \# "0' '0000' '0000" }

If you just want to add the switch to some of your numbers based on
country then

{ IF { Mergefield Country } = "Cocos-Keeling Islands" "+61 {
Mergefield Phone \# "0' '0000' '0000" }" "{Mergefield Phone \# "00'
'0000' '0000" }" }

should do the trick.

You could even add a country code to your data source and then merge
the two fields eg

IF {Mergefield Country} <> "Name of your country" "{Mergefield
CountryCode} { Mergefield Phone \# "0' '0000' '0000" }" "{Mergefield
Phone \# "00' '0000' '0000" }" }

Where "Name of your country" is the actual country name from your
data source.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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


kyle''s wrote:
is it possible to create an if statement to change the format of a
phone number.

we have in our database client phone numbers eg 07 5555 5555, can I
create an if statement to have the number displate as +61 7 5555
5555, or am I asking too much?

Any help would be much appreciated.


.

Relevant Pages

  • Re: mail merge if statement
    ... If you just want to add the switch to some of your numbers based on country ... You could even add a country code to your data source and then merge the two ... Word MVP web site http://word.mvps.org ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Saving mail merge template not saving setting in address block
    ... I am positive that the country setting is not marked. ... mark the country for the second label, ... you are therefore unlinking the data source from the document before saving ... you do have to recreate the mappings when you attach a new data ...
    (microsoft.public.word.mailmerge.fields)
  • Design mini-lanugage for data input
    ... For ease of use and flexibility, design a mini-language for your input data. ... Use Python's superb text handling capability to parse and build the data structure from the input text. ... """ parse and return a country list of """ ... Python program statements is likely differ literally from its data source, which might be text pulled from web pages or other place. ...
    (comp.lang.python)
  • Re: Public Ignorance of the Analogue Switch-off Ongoing
    ... The Important thing to get over to people is that all that an analogue ... Until switch off actually happens in each area, ... channels. ... even space for channel 5 analogue in much of the country. ...
    (uk.tech.digital-tv)
  • -[Do^ zui] -- Re: In Samoa, thay ddo^?i lai xe ho*i tu*` le^` Pha?i qua le^` Trai
    ... Trong ba`i na`y co' no'i Samoa is the 1st country in 40 yrs ... In Samoa, Drivers Switch to Left Side of the Road ...
    (soc.culture.vietnamese)