I am using the following code and it works great the only problem is that when I have more then one email address in the same cell it will not send the email. Even if I seperate it with a semicolon. It work fine if I have just one email address in the email field. How can I get it to send the same info to different email addresses.
Please Login or Register to view this content.
Last edited by insanity66; 10-14-2009 at 02:02 PM.
Hello insanity66,
Using multiple recipients with the workbook SendMail method is virtually undocumented, save for this clue in the VBA Help files...
Which means you must use the Array function to create a list of recipients.Recipients Required Variant. Specifies the name of the recipient as text, or as an array of text strings if there are multiple recipients. At least one recipient must be specified, and all recipients are added as To recipients.
Example
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks for your help.
How do I get the email to display and not send? Is that possible?
I use this code for sending emails
Enter multiple address seperated by ;Please Login or Register to view this content.
Change the wait time to a longer value and it will show before sending, or take out the SendKeys String so it shows on the screen and you manually have to press send.
I was able to get it working with this code
and using semicolons to seperate email addresses
Thanks for everyone input
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks