S
Supynuts
Let me startby saying I am relatively new working with VBA in excel and
access and want to ask if there is a good resource/book to get a really good
understanding
of the fundamentals. I often find myself in situations where something is not
as fully explained as I would like and it results in error in the code that I
don't understand.
I have been tossing this back and forth with Daniel and John in this forum
but feel I should elaborate as much as possible as the deadline is
approaching. Here is the task I have been given. When a new recruit is
hired at our firm, we enter them into a process that unfolds over the course
of their first year. This process has development steps throughout it that
take place on their 1 month, 2 month, 6 month, and year anniversary. Being
that the development steps are different and so are the people that will be
coordinating them, I would like to be able to automate the process of
sending out emails to those people that are involved in the step taking place
at that time. THis would mean that I would need a function to look at the
current date and subtract that from the day the recruit was hired to get a
day count. Then once a specific day count is reached (say 30) this triggers
a stored email, with static body (although would be nice to be able to look
to recruits first name and include in parts of the email), static subject,
and CC, yet a different To field...the recruits email. This is how the
process would unfold throughout the year...day 60 hits and same thing. Is
this possible and probable for
a beginner to accomplish? Please let me know if any of this is unclear. I
already have most of my form built, but am really snagged on this operation
Thank you already for your quick replies and insights.
access and want to ask if there is a good resource/book to get a really good
understanding
of the fundamentals. I often find myself in situations where something is not
as fully explained as I would like and it results in error in the code that I
don't understand.
I have been tossing this back and forth with Daniel and John in this forum
but feel I should elaborate as much as possible as the deadline is
approaching. Here is the task I have been given. When a new recruit is
hired at our firm, we enter them into a process that unfolds over the course
of their first year. This process has development steps throughout it that
take place on their 1 month, 2 month, 6 month, and year anniversary. Being
that the development steps are different and so are the people that will be
coordinating them, I would like to be able to automate the process of
sending out emails to those people that are involved in the step taking place
at that time. THis would mean that I would need a function to look at the
current date and subtract that from the day the recruit was hired to get a
day count. Then once a specific day count is reached (say 30) this triggers
a stored email, with static body (although would be nice to be able to look
to recruits first name and include in parts of the email), static subject,
and CC, yet a different To field...the recruits email. This is how the
process would unfold throughout the year...day 60 hits and same thing. Is
this possible and probable for
a beginner to accomplish? Please let me know if any of this is unclear. I
already have most of my form built, but am really snagged on this operation
Thank you already for your quick replies and insights.