Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ian-ok ian-ok is offline
external usenet poster
 
Posts: 1
Default Excel to Word mailmerge date problems

I'm using a excel spreadsheet to merge data into a word document. However within
my date columns I can also put 'pending' or 'n/a' So whenever a column contains
this the format of the date within the word document is not displayed but is
rather put as a calculation.

So for e.g
28/01/2010 is shown as 40206

How can i get round this, if I remove any of the pending or n/a the format is
ok. But I do need to display a pending or n/a and or the correct date format.

Even with using the following
@/ "dddd d MMMM yyyy"
It still doesn't help as the column contains a none date formatted input.

I've got the data in an excel spreadsheet a word document with text and using
mail merge.

So for instance column Date received has the following data:
28/1/2010
15/2/2010
pending
n/a
18/2/2010
etc

The data in the word doc will be similar to:
{MERGEFIELD "Date_Received" \@" dddd d MMMM yyyy"}

I don't need the whole list of merged documents, from the list I only use one
row of data and then copy and paste that into an email. I'll need another row
when another payment hase been received.

Thanks

Ian
Reply
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
How to show date / currency format in mailmerge from Excel? LoreKai Mailmerge 4 August 14th 09 06:30 AM
date format in mailmerge from excel file to word doc. badhusha Mailmerge 1 July 4th 08 02:38 PM
Word converts English date to USA date in mail-merge from Excel? DaveCujoPI Mailmerge 1 April 20th 07 03:04 PM
Strange behaviour of date fields in Excel-Word mailmerge Bill Bradley Mailmerge 2 September 8th 06 08:05 PM
Word/Excel mailmerge problems havenlad Microsoft Word Help 5 July 12th 06 10:46 AM


All times are GMT +1. The time now is 03:17 PM.

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"