Export field value with mask

  • Thread starter Thread starter Richard
  • Start date Start date
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
 
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,
 
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


.
 
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


.
 
Back
Top