Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Macro to add list of email addresses to Bcc field
|
|
|
Bookmark this page|
The UK's most regular 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. |
Macro to add list of email addresses to Bcc field
Resolved · Low Priority · Version 2003
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Macro to add list of email addresses to Bcc field
Hi GrahamThanks 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.
|
 |
|
» Forum post: Powerpoint |
How do i make a bulid on a slide?
