Re: Merge fields with phone number format
From: Graham Mayor (gmayor_at_DELETECAPSmvps.org)
Date: 09/02/04
- Next message: Richard: "Re-creating Template from Already-Merged Document"
- Previous message: Denny: "Merge fields with phone number format"
- In reply to: Denny: "Merge fields with phone number format"
- Next in thread: Paul Lautman: "Re: Merge fields with phone number format"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 15:38:53 +0100
You have to provide the formatting required in Word with a switch on the
merge field http://www.gmayor.com/formatting_word_fields.htm
{Mergefield number\# "(000) 000'-'0000"}
should do the trick here
-- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Denny wrote: > I have a user who has a database that tracks information > on vendors. This database has three fields that are phone > numbers using the following format{(555) 555-5555}. This > is how the data is stored in the Access table. The field > is setup as a text file. > > We are trying to do a MailMerge into a document and when > these three fields are merged the formatting is removed > and we only get the straight numbers {5555555555}. > > I have read through some Access and Word books, but > nothing I try has any affect. > > Any suggestions? > > Thanks in advance. > Denny begin 666 Internet Explorer.lnk M3 ````$4`@``````P ```````$:?````( ```&",X93P:L(!\&[SBES&PP$` MR('[6T_"`0!D`0```````0```````````````````!<!% `?4.!/T"#J.FD0 MHM@(`"LP,)T9`"]#.EP`````````````````````````2@`Q``````"3+Z:2 M$0!04D]'4D%^,0``,@`#``0`[[Y#+8AYDR^FDA0```!0`'(`;P!G`'(`80!M M`" `1@!I`&P`90!S````& !2`#$``````$,MMWH0`$E.5$523GXQ```Z``,` M! #OOD,MMWJ3+P>2% ```$D`;@!T`&4`<@!N`&4`= `@`$4`> !P`&P`;P!R M`&4`<@```!@`3 `R``!D`0`=+0!H( !)15A03$]212Y%6$4``# ``P`$`.^^ M0RVW>I,O6)(4````20!%`%@`4 !,`$\`4@!%`"X`10!8`$4````<````80`` M`!P````!````' ```# `````````8 ```!0````#````C6H!Q! ```!(1$0` M0SI<4')O9W)A;2!&:6QE<UQ);G1E<FYE="!%>'!L;W)E<EQ)15A03$]212Y% M6$4``!0`0 !X`' `<P!P`#$`<@!E`',`+@!D`&P`; `L`"T`,0`Q`# `, `R M`#@`+@`N`%P`+@`N`%P`+@`N`%P`+@`N`%P`4 !R`&\`9P!R`&$`;0`@`$8` M:0!L`&4`<P!<`$D`;@!T`&4`<@!N`&4`= `@`$4`> !P`&P`;P!R`&4`<@!< M`$D`10!8`% `3 !/`%(`10`N`$4`6 !%`!4`)0!(`$\`30!%`$0`4@!)`%8` M10`E`"4`2 !/`$T`10!0`$$`5 !(`"4`$ ````4``* F````=P```& ````# M``"@6 ````````!N96-?;&%P=&]P````````.K0VOE3M@D&\O>VUHC+IV@+5 M.'Y0,M@1C+BOZ9%@`BTZM#:^5.V"0;R][;6B,NG:`M4X?E RV!&,N*_ID6 " %+0`````` ` end begin 666 Microsoft Office Word 2003.lnk M3 ````$4`@``````P ```````$;-4 `````````````````````````````` M`````````````````````0```````````````````%$!% `?4.!/T"#J.FD0 MHM@(`"LP,)T9`"]#.EP`````````````````````````2@`Q```````A,46" M$0!04D]'4D%^,0``,@`#``0`[[Y#+8AY(C%R<Q0```!0`'(`;P!G`'(`80!M M`" `1@!I`&P`90!S````& !0`#$``````"LPUET0`$U)0U)/4WXS```X``,` M! #OOI,OO:$B,3AS% ```$T`:0!C`'(`;P!S`&\`9@!T`" `3P!F`&8`:0!C M`&4````8`$ `,0``````%#&].! `3T9&24-%,3$``"@``P`$`.^^DR^]H2(Q M.',4````3P!&`$8`20!#`$4`,0`Q````& !(`#(`R-2W`,HPN:,@`%=)3E=/ M4D0N15A%`"X``P`$`.^^RC"YHR(QZ&44````5P!)`$X`5P!/`%(`1 `N`$4` M6 !%````&@```'0`0P!R`&4`80!T`&4`( !A`&X`9 `@`&4`9 !I`'0`( !T M`&4`> !T`" `80!N`&0`( !G`'(`80!P`&@`:0!C`',`( !I`&X`( !L`&4` M= !T`&4`<@!S`"P`( !R`&4`< !O`'(`= !S`"P`( !7`&4`8@`@`' `80!G M`&4`<P`L`" `;P!R`" `90`M`&T`80!I`&P`( !M`&4`<P!S`&$`9P!E`',` M( !B`'D`( !U`',`:0!N`&<`( !-`&D`8P!R`&\`<P!O`&8`= `@`$\`9@!F M`&D`8P!E`" `5P!O`'(`9 `N`$4`+@`N`%P`+@`N`%P`+@`N`%P`+@`N`%P` M+@`N`%P`+@`N`%P`4 !R`&\`9P!R`&$`;0`@`$8`:0!L`&4`<P!<`$T`:0!C M`'(`;P!S`&\`9@!T`" `3P!F`&8`:0!C`&4`7 !/`$8`1@!)`$,`10`Q`#$` M7 !7`$D`3@!7`$\`4@!$`"X`10!8`$4`2 !#`#H`7 !7`$D`3@!$`$\`5P!3 M`%P`20!N`',`= !A`&P`; !E`'(`7 ![`#D`, `Q`#$`, `T`# `.0`M`#8` M, `P`# `+0`Q`#$`1 `S`"T`. !#`$8`10`M`# `,0`U`# `, `T`#@`,P`X M`#,`0P`Y`'T`7 !W`&\`<@!D`&D`8P!O`&X`+@!E`'@`90`4`P``!@``H"== M9T%6;BU]9BA:6&9E05(V+FII5T]21$9I;&5S/E!@;W,L,4!35SU0-W8V1U!L M75AH`'<@-A$`(#81`" V$0``````&0`O0UL```#8`@`````````````````` M8-.R``````#P+@D`;-.R``````!+1/EW"/JO`<V+]7>H!PD`-Y#U=["9HP$0 M^J\!D-.R``37L@`1'*=P"0@```$``!"(VK(`*0```.!;/G<I````C-RR`!#Z MKP$,T[(`3 ```& "```N````#@```"S3L@""-0$````)`L@``````5-.R M`'"(^G>('/5W_____U#3L@````D`*$3Y=PP```#(" D`)P!=`&<`00!6`&X` M+0!]`&8`* !:`%@`9@!E`$$`4@`V`"X`:@!I`%<`3P!2`$0`1@!I`&P`90!S M`#X`4 !@`&\`<P`L`#$`0 !3`%<`/0!0`#<`=@`V`$<`4 !L`%T`6 !H```` M)G<```D`Q-.R``*L1':@VK(``0```/33L@#TU;(`^-6R`.C4L@#(>@L````` M`-S4L@!:BTIVH-JR``$```#TT[(`]-6R`&V+2G98VK(`(0```!I7KP$85Z\! MA-ZR``#4L@`$````9 ```%L`,0!=````H@````0!``!5`',`90!R`',`7 !3 M`'0`80!R`'0`( !-`&4`;@!U`%P`4 !R`&\`9P!R`&$`;0!S`%P`30!I`&,` M<@!O`',`;P!F`'0`( !/`&8`9@!I`&,`90!<`$T`:0!C`'(`;P!S`&\`9@!T M`" `3P!F`&8`:0!C`&4`( !4`&\`;P!L`',`7 !-`&D`8P!R`&\`<P!O`&8` M= `@`$\`9@!F`&D`8P!E`" `00!C`&,`NN'G=\3AYW<XX;(`X!VR`=0=L@'$ MU+(`&_#G=Q97KP$(UK(`0XI*=AA7KP$`````6-JR`!X````!`````P```/35 ML@#XU;(`XZM$=LAZ"P`````````````````:5Z\!``(``/____]@U;(````` M``````!$U;(`7-6R`!0#```'``"@)5-Y<W1E;5)O;W0E7$EN<W1A;&QE<EQ[ M.3 Q,3 T,#DM-C P,"TQ,40S+3A#1D4M,#$U,# T.#,X,T,Y?5QW;W)D:6-O M;BYE>&4`````````````_____P````````````````````"0:Z !```````` M`````````````/ N"0"6F_5WGYOU=T3;L@`D``(`P!*R`5X````"````) `" M``#P_7\`V+(`D ```+S8L@!PB/IWY9OU=^!)_'</H_5W%Z/U=P`````(`@`` M<,&Z`<S9L@```````````) ```"@W+(``````&@+"0`WD/5W,!03`, 3$P`` M````5 ```&S90T,E`%,`>0!S`'0`90!M`%(`;P!O`'0`)0!<`$D`;@!S`'0` M80!L`&P`90!R`%P`>P`Y`# `,0`Q`# `- `P`#D`+0`V`# `, `P`"T`,0`Q M`$0`,P`M`#@`0P!&`$4`+0`P`#$`-0`P`# `- `X`#,`. `S`$,`.0!]`%P` M=P!O`'(`9 !I`&,`;P!N`"X`90!X`&4``````````````````@````@`"@`( M$?5WD ```'#!N@`"````P!,3`&C;L@%#`#H`7 !$`&\`8P!U`&T`90!N`'0` M<P`@`&$`;@!D`" `4P!E`'0`= !I`&X`9P!S`%P`00!L`&P`( !5`',`90!R M``(````T]4%V@&N@`8!KH %-`&4`;@!U`%P`4 !R`&\`9P!R`&$`;0#<V;(` M```)`"A$^7<%````> <)````"0"HQ0H`M-FR`&,`90#\V[(`<(CZ=W X]7?_ M____$-JR````"0`H1/EW"@```&@("0````D`@/BO`>C9L@``````,-RR`'"( M^G=P./5W_____RA$^7=P??5W.HKU=P````#HXJX!Z.*N`0``"0`H1/EW$0`` M`+@)"0````D`Z.*N`3#:L@!@V0X`>-RR`'"(^G=P./5W_____RA$^7=P??5W H.HKU=P````!@V0X`?-<;=W3>L@!\UQMW```````````````````````` ` end
- Next message: Richard: "Re-creating Template from Already-Merged Document"
- Previous message: Denny: "Merge fields with phone number format"
- In reply to: Denny: "Merge fields with phone number format"
- Next in thread: Paul Lautman: "Re: Merge fields with phone number format"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
