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
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
