Canadian Postal Codes carried from Access into Word via Mail Merge

M

Matthew

Hello,

My postal codes are coming into my Word97 document from
Access97 as A9A9A9, for example, and I want them to come
through with the hyphen as such, A9A-9A9, which is
standard. What changes to the mail merge field would I
have to make to add the simple hyphen?

Thank you.

-Matthew
 
P

Peter Jamieson

I don't think you'll be able to do this just using fields because no text
manipulation functions are available within fields.

Your best bets are probably
a. format the field differently in Access so that it has the space in it
(at the moment the Access field data almost certainly does not have a space,
but the display/data entry masks probably have a space so it always appears
/in Access/ with a space
b. create an Access query that retrieves the data you need and uses a
formula to construct the postal code with the spece in it - e.g. something
like

left(postalcode,3) & ' ' & mid(postalcode,4) AS postalcode

and use that as the data source for your merge. Since option (a) could have
massess of knock-on effects on your Access database, (b) is generally a
safer bet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top