Making an e-mail list from Excel data

[potter]

I'm a new user with Excel 2003. I have a worksheet with e-mail column, and
managed to make a Custom List under the Tools/Options menu. It worked
perfectly to give me a list of e-mail addresses from my Excel column, but I
can't seem to copy it so I can use it to send e-mail in Outlook Express.
There is no "Copy" option in the custom box, and i can't activate the Copy
function on the toolbar while the box is on screen.

 

[Ron de Bruin]

Hi Potter

You can do it with a macro

See the SendMail examples (first part)
http://www.rondebruin.nl/sendmail.htm
And click on the Tip link you see on each example page

This one:
http://www.rondebruin.nl/mail/tips1.htm

 

[potter]

Thanks Ron...I will study these tips and use them when I want to send copies
of the workbook. But what I;m really looking for now is not to send the
work, but to capture the data from a Contacts sheet in the column that's
headed "Ë-mail address" and make those addresses into a list that I can put
into the To bar of Outlook Express to send a group e-mail (not about the
workbook, but about community information). I can make the list by using
Tools/Options/Custom Lists, but when I get all the addresses extracted into
the List box, I can't copy it to use it. I hope you have another solution
for me!