I'm working on a solution that will allow the user to (somehow) click text in
an email and automatically open a report and paste data into the report (from
the email). I'm wondering if there's an elegant way to do this in Outlook.


Here's what I'm using: MS Access, Outlook 2003, Crystal Reports 8.5,
Winbatch, DOS batch file.

Here's how it works (right now): I automatically send an email
notification via Access (text format) to a recipient with the following text
(batch and order number):

\\SERVER\Runit.bat

[order number]

When the user selects the URL to run the batch file, it invokes a winbatch
script which, essentially, sends keystrokes in the Windows environment to
copy the [order number] in the email, open Crystal Report, re-generate report
and paste [order number]. Not elegant and doesn't always work.

The real issue that I'm having is copying the [order number] ... when I
invoke the batch file the active window changes. If I could copy the order
number from the email to the clipboard when I select the URL (for example),
that would eliminate a lot of issues.

Does anyone have any suggestions for a better solution?

Thanks for your help!

Gary