I'm having a difficulty reading a column using a macro/vba into a string whereby it doesn't overwrite the string each time it grabs a new row's info from a column.
for instance say we have four car manufacturers
each time i get the column rows to assign it to a string, it overwrites the last. So inevitably I end up with the last one that is read; in this case it would be porsche.
what i'd like it to do is put it all on the same line for example:
ford; honda; ferrari; porsche
The reason I want to do this is so that in my microsoft access database I can read the 'email column' and grab all the emails and put it in the 'TO:' box in an outlook email..
Any ideas or methods would be great. Thanks