Save to file

  • Thread starter Thread starter Lodewijk
  • Start date Start date
L

Lodewijk

I have a database with adressess. I use this to send changes to the sender
of our newsletter.

All records have three indications:
1) YNSend: If this is True, the record has not been send to the sender of
the newsletter;
2) YNMoved: If this is True, there is a new adressess which has not been
send to the sender of the newsletter;
3) YNDied: If this is True, than the member has died and that fact has not
been send to the sender of the newsletter.

With a macro, I want to make three files on disc; one with all the adressess
where YNSend is True, one with all the new and old adressess where YNMoved
is true and one with all the names with YNDied is true. After that, I want
to make all the YN-fields False.
How can I do this?

At this moment I have a macro that prints the records out and then perform a
query to update the YN-fields. But I do not want the reports to be printed
out, but saved.
 
You can right-click a query and 'export' to several file types, including
Access and Excel.
 
Back
Top