Mail Merge Prob

J

johnnybhoy

Hi Folks,

I'm using a mail merge form an access database using a simple query to bring
in table data (Medium Time in AM PM format) into a word document. All works
well but I've set up the database for Medium times AM PM format but when the
time is merged with word it shows the time as 24HR Long time e.g. "15:00:00"
instead of the desired "3:30 PM"

There is no VB code behind the document and there is no formatting code in
the databse other than the table design preset.

Any Suggestions??

Cheers

John
 

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

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Mail Merge file containing a Word Table 0
Auto Merge text from multiple sources 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Mail Merge skipping records/sending one at a time 0
Printing Mail Merge Slow 0
Duplicate Mail Merge Record Every Time 5

Top