I am using the following code to try and send a workbook via attachment to multiple email recipients however it will not work. If I only include one recipient then the code runs fine however it crashes when there is more than one.
Is anyone able to help me?
Please Login or Register to view this content.
Last edited by lethal; 11-23-2008 at 06:31 PM.
Good evening lethal
You just have to pass all the addresses to the mail client as a single string, the mail client will then parse them. Try this amendment :Originally Posted by lethal
HTHPlease Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Hi dominicb,
I have adjust my code as follows:
However I still get runtime error '1004': Unknown recipient name found in recipient list. Use a valid name and try again.Please Login or Register to view this content.
Do you have any idea why I am getting this error?
Last edited by lethal; 11-23-2008 at 11:35 PM.
Hi lethal
You seem not to have opened your quotes.
Try putting opening quotes in and rry again :
HTHPlease Login or Register to view this content.
DominicB
Hmm, I have no idea what I am doing wrong. I have the quotes in but I still get an error message.Hi lethal
You seem not to have opened your quotes.
Try putting opening quotes in and rry again :
HTHPlease Login or Register to view this content.
DominicB
Error message:Please Login or Register to view this content.
Run time error '1004':
This workbook contains features that are not supported by the file format that you selected. To avoid the possible loss of formatting or information, save a copy in the most recent Microsoft Excel Workbook format and resend it.
This is very strange as I am able to send email with only one recipient. So far I have been running the code 3 times in a row to send to 3 different recipients.
Hello Lethal,
The recipients may need to be separated with commas instead of semi-colons depending on your default email client. Outlook uses semi-colons while Outlook Express uses commas.
Sincerely,
Leith Ross
My default mail application is Outlook 2007 which is what Excel uses to send emails with only one recipient.
I have tried putting spaces between the semi colons but then I get the following error:
Run-time error '1004':
Unknown recipient name found in recipient list. Use a valid name and try again.
From what I read on this page: http://www.ozgrid.com/forum/showthread.php?t=81023 it seems as though there is a bug with VB/Outlook. I have gotten over the issue by setting up a distribution list in Outlook 2007 and sending to the distribution list name from VB code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks