| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to filter on a date field during mail merge
I'm trying to mail merge a Word 97 doc with Excel 97 spreadsheet that
contains a column formatted as a date. I'd like to filter the mail merge (query definition) such that only records with a date that is within 45 days of "today" get included in the merge. I've set the query filter to "Expiration_Date" "Less than or equal to""=TODAY()+45" but I don't get any records eventhough there most definitely are pertinent records in the source. I can't find much help on appropriate syntax for the filter specification and suspect I've got it wrong. Can anybody help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| F7 in zip field when doing mail merge from excell file | Excel Discussion (Misc queries) | |||
| Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Threaded Mode
