View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Using dates during mail merge

You need to consider whether mail merge is really the right tool for this
job.

Maybe something more along the lines of the method contained in the last of
the following series of articles is more appropriate

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"gjupp via OfficeKB.com" u41094@uwe wrote in message
news:7f44f2a2e9eb1@uwe...
Thanks for the reply.

For the data source we are using a standard word doc generated by mail
merge,
using standard fields for names, address, etc, and we assumed that dates
would be retained in separate fields in each record.

For the moment, until the 'system' is set up, we are entering the current
date manually in date fields for relevant records, then using skip-if (not
equal to this date) to merge only those records. This retains the date but
is
crude indeed, as the skip-if date criterion has to be changed for each
merge.
There must be a better way. Hope you can help to streamline the process.
Thanks.




Doug Robbins - Word MVP wrote:
What are you using for the data source? Frankly, it does not sound to me
like mail merge is really the best option for this. How are you proposing
to retain each date in the data source? In a new record? In separate
fields in each record, or multiple dates in one field?

These sort of things need to be considered in the first instance.

Can anybody help please?

[quoted text clipped - 18 lines]

Many thanks in anticipation.


--
Message posted via http://www.officekb.com