Word says date is invalid in the filter value in mail merge

G

Grey Guru

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
 
P

Peter Jamieson

As far as I know, in Word 2007 using the default OLE DB connection
method, you can specify the date in US MM/DD/YYYY format or YYYY-MM-DD
format. However, it would not surprise me if this did not always work...

Peter Jamieson

http://tips.pjmsn.me.uk
 

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

Mail Merge Directory Conditional Page Break 0
Mail Merge skipping records/sending one at a time 0
VBA - exporting serial letters to single documents 0
Date Formats 4
Grouping Names in Mail Merge 0
Autofill Date in Word 15.33 for Mac 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1

Top