[Sandy C.]

I have a database that I use to mail merge the info into another document. I
would like to be able to merge the info based on a date. Is that possible.

[Graham Mayor]

Where are you getting the date information from and what do you want to do
at a certain date?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sandy C. wrote:
I have a database that I use to mail merge the info into another
document. I would like to be able to merge the info based on a date.
Is that possible.

[Sandy C.[_2_]]

I have a database that has a column with date info in it. I merge this info
into a report and would like the capability of having the report generated by
a start date and end date. My goal is to try and recreate the report for a
date without having to go through the database and unselect info after a
certain date.

"Graham Mayor" wrote:

Where are you getting the date information from and what do you want to do
at a certain date?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sandy C. wrote:
I have a database that I use to mail merge the info into another
document. I would like to be able to merge the info based on a date.
Is that possible.

[oli merge]

Hi Sandy,

Not certain exactly what you mean but to select records based on the date
column you have several options.

I would just filter the excel spreadsheet using auto or advanced filter
depending on how complex a selection criteria you have and merge from that.

You could also use an IF statement in word to select based on a criteria,
probably nested with the "next record" statement, but its seems a bit
unneccesarily complicated to me.

"Sandy C." wrote:

I have a database that has a column with date info in it. I merge this info
into a report and would like the capability of having the report generated by
a start date and end date. My goal is to try and recreate the report for a
date without having to go through the database and unselect info after a
certain date.

"Graham Mayor" wrote:

Where are you getting the date information from and what do you want to do
at a certain date?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Sandy C. wrote:
I have a database that I use to mail merge the info into another
document. I would like to be able to merge the info based on a date.
Is that possible.