auto click hyperlink?!

[malemodel_75]

Hi,

I am a very basic user new to macros and vba. My problem is that I recive
online orders to which i need to click an auto generated unique order
hyperlink to confirm receipt of the order within a specified time period.
This is a mundane task having to be on 'standby' and was wondering if there
was a way to have this link automatically clicked when the email arrives.
Just to reiterate the link has a unique reference and is different on each
email.

Please bare in mind that I am a very basic user and would probably require
step by step instructions.

Many thanks in advance

 

[Michael Bauer [MVP - Outlook]]

First thing you need to do is to find and extract the link. You might use
the ItemAdd event of the Inbox, whcih fires when an item is added to the
folder. See the VBA help for details.

If the event is fired, you might want to check the Item's Subject, or
SenderEmailAddress or whatever to see whether it's a message you want to
handle. If so, use the functions Instr, Mid, Left, and/or Right to get the
link out of the Body property.

The hyperlink probably looks like this:
<a ...>text</a>

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sat, 06 Feb 2010 18:10:47 GMT schrieb malemodel_75: