Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
WDP WDP is offline
external usenet poster
 
Posts: 6
Default 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







  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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









  #3   Report Post  
Posted to microsoft.public.excel.programming
PF PF is offline
external usenet poster
 
Posts: 8
Default 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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Email when spreadsheet is updated XFILES Excel Discussion (Misc queries) 2 January 18th 07 01:41 PM
Send spreadsheet as email message dan Excel Discussion (Misc queries) 4 September 8th 06 10:20 PM
Hyperlink to an email to send a spreadsheet izbryte Excel Discussion (Misc queries) 2 May 6th 06 08:21 PM
Send worksheet via email this spreadsheet button Angelo[_2_] Excel Programming 3 January 4th 05 06:06 PM
Using VBA to send email based on form response muziq2[_11_] Excel Programming 4 June 7th 04 02:26 PM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"