Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
klam
 
Posts: n/a
Default Query Option to recognize date

Hi all,

I have an Excel spreadsheet where one column, "Outcome" is set as Date
format (dd-mmm). This column contains different dates or text. I only want
the rows with dates in this column to be in the mail merge.

Under Mail Merge Helper I choose Query Options but don't know to get it to
recognize just the ones with dates. Separately, I have tried things like:
Outcome equal to "**-***", **-***, **"-"***, {dd-mmm}, dd-mmm but no mail
merge happens as "no data records matched".

Anyone know what the "compare to" should be for this Query Option?

(Using Word 2000 on XP) Thx for any suggestions.

cheers,
karen
 
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
MS Word document date query. CReubens Microsoft Word Help 7 March 2nd 06 06:11 PM
Autotext date is not correct when used in Word Shooter Microsoft Word Help 0 December 25th 05 05:46 AM
how do i set a reacuring date on a document? welker_daniel New Users 4 October 29th 05 08:38 AM
Setting default headers and fonts in a template officequestions Microsoft Word Help 5 August 31st 05 01:54 PM
Mail Merge with Access Query Date Field AliH Mailmerge 2 August 15th 05 01:50 PM


All times are GMT +1. The time now is 05:21 AM.

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"