OK, Here's what I'm trying to do:
Run a Crystal Report, which queries an Oracle Server, and returns a list of projects that are falling behind, along with the name of the project manager corresponding to each. I then want to generate an email from each which will basically say "Dear So & So, your project blank is falling behind."
I've spent two days straight trying to find a way to do this automatically, and have found none, which blows me away since I think it's a really obvious thing to want to do.
However, having found none, I'm now going to try to write some VBA to at least partially automate the process. Here's what I'm looking at doing:
-Manually export the report from Crystal to Excel (can this be automated?)
-Have VBA macro go through the Excel version and for each project, send an email through Outlook to that person, with the message mentioned above.
I don't have any specific code questions right now, because I think I can do this fairly easily. What I would like to know though is, what are your oppinions on this approach? Is there an easier way to do this? And to anyone with Crystal Reports experience, is there in fact some way to do this just with Crystal, eliminating the need to screw around in VBA?
Thanks for reading this rather long post.