Re: Using dates during mail merge



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

.



Relevant Pages

  • Re: Using dates during mail merge
    ... For the data source we are using a standard word doc generated by mail ... would be retained in separate fields in each record. ... date manually in date fields for relevant records, then using skip-if (not ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Automatic Data Entry
    ... That query will give you the result you were looking for. ... you will see Access display the additional ... You can use this query as the data source for a ... that person, in separate fields. ...
    (microsoft.public.access.gettingstarted)
  • Re: Data into an Excel Form
    ... Depending on what this is for, but if it is for print then I'd make the form in Word and merge using the Excel list as data source. ... the other Employee Name (no need for separate fields for First & Last). ... Is there some sort of merge feature I ...
    (microsoft.public.excel)