Running Word Mail Merge from Access procedure. How do I format date fields
in Word mail merge?  The merge fields come from an access db via ODBC
connection.

Thanks Gregg

You could use an Access query as the data source, and the query can
include a calculated column like:
FormattedDate: Format(DateField, "mmm-d-yyyy")

 -- Andy

In Word you would display field codes (Alt+F9) and then use formatting

In Microsoft Word Help follow this path for more info,
1. Help Topics -> Index
Search for: "MERGEFIELD field"
2. Click the link at the bottom [>>]

HTH, John.

Two viable solutions...Thank you both.  I may use the field code formatting
solution but I would like to implement it in Access in automation code.  Has
anyone done field formatting in VBA automation code?  I'm assuming that each
field would need to be bookmarked so that I know which field to go to insert
formatting ?

Thanks Gregg