I manage lists for a not-for-profit group. We have an extensive member
database on an excel spreadsheet. I want to emails to a subset of that
spreadsheet. When I use the filter to select the people I want, then save
that list to a new file, I see only the names I want on that new spreasheet.
However, the names skipped over seem to be present in some form because they
all transfer to the csv file and end up in the email list. How can I avoid
this?

Filtering acutally only hides the unwanted records. They are still in the
file even though you can't see them. A way around this is to copy the
filtered list and paste it to a new workbook. Then save that workbook to a
csv. That way you should have only the list that you want.

-Simon

"ACE@MV" wrote:

I manage lists for a not-for-profit group. We have an extensive member
database on an excel spreadsheet. I want to emails to a subset of that
spreadsheet. When I use the filter to select the people I want, then save
that list to a new file, I see only the names I want on that new spreasheet.
However, the names skipped over seem to be present in some form because they
all transfer to the csv file and end up in the email list. How can I avoid
this?

thanks, simon, that worked. But I have another related question. The master
database has a whole bunch of "ghost" emails. In some cases where we don't
have a member email address and the email cell is blank, if you hold the
cursor over the cell, a balloon appears with "mail to..." and someone's email
address that has no relation to the person on that line. We went through the
spreadsheet manually and deleted/backspaced over all the cells where this
occurred. However, when I cut and pasted the email names this time into the
new workbook before saving it as a csv, those "ghost" emails were back in. I
didn't realize this until I sent the email and some came bouncing back,
having gone to addresses that I knew were no longer in the database (or so I
thought). Is there a way to remove these ghost email addresses permanently?

Thanks!

ACE@MV

"SimonCC" wrote:

Filtering acutally only hides the unwanted records. They are still in the
file even though you can't see them. A way around this is to copy the
filtered list and paste it to a new workbook. Then save that workbook to a
csv. That way you should have only the list that you want.

-Simon

"ACE@MV" wrote:

I manage lists for a not-for-profit group. We have an extensive member
database on an excel spreadsheet. I want to emails to a subset of that
spreadsheet. When I use the filter to select the people I want, then save
that list to a new file, I see only the names I want on that new spreasheet.
However, the names skipped over seem to be present in some form because they
all transfer to the csv file and end up in the email list. How can I avoid
this?

Hi

See my site for example code or use mu Add-in
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron De Bruin
http://www.rondebruin.nl



"ACE@MV" wrote in message ...
I manage lists for a not-for-profit group. We have an extensive member
database on an excel spreadsheet. I want to emails to a subset of that
spreadsheet. When I use the filter to select the people I want, then save
that list to a new file, I see only the names I want on that new spreasheet.
However, the names skipped over seem to be present in some form because they
all transfer to the csv file and end up in the email list. How can I avoid
this?