I have a spredsheet of clients and it is formatted in rows. i.e, every client
has a row.
Col A = Company
Col B = Contact Person
Col C = Phone No
Col D = Fax No
Col E = Email
Col F = Postal Address
Col G = City
Col H = State
Col I = Post Code
Now one of the columns(E) is for email address,what I want to do is to be
able to send a bulk email to everyone that has an email address.

what I need to do is create an email button or find out how to create a
marco or something to add all the emails to one email Message. At the moment
I have to click on each address then attach the document, the repeat the
process for the hundreds of people on the list...

So if anyone can help me that would be great..

thanks for your time

Rusty

My suggestion is that you put all your contacts into your e-mail programme
such as outlook, then create a group for all those people. In that way you
could e-mail them all at one time. Not sure that you can do that straight
from excel...

"russkris00" wrote:

I have a spredsheet of clients and it is formatted in rows. i.e, every client
has a row.
Col A = Company
Col B = Contact Person
Col C = Phone No
Col D = Fax No
Col E = Email
Col F = Postal Address
Col G = City
Col H = State
Col I = Post Code
Now one of the columns(E) is for email address,what I want to do is to be
able to send a bulk email to everyone that has an email address.

what I need to do is create an email button or find out how to create a
marco or something to add all the emails to one email Message. At the moment
I have to click on each address then attach the document, the repeat the
process for the hundreds of people on the list...

So if anyone can help me that would be great..

thanks for your time

Rusty