Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Grey Guru Grey Guru is offline
external usenet poster
 
Posts: 2
Default Word says date is invalid in the filter value in mail merge

I am set up to enter dates as 11-Feb-09 in regional preferences. I enter
dates in Excel as dates, formatted as dd-MMM-yy. I want to do a mail merge
where I select only rows where Send Status letter is equal to a given date in
the filter. When I try to enter the filter date in the dialog, I get date is
invalid.

What is the correct way (format) to enter a date in this field?

Word 2007, Excel 2007.

Thanks
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
Word says date is invalid in the filter value in mail merge Grey Guru Mailmerge 1 February 11th 09 09:01 PM
Filter merge data by Date John Mailmerge 2 August 29th 07 01:04 PM
Filter Merge Data by Date Range Stuart Troy Mailmerge 2 June 16th 07 12:50 PM
word 2003 mail merge filter problems sian Mailmerge 5 August 24th 05 05:33 PM
How do I filter a Dbase date field in a word mail merge documnet? SMATKINS Mailmerge 0 January 27th 05 05:09 PM


All times are GMT +1. The time now is 07:08 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"