View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default Sending email via VB - address length

Carl

I don't have OL98, but in OL2000, it worked fine with 300 characters. Post
how you are using the FollowHyperlink method and I'll see if I can reproduce
it.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Carl Woodall" wrote in message
...
Hi

I'm trying to send e-mails from Excel 97 via VB but am
having problems as the address text is truncated at 260
characters. The code I'm using is:

ActiveWorkbook.FollowHyperlink address:=addresses
whe addersses is defined as a variant type.

Does anybody know of a work around or is this just a limit
of the function? The mail client is Outlook 98.

Cheers
Carl Woodall