G
G
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
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