Hi!
I have a code that generates and sends email using outlook.
the code that puts the adresses is something like this:
the code is simple and working great so far...
The problem however, is that the range of adresses is so big, and alot of the cells containing adresses are even empty.
So, Is there a way to make vba make a list of reciepints from a range (C6:C776) an easier way?
Best reggards
Wigarth
I have a code that generates and sends email using outlook.
the code that puts the adresses is something like this:
VBA Code:
'something code here
.to = Range("A1").value & ";" & Range("A2").value
'something more code here
the code is simple and working great so far...
The problem however, is that the range of adresses is so big, and alot of the cells containing adresses are even empty.
So, Is there a way to make vba make a list of reciepints from a range (C6:C776) an easier way?
Best reggards
Wigarth