Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
followhyperlink failure
Some of the lines of code that I am using are as follows:
Dim MailLink As String Dim SendTo As String ''''Loop to create SendTo MailLink = "mailto:" & SendTo ThisWorkbook.FollowHyperlink MailLink, , True I have a loop that increments SendTo by adding a semicolon and a new name. It worked fine up to SendTo containingf 38 names and the string had a length of 926 characters. It failed with err.number = 5 when SendTo contained 39 names and 951 characters. Can anyone tells me why it fails and how to workaround this. I know I can paste many more than 60 names in Outlook, so I don't think it's an Outlook limitation I would like to send an email to about 100 subcontractors on a project, and I have to go through the process 3 times right now and select about 33 or 34 names each time. Thanks in advance for any help. Ron Dahl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
followhyperlink failure
Ron
I don't have an answer for you. I'm using XL2000, OL2000 and IE6 and I get a problem around 460 characters (which is about 15 email addresses). I don't get the same error as you, rather I get "The default email client is not installed correctly." Then the email shows up but it has some weird characters in the ninth listing, like this: ; ; ; ; ; ; ; ; dickk˙˙˙˙L?b If I do 14 addresses, it works fine and all 14 show up in the mail message. If I try 80 such email address, I get "FollowHyperlink method of Workbook class failed." That's not much help to you, but I thought I'd mention it anyway. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Ron Dahl" wrote in message ... Some of the lines of code that I am using are as follows: Dim MailLink As String Dim SendTo As String ''''Loop to create SendTo MailLink = "mailto:" & SendTo ThisWorkbook.FollowHyperlink MailLink, , True I have a loop that increments SendTo by adding a semicolon and a new name. It worked fine up to SendTo containingf 38 names and the string had a length of 926 characters. It failed with err.number = 5 when SendTo contained 39 names and 951 characters. Can anyone tells me why it fails and how to workaround this. I know I can paste many more than 60 names in Outlook, so I don't think it's an Outlook limitation I would like to send an email to about 100 subcontractors on a project, and I have to go through the process 3 times right now and select about 33 or 34 names each time. Thanks in advance for any help. Ron Dahl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting failure | Excel Worksheet Functions | |||
vlookup failure & ctrl-f failure? | Excel Discussion (Misc queries) | |||
If .,AND ... Then failure | Excel Programming | |||
FollowHyperlink then Save File | Excel Programming | |||
followhyperlink event for textboxs | Excel Programming |