When a mail merge is run from access to word to create for example mailing
Letters. How do I get this to happen.

A field access gets populated automatically with the date the mail merge
Was last run.

So when a mailmerge is run from access to send out some letters a field gets
Populated with the date that letters have been sent with additional info if
needed?

I am totally lost on this, please help as much as you can.

Thanks guys.

James

Not sure what this has to do with security, but I assume you have a query
that is used to do the mail merge.

Once it's complete, you would run an update query (based on your merge
query), that updates your LetterSent field with Date() (or Now() if you
also want the time it was done).


--
Joan Wild
Microsoft Access MVP

James123 wrote:
> When a mail merge is run from access to word to create for example
> mailing Letters. How do I get this to happen.
>
> A field access gets populated automatically with the date the mail
> merge Was last run.
>
> So when a mailmerge is run from access to send out some letters a
> field gets Populated with the date that letters have been sent with
> additional info if needed?
>
> I am totally lost on this, please help as much as you can.
>
> Thanks guys.
>
> James

Sorry must have posted in the wrong group,



"Joan Wild" wrote:

> Not sure what this has to do with security, but I assume you have a query
> that is used to do the mail merge.
>
> Once it's complete, you would run an update query (based on your merge
> query), that updates your LetterSent field with Date() (or Now() if you
> also want the time it was done).
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> James123 wrote:
> > When a mail merge is run from access to word to create for example
> > mailing Letters. How do I get this to happen.
> >
> > A field access gets populated automatically with the date the mail
> > merge Was last run.
> >
> > So when a mailmerge is run from access to send out some letters a
> > field gets Populated with the date that letters have been sent with
> > additional info if needed?
> >
> > I am totally lost on this, please help as much as you can.
> >
> > Thanks guys.
> >
> > James
>
>
>