View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl Woodall Carl Woodall is offline
external usenet poster
 
Posts: 2
Default Sending email via VB - address length

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