Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2007

Tip: Looking for answers? Try searching our database.

date driven mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandy C. - 20 Mar 2007 15:47 GMT
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 - 20 Mar 2007 15:56 GMT
Where are you getting the date information from and what do you want to do
at a certain date?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> 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. - 20 Mar 2007 16:09 GMT
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.

> Where are you getting the date information from and what do you want to do
> at a certain date?
>
> > 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 - 20 Mar 2007 16:53 GMT
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.

> 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
[quoted text clipped - 8 lines]
> > > document. I would like to be able to merge the info based on a date.
> > > Is that possible.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.