Send an email to a list of emails in a worksheet

[cexarsiado]

Hi !!

Anybody can help me??...I need to send an email using Lotus to a list of emails contained in a .xls file with that same file attached.

Description: I have a .xls file with a list of e-mails and other data. I have to send this file to the e-mails that are into the file and at the same time attach that file to the e-mail.

Thanks

[David McRitchie]

see Ron de Bruin's pages
http://www.rondebruin.nl/tips.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"cexarsiado" <[email protected]> wrote in message
news:[email protected]...
>
> Hi !!
>
> Anybody can help me??...I need to send an email using Lotus to a list
> of emails contained in a .xls file with that same file attached.
>
> Description: I have a .xls file with a list of e-mails and other data.
> I have to send this file to the e-mails that are into the file and at
> the same time attach that file to the e-mail.
>
> Thanks
>
>
> --
> cexarsiado
> ------------------------------------------------------------------------
> cexarsiado's Profile: http://www.excelforum.com/member.php...o&userid=37807
> View this thread: http://www.excelforum.com/showthread...hreadid=573709
>

[Ron de Bruin]

For the OP

On this page you find a link for lotus examples
http://www.rondebruin.nl/mail/links.htm

Or you can use CDO
http://www.rondebruin.nl/cdo.htm



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



"David McRitchie" <[email protected]> wrote in message news:[email protected]...
> see Ron de Bruin's pages
> http://www.rondebruin.nl/tips.htm
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "cexarsiado" <[email protected]> wrote in message
> news:[email protected]...
>>
>> Hi !!
>>
>> Anybody can help me??...I need to send an email using Lotus to a list
>> of emails contained in a .xls file with that same file attached.
>>
>> Description: I have a .xls file with a list of e-mails and other data.
>> I have to send this file to the e-mails that are into the file and at
>> the same time attach that file to the e-mail.
>>
>> Thanks
>>
>>
>> --
>> cexarsiado
>> ------------------------------------------------------------------------
>> cexarsiado's Profile: http://www.excelforum.com/member.php...o&userid=37807
>> View this thread: http://www.excelforum.com/showthread...hreadid=573709
>>
>
>

[cexarsiado]

It helps me a lot, great page and great tips !!!...regards

For the OP

On this page you find a link for lotus examples
http://www.rondebruin.nl/mail/links.htm

Or you can use CDO
http://www.rondebruin.nl/cdo.htm



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



"David McRitchie" <[email protected]> wrote in message news:[email protected]...
> see Ron de Bruin's pages
> http://www.rondebruin.nl/tips.htm
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "cexarsiado" <[email protected]> wrote in message
> news:[email protected]...
>>
>> Hi !!
>>
>> Anybody can help me??...I need to send an email using Lotus to a list
>> of emails contained in a .xls file with that same file attached.
>>
>> Description: I have a .xls file with a list of e-mails and other data.
>> I have to send this file to the e-mails that are into the file and at
>> the same time attach that file to the e-mail.
>>
>> Thanks
>>
>>
>> --
>> cexarsiado
>> ------------------------------------------------------------------------
>> cexarsiado's Profile: http://www.excelforum.com/member.php...o&userid=37807
>> View this thread: http://www.excelforum.com/showthread...hreadid=573709
>>
>
>

[cexarsiado]

Ron, Do you know how to do this process of sending an e-mail through lotus with an attachment in an automatic way, always the same file attached and for example every month ????

For the OP

On this page you find a link for lotus examples
http://www.rondebruin.nl/mail/links.htm

Or you can use CDO
http://www.rondebruin.nl/cdo.htm



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



"David McRitchie" <[email protected]> wrote in message news:[email protected]...
> see Ron de Bruin's pages
> http://www.rondebruin.nl/tips.htm
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "cexarsiado" <[email protected]> wrote in message
> news:[email protected]...
>>
>> Hi !!
>>
>> Anybody can help me??...I need to send an email using Lotus to a list
>> of emails contained in a .xls file with that same file attached.
>>
>> Description: I have a .xls file with a list of e-mails and other data.
>> I have to send this file to the e-mails that are into the file and at
>> the same time attach that file to the e-mail.
>>
>> Thanks
>>
>>
>> --
>> cexarsiado
>> ------------------------------------------------------------------------
>> cexarsiado's Profile: http://www.excelforum.com/member.php...o&userid=37807
>> View this thread: http://www.excelforum.com/showthread...hreadid=573709
>>
>
>