Auto E-Mail if Orders over certain age...

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

Hi all,

I am not a programmer, but dabble with VBA, mainly in Excell, so please bare
with me.
I have a database that gives me the ages of Purchase orders in months, i
load a new excel sheet up every month. What i am wanting is if the orders are
for example 6 1/2 months old, the responsible buyers should be sent an email
with an excel spreadsheet with his orders on. I have got the emailing of the
spreadsheet part, but need the auto sending on loadind the spreadsheet part.

I believe i need to make a table so that it only gets done once in that
month. I am not sure how to do that. I Would really appreciate some help to
walk me through the process.
 
Without knowing more about your application, I can't give an exact answer,
but it does seem to me that the thing to do would be to expand the routine
where you do the monthly import of the spreadsheet. In that procedure, you
could use a query to produce a recordset of orders by buyer and loop through
that recordset emailing them. That would, I assume, have to include using a
parameterized query to produce the spreadsheet to email to them.
 
Back
Top