Message Box Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I send out surveys about three months after a client is finished with our
business. I would like to enter the date that they finish and set up a macro
to have a message box pop up three months later to remind me to send the
survey. Is this possible to do and if so, how do I set this up? Thanks
 
Hi Kelly
I don't think you want a message box.Probaly more practical would be a query
or report showing you all the clients with the last visit date greater than
90 days, that you have not send a survey to. To get that you'd need to add a
field to your client table like "SurvaySent" yes/no DataType and then buid a
query. You can add all clien info to this query, run it once a week, export
to Excel and use for a mailMerge with Word to get your labels.

sorry, just my 2 cents
Barb
 
Back
Top