ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Send Email Based on Spreadsheet Criteria (https://www.excelbanter.com/excel-programming/333209-send-email-based-spreadsheet-criteria.html)

WDP

Send Email Based on Spreadsheet Criteria
 
I have a spreadsheet with data that looks something like the data below. I
am looking for a way to automate sending an email to each user (Email Field)
with all the rows that include data for that User

Date Email Subject
6/27/2005 Test4
6/27/2005
Test7
6/28/2005
Test3
6/28/2005
Test6
6/29/2005
Test1
6/29/2005
Test2
6/29/2005
Test5

For would get an email with the following
information

Date Email Subject
6/29/2005
Test1
6/29/2005
Test2
6/28/2005
Test3
6/27/2005
Test4

Any ideas on whether Excel can even do this....and if so, how one would go
about making it happen.

Thank you








Ron de Bruin

Send Email Based on Spreadsheet Criteria
 
Hi

Attachment or Body ?
Which mail program do you use

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


"WDP" wrote in message ...
I have a spreadsheet with data that looks something like the data below. I
am looking for a way to automate sending an email to each user (Email Field)
with all the rows that include data for that User

Date Email Subject
6/27/2005 Test4
6/27/2005
Test7
6/28/2005
Test3
6/28/2005
Test6
6/29/2005
Test1
6/29/2005
Test2
6/29/2005
Test5

For would get an email with the following
information

Date Email Subject
6/29/2005
Test1
6/29/2005
Test2
6/28/2005
Test3
6/27/2005
Test4

Any ideas on whether Excel can even do this....and if so, how one would go
about making it happen.

Thank you










PF

Send Email Based on Spreadsheet Criteria
 
lets say i have price quote sheet on my screen- i want to draw lines and
maybe squares on it - then email and maybe save

"WDP" wrote:

I have a spreadsheet with data that looks something like the data below. I
am looking for a way to automate sending an email to each user (Email Field)
with all the rows that include data for that User

Date Email Subject
6/27/2005 Test4
6/27/2005
Test7
6/28/2005
Test3
6/28/2005
Test6
6/29/2005
Test1
6/29/2005
Test2
6/29/2005
Test5

For would get an email with the following
information

Date Email Subject
6/29/2005
Test1
6/29/2005
Test2
6/28/2005
Test3
6/27/2005
Test4

Any ideas on whether Excel can even do this....and if so, how one would go
about making it happen.

Thank you









All times are GMT +1. The time now is 12:25 PM.

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