Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Paul - NottsUK
 
Posts: n/a
Default Another mailmerge from Excel question

{I'm merging HR data from an Excel spreadsheet into word letters. I've got a
number of date fields that I am merging. Consider you'll always have a start
date for someone and you probably have their first pay rise but you may have
a second, it is less likely you'll have a third one and so on.

I've got the mergefields in a table and am using something like

{MERGEFIELD "fieldnameX" \@ "dd-mmm-yy"}

The dates appear as they should do on the first line of the word table but
on all subsequent lines they revert to number of days since 1/1/1900 ignoring
the formatting.

Does anyone have any ideas what is happening.
--
Paul
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
zipcode problem with mailmerge using excel. pamsf Mailmerge 1 May 10th 05 04:46 PM
Mailmerge on word using excel data RJP Mailmerge 4 April 11th 05 08:29 AM
enter an excel module global variable value in a mailmerge letter windowed Mailmerge 1 March 22nd 05 09:31 PM
mailmerge - excel datasource - other file extension? Ralf Pickel Mailmerge 1 February 14th 05 08:05 PM
Mailmerge from EXCEL, custom format problem TonyB Mailmerge 1 December 1st 04 04:41 PM


All times are GMT +1. The time now is 09:03 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"