Referencing Macros

[Dunner]

Hi All,

Basically my problem is this - I have created a mail
merge document from an access database and want to date
stamp the records each time they are printed from the
mail merge (i.e. some printed one day and stamped with
that date, others on another day).

The only way I can think of doing this is to create a
macro in Access to stamp a field with the current date
but how do I reference this from word and can I stamp
specific records or will I need to stamp them all?

Cheers

Dunner

 

[Dave Lett]

Hi Dunner,

Why not create a template, put the {Date} field with the appropriate
switches to format the date/time as you want it to appear.
Then, when you create a new document for your mailmerge, use the template.

Dim oDoc As Document
Set oDoc = Documents.Add(Template:="C:\Mailmerge.dot")
odoc.MailMerge...

HTH,
Dave

 

[Dunner]

Hi Dave,

I'm using a template for the mail merge but the problem
is the records in Access. Each record could be chased 4
or 5 times before the relevant information is received.
What I want to do is have an automatic "last date chased"
field updated each time a record is chased through a mail
merge/e-mail so that a user can tell when a record was
last chased and then chase records older than a certain
length of time.

What I'm thinking now is a macro in the Access database
that updates the field, calls the mail merge and prints
the relevant records (the problem with that though is
that only one person will be able to edit the database at
a time). Do you think this is possible without delving
into the murky waters of SQL?

Cheers for all your help

Dunner