mail merge access table formatted numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello! I have an access table where the primary key is an auto-number field
(increments). I've formatted the field so that the the number is preceeded
with a 2006-112, so for example, entry number 1 would appear as 2006-112-1.

How does one mail merge with MS Word so as to not drop the preceeding
numbers? I hope to have the number 2006-112-1 instead of the number 1
appearing in my mail merged document.
 
Dallas said:
Hello! I have an access table where the primary key is an auto-number field
(increments). I've formatted the field so that the the number is preceeded
with a 2006-112, so for example, entry number 1 would appear as 2006-112-1.

How does one mail merge with MS Word so as to not drop the preceeding
numbers? I hope to have the number 2006-112-1 instead of the number 1
appearing in my mail merged document.
Click to expand...

If the prefix information is always the same.. just put(2006-112) in
the word document and parse the autonumber as the merge field right up
against the text ie

2006-112 [autonumber field]

Hope this helps

Tony
 
You can create a Query to be used as the DataSource for the MailMerge. In
the Query you can create a Calculated Field/Column the way you want like:

MyFormatedPK: "2006-112" & [YourPKField]

OTOH, if 2006 indicates the year (and I am not sure what the "112" means -
month / day?), then you should consider some other expression that
automatically calculate the prefix "2006-112" from the relevant date value
(today's date???).
 
Back
Top