98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro to add list of email addresses to Bcc field | Excel forum
Macro to add list of email addresses to Bcc field | Excel forum
Resolved · Low Priority · Version 2003
Wed 10 Mar 2010, 16:40Delegate Graham said...
Graham has attended:
Excel Advanced course
Macro to add list of email addresses to Bcc field
I have been able to open a new email using the code shown below. What I have not been able to work out, is how to add a list of email addresses from Excel rather than typing each individual address into the code. Any ideas?
Sub Germany_Click()
Dim ol, mail As Object
Set ol = CreateObject("Outlook.Application")
Set mail = ol.CreateItem(0)
mail.Subject = "Transport " & Now
mail.To = "somebody@somewhere.com"
mail.Bcc = "I would like to have a list of addresses from Excel here"
mail.Display
End Sub
Regards,
Graham
Thu 11 Mar 2010, 09:50
Edited on Thu 11 Mar 2010, 09:51Trainer Jacob said...
RE: Macro to add list of email addresses to Bcc field
Hi Graham
Thanks for your post and detail you have included. We have reviewed and whilst a solution is available it is beyond the scope of this forum.
We recommend you attend our 2 day Excel VBA Introduction course which will give you the skills to solve the issue you have at the moment. Click here for course information.
I noticed that Susann still has a standby place available that you can take advantage of to use as either a complimentary place or heavily discounted. This would be the best course of action.
Regards
Jacob
Wed 17 Mar 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Stop Formula Returning A "#DIV/0" ErrorIf a formula returns a #DIV/0 error message there is a way to avoid such results. |
