Hi,

A part of a sheet I have two columns that contain e-mail addresses. I do not
know how many addresses there are in each column (though I can assign an
arbitary limit of, say, 1000) and there may be blank lines between addresses.

What I want to do is have a piece of code that will open the default e-mail
package on the user's machine and create a single new e-mail, sent to all the
addresses in the two columns.

Can anyone help with the code to do this?

TIA

Dave

Hi Risky Dave

What I want to do is have a piece of code that will open the default e-mail
This is diffecult ( Risky ) but you can start here
http://www.rondebruin.nl/sendmail.htm

On every example page there is a tip link that tell you how to use the mail addresses from a range


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Risky Dave" wrote in message ...
Hi,

A part of a sheet I have two columns that contain e-mail addresses. I do not
know how many addresses there are in each column (though I can assign an
arbitary limit of, say, 1000) and there may be blank lines between addresses.

What I want to do is have a piece of code that will open the default e-mail
package on the user's machine and create a single new e-mail, sent to all the
addresses in the two columns.

Can anyone help with the code to do this?

TIA

Dave

__________ Information from ESET Smart Security, version of virus signature database 3966 (20090326) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3966 (20090326) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Ron,

Thanks.

Unfortunately I can't guarantee that SendMail is installed on the machines
that is using this code as I will be distributing it free to a charity
organisation.

As a workaround, all I am doing is copying the concatenated addresses to the
clipboard and putting up a message box asking the user to paste into the To
field on the e-mail application.

Thanks for your time, though.

Dave

"Ron de Bruin" wrote:

Hi Risky Dave

What I want to do is have a piece of code that will open the default e-mail
This is diffecult ( Risky ) but you can start here
http://www.rondebruin.nl/sendmail.htm

On every example page there is a tip link that tell you how to use the mail addresses from a range


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Risky Dave" wrote in message ...
Hi,

A part of a sheet I have two columns that contain e-mail addresses. I do not
know how many addresses there are in each column (though I can assign an
arbitary limit of, say, 1000) and there may be blank lines between addresses.

What I want to do is have a piece of code that will open the default e-mail
package on the user's machine and create a single new e-mail, sent to all the
addresses in the two columns.

Can anyone help with the code to do this?

TIA

Dave

__________ Information from ESET Smart Security, version of virus signature database 3966 (20090326) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3966 (20090326) __________

The message was checked by ESET Smart Security.

http://www.eset.com