Export field value with mask

R

Richard

I want to do a mail merge to email from Word. In my access
data file I have created a mask for the fax field "[fax:1-
"&&&&&&&&&&&&\] which converts a fax number e.g. 415-555-
1212 to the format needed by Outlook to pass it to our
faxination server e.g. [fax:1-415-555-1212]. But when I
try to mail merge to email from Excel, Word just pulls the
415-555-1212, and NOT the mask info. I have also tried
exporting to Excel, same problem.
Should I be writing an Update Query instead of using a
mask?
All help appreciated!!
Tks, Richard
 
C

Cheryl Fischer

Richard, I believe your best bet is to merge using a query instead of
directly from your table, as Word does not always pick up mask information
or other nice formatting. Put all of the fields you need for your merge
into a query, except for your Fax field. Instead of the Fax field, insert a
calculated field, as follows:

FaxNum: "[fax:1-" & Fax & "]"

hth,
 
G

Guest

Thanks Cheryl. That worked perfectly!! Richard
-----Original Message-----
Richard, I believe your best bet is to merge using a query instead of
directly from your table, as Word does not always pick up mask information
or other nice formatting. Put all of the fields you need for your merge
into a query, except for your Fax field. Instead of the Fax field, insert a
calculated field, as follows:

FaxNum: "[fax:1-" & Fax & "]"

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I want to do a mail merge to email from Word. In my access
data file I have created a mask for the fax field "[fax:1-
"&&&&&&&&&&&&\] which converts a fax number e.g. 415- 555-
1212 to the format needed by Outlook to pass it to our
faxination server e.g. [fax:1-415-555-1212]. But when I
try to mail merge to email from Excel, Word just pulls the
415-555-1212, and NOT the mask info. I have also tried
exporting to Excel, same problem.
Should I be writing an Update Query instead of using a
mask?
All help appreciated!!
Tks, Richard
Click to expand...


.
Click to expand...
 
C

Cheryl Fischer

You're welcome!

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Thanks Cheryl. That worked perfectly!! Richard
-----Original Message-----
Richard, I believe your best bet is to merge using a query instead of
directly from your table, as Word does not always pick up mask information
or other nice formatting. Put all of the fields you need for your merge
into a query, except for your Fax field. Instead of the Fax field, insert a
calculated field, as follows:

FaxNum: "[fax:1-" & Fax & "]"

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I want to do a mail merge to email from Word. In my access
data file I have created a mask for the fax field "[fax:1-
"&&&&&&&&&&&&\] which converts a fax number e.g. 415- 555-
1212 to the format needed by Outlook to pass it to our
faxination server e.g. [fax:1-415-555-1212]. But when I
try to mail merge to email from Excel, Word just pulls the
415-555-1212, and NOT the mask info. I have also tried
exporting to Excel, same problem.
Should I be writing an Update Query instead of using a
mask?
All help appreciated!!
Tks, Richard
Click to expand...


.
Click to expand...
Click to expand...
 
Top