hyperlinks & email - Excel 2000

[john]

Hi, I'm trying to fill out an email automatically, but can't get past the
'To: " part. Clicking an email hyperlink opens Outlook Express & a
compose mail with the "To:" section filled out, but I can't add anything
else to the
email, like subject and text body.

I've read about another technique to open and fill out an email
(Application.Followhyperlink?) but that would then open up two emails - the
one that is opened automatically by clicking the hyperlink and the one from
this expression. So I either need to learn how to suppress the
'autohyperlink' feature and use Application.Followhyperlink, or figure out
how to add stuff to an email that's been opened automatically.

Any help would be appreciated.

thanks,
john

[Ron de Bruin]

Hi

Use a macro John
http://www.rondebruin.nl/sendmail.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"john" <john@nospam.netcom.com> wrote in message news:vdydndP90OJP2I_fRVn-pw@rogers.com...
> Hi, I'm trying to fill out an email automatically, but can't get past the
> 'To: " part. Clicking an email hyperlink opens Outlook Express & a
> compose mail with the "To:" section filled out, but I can't add anything
> else to the
> email, like subject and text body.
>
> I've read about another technique to open and fill out an email
> (Application.Followhyperlink?) but that would then open up two emails - the
> one that is opened automatically by clicking the hyperlink and the one from
> this expression. So I either need to learn how to suppress the
> 'autohyperlink' feature and use Application.Followhyperlink, or figure out
> how to add stuff to an email that's been opened automatically.
>
> Any help would be appreciated.
>
> thanks,
> john
>
>
>
>
>
>

[john]

Thanks Ron, I'll check those out.

john

"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
news:uO8$CD5EFHA.2676@TK2MSFTNGP12.phx.gbl...
> Hi
>
> Use a macro John
> http://www.rondebruin.nl/sendmail.htm
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "john" <john@nospam.netcom.com> wrote in message
news:vdydndP90OJP2I_fRVn-pw@rogers.com...
> > Hi, I'm trying to fill out an email automatically, but can't get past
the
> > 'To: " part. Clicking an email hyperlink opens Outlook Express & a
> > compose mail with the "To:" section filled out, but I can't add
anything
> > else to the
> > email, like subject and text body.
> >
> > I've read about another technique to open and fill out an email
> > (Application.Followhyperlink?) but that would then open up two emails -
the
> > one that is opened automatically by clicking the hyperlink and the one
from
> > this expression. So I either need to learn how to suppress the
> > 'autohyperlink' feature and use Application.Followhyperlink, or figure
out
> > how to add stuff to an email that's been opened automatically.
> >
> > Any help would be appreciated.
> >
> > thanks,
> > john
> >
> >
> >
> >
> >
> >
>
>