Re: Merge fields with phone number format
From: Paul Lautman (paul.lautman_at_btinternet.com)
Date: 09/02/04
- Next message: Tony_VBACoder: "Re: Word Mail Merge asking to save when no changes are made"
- Previous message: Sandy: "Sending an attachment when mail merging to email"
- In reply to: Denny: "Merge fields with phone number format"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 17:57:40 +0000 (UTC)
Your field (Alt-F9) neeeds to look like:
{MERGEFIELD phone \# "(###) ##'-'####"}
"Denny" <anonymous@discussions.microsoft.com> wrote in message
news:4d9701c490ee$5a73a100$a301280a@phx.gbl...
> 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
- Next message: Tony_VBACoder: "Re: Word Mail Merge asking to save when no changes are made"
- Previous message: Sandy: "Sending an attachment when mail merging to email"
- In reply to: Denny: "Merge fields with phone number format"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
