Telephone numbers in mail merge - again

[penret]

Hi:

My initial problem was that after merging a document from Access 2002 to Word, the telephone numbers showed in two formats in the same document. 123-456-7890 and 1234567890.

I tried Alt F9 to add to the field \# “000’-‘000’-‘0000” and also using ## instead of zeros, but nothing changed.

Following directions from an MS help thread I chose ‘edit field’ then ‘field codes’ and entered MERGEFIELD TELEPHONE \# ”000’-‘000’-‘0000” I am now getting all of the numbers in the correct format, which is good, half are correct 123-456-7890, but about half of them are like this -000-000-7890. This is the same in all the merges that have telephone numbers.

Any advice would be appreciated.

Thank you

 

[SkipVought]

Hi,

For these reasons, faq68-6659, I'd convert ALL phone "numbers" to TEXT with DASHES et al.

Absolutely no ambiguity!

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[penret]

Hi Skip:

Thank you for your response.

The telephone numbers are in text, the input mask is
\(000") "000\-0000 I don't understand why some of the numbers are correct and some are not, in the same document.

The numbers show correctly in the table and the query but not in the merged document

Thanks

Fiona

 

[SkipVought]

You do not need a MASK if your "numbers" have been modified in the table to INCLUDE all DASHES and other delimiting characters.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[penret]

I don't really understand what you mean. Should I remove/delete the mask? Where do I put the "numbers" then?

Thanks

 

[SkipVought]

You should not have NUMBERS like 1234567890.

Rather you should have

123-456-7890

in your table as TEXT.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}