Query to Mail Merge issue

[BillA]

I am running Access2003 on WinXP SP2.
I send out dues letters for members of a retiree group. When I try to do a
mail merge to my Dues Query all goes fine except the telephone number in the
query which is (555)555-1234 comes out 5555551234. If I copy the query into
an excel spreadsheet and use that as the datasource for the mail merge it
works fine.

Is there something I need to do to format the query so it merges with the
right format.
Thanks
Billa

 

[Ken Sheridan]

In the query format the field to include the parentheses and dash. In query
design view, instead of the field name put an expression along the following
lines in the field row of the design grid:

TelNoFormatted:Format([TelNo],"(000)000-0000")

Where TelNo is the field name. The query will return a column named
TelNoFormatted, so you'll need to refer to that rather than the field name
when merging.

BTW you might like to take a look at the following link from which you can
get a demo of various Access to Word automation operations, showing how to
mail merge, fill word tables. insert values at bookmarks etc., all from
within Access:


http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


Ken Sheridan
Stafford, England

 

[BillA]

Thanks Ken, I'll give it a try.

Bill Alsdorf
Brighton, Colorado

In the query format the field to include the parentheses and dash. In query
design view, instead of the field name put an expression along the following
lines in the field row of the design grid:

TelNoFormatted:Format([TelNo],"(000)000-0000")

Where TelNo is the field name. The query will return a column named
TelNoFormatted, so you'll need to refer to that rather than the field name
when merging.

BTW you might like to take a look at the following link from which you can
get a demo of various Access to Word automation operations, showing how to
mail merge, fill word tables. insert values at bookmarks etc., all from
within Access:


http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


Ken Sheridan
Stafford, England

I am running Access2003 on WinXP SP2.
I send out dues letters for members of a retiree group. When I try to do a
mail merge to my Dues Query all goes fine except the telephone number in the
query which is (555)555-1234 comes out 5555551234. If I copy the query into
an excel spreadsheet and use that as the datasource for the mail merge it
works fine.

Is there something I need to do to format the query so it merges with the
right format.
Thanks
Billa