auto click hyperlink?!

  • Thread starter malemodel_75
  • Start date Views 1,465
M

malemodel_75

#1
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

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
#2
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

Am Sat, 06 Feb 2010 18:10:47 GMT schrieb 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
 

Similar threads

Top