- Joined
- Mar 13, 2011
- Messages
- 2,531
- Reaction score
- 6
- Points
- 38
- Location
- Nanaimo, BC, Canada
- Website
- www.excelguru.ca
- Excel Version(s)
- Excel Office 365 Insider
Oh... yikes... :embarassed:
Change this line:
To this:
I can't believe I missed adding the cell's value to the text string. Doh![/COLOR]
Change this line:
Code:
[COLOR=#333333]sEmails = sEmails & ","
To this:
Code:
[/COLOR][COLOR=#333333]sEmails = sEmails & Cl.Value & ","
I can't believe I missed adding the cell's value to the text string. Doh![/COLOR]