LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 169
Default Mail Merge Problem

In article , ?B?RkxZTk5F?= wrote:
Mail Merge problem
The Excel data file contains two columns labelled as Day and Date
respectively.

The Date column contains sequential dates in the format " 26th September
2008".
The main word document contains the <<Day and <<Date mergefields.

However when the word document is merged with data file the date is
displayed as 26/09/2008 and not as 26th September 2008.

The day is displayed correctly.

How do I rectify this problem ?


Sounds like you need to link to the XL data using DDE and not one of the
other methods available. That solved a heap of format problems I had. :)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge date problem Hilly New Users to Excel 2 July 11th 08 02:21 PM
date problem with mail merge Hilly Excel Discussion (Misc queries) 1 July 11th 08 08:44 AM
2003 mail merge problem pjm Excel Discussion (Misc queries) 0 July 12th 06 10:49 AM
Mail merge-problem vishu Excel Discussion (Misc queries) 3 April 18th 05 08:30 PM
Serious Mail Merge Problem FNORD Excel Discussion (Misc queries) 0 February 8th 05 05:13 PM


All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"