I
ifoundgoldbug
Greetings again
I have been setting up am Preventative maintence program at my place of
work and i have completed it now. BUT now that it is completed my Boss
would like to have all the PM's for the week automatically E-mailed to
him. the thing is we use lotus notes 7. i have seen this type of thing
done with outlook but i have never worked with noted and VBA.
The Fields and Tables I and tables I am working with are:
Table: Work Order
Fields: Tool #, PMDate, Scheduler, and PMScheduled
i will try to give as many specifics as i can. in pseudo code i think
it looks something like this.
IF PM report has been sent this week Then
Exit sub
Else
Run PmThisWeek Query
take data from query and get it into an e-mail and have it send
to the boss
mark some field to denote PM report has been sent this week
End If
I have been setting up am Preventative maintence program at my place of
work and i have completed it now. BUT now that it is completed my Boss
would like to have all the PM's for the week automatically E-mailed to
him. the thing is we use lotus notes 7. i have seen this type of thing
done with outlook but i have never worked with noted and VBA.
The Fields and Tables I and tables I am working with are:
Table: Work Order
Fields: Tool #, PMDate, Scheduler, and PMScheduled
i will try to give as many specifics as i can. in pseudo code i think
it looks something like this.
IF PM report has been sent this week Then
Exit sub
Else
Run PmThisWeek Query
take data from query and get it into an e-mail and have it send
to the boss
mark some field to denote PM report has been sent this week
End If