ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I send an e-mail including data from a spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/29816-how-can-i-send-e-mail-including-data-spreadsheet.html)

jcfv

How can I send an e-mail including data from a spreadsheet?
 
I have customer's data in a Excel Spreadsheet, I want to send an e-mail to
each customer including the data by customer. Is there a way I can perform
this work?. Thanks in advance for any help!

Ron de Bruin

Hi jcfv

Do you have the data from each customer in a seperate sheet or do you have it in
one sheet.?



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


"jcfv" wrote in message ...
I have customer's data in a Excel Spreadsheet, I want to send an e-mail to
each customer including the data by customer. Is there a way I can perform
this work?. Thanks in advance for any help!




jcfv

Just one sheet. Organized by columns like a table in Access.

"Ron de Bruin" wrote:

Hi jcfv

Do you have the data from each customer in a seperate sheet or do you have it in
one sheet.?



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


"jcfv" wrote in message ...
I have customer's data in a Excel Spreadsheet, I want to send an e-mail to
each customer including the data by customer. Is there a way I can perform
this work?. Thanks in advance for any help!





Ron de Bruin

Hi

I send you a example after work
I must go now

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


"jcfv" wrote in message ...
Just one sheet. Organized by columns like a table in Access.

"Ron de Bruin" wrote:

Hi jcfv

Do you have the data from each customer in a seperate sheet or do you have it in
one sheet.?



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


"jcfv" wrote in message ...
I have customer's data in a Excel Spreadsheet, I want to send an e-mail to
each customer including the data by customer. Is there a way I can perform
this work?. Thanks in advance for any help!







Ron de Bruin

Hi

You can use Autofilter on your customer column and use my Add-in to send
the selection (only visible cells)
http://www.rondebruin.nl/mail/add-in.htm

Look for code example on this page
http://www.rondebruin.nl/sendmail.htm

If you need something else post back

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


"Ron de Bruin" wrote in message ...
Hi

I send you a example after work
I must go now

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


"jcfv" wrote in message ...
Just one sheet. Organized by columns like a table in Access.

"Ron de Bruin" wrote:

Hi jcfv

Do you have the data from each customer in a seperate sheet or do you have it in
one sheet.?



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


"jcfv" wrote in message ...
I have customer's data in a Excel Spreadsheet, I want to send an e-mail to
each customer including the data by customer. Is there a way I can perform
this work?. Thanks in advance for any help!








jcfv

Ron:

Thank you very much for helping me ... you're the best !!!

Julio

"Ron de Bruin" wrote:

Hi

You can use Autofilter on your customer column and use my Add-in to send
the selection (only visible cells)
http://www.rondebruin.nl/mail/add-in.htm

Look for code example on this page
http://www.rondebruin.nl/sendmail.htm

If you need something else post back

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


"Ron de Bruin" wrote in message ...
Hi

I send you a example after work
I must go now

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


"jcfv" wrote in message ...
Just one sheet. Organized by columns like a table in Access.

"Ron de Bruin" wrote:

Hi jcfv

Do you have the data from each customer in a seperate sheet or do you have it in
one sheet.?



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


"jcfv" wrote in message ...
I have customer's data in a Excel Spreadsheet, I want to send an e-mail to
each customer including the data by customer. Is there a way I can perform
this work?. Thanks in advance for any help!










All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com