Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
WinXP Pro SP2, Excel 2000, OE6
I have a client shipping schedule which includes all of our clients' shipping dates for a three month period. I have a program which gathers a list of the clients in the most recent schedule, then filters on each client, copy's the filtered schedule into a worksheet named after the client. For example... Oct 1-7th Order Number - Client - Ship date... 1001 - Jones - 10/01/05 1004 - Smith - 10/03/05... Becomes: Oct 1-7th Order Number - Client - Ship date... 1001 - Jones - 10/01/05 (on a worksheet titled "Jones") and Oct 1-7th Order Number - Client - Ship date... 1004 - Smith - 10/03/05 (on a worksheet titled "Smith") Now, on a separate sheet I have a constant list of client's e-mail addresses. I basically want to browse this list and if I find a client with an e-mail address who has a report, I want to e-mail said worksheet. The built-in toolbar for E-Mail in Excel works exactly perfectly for my needs. However trying to capture a macro to use the toolbar has been most unsuccessful. Is there a way to exactly emulate the pressing of the envelope toolbar button, fill in the "To:" and "Subject:" lines and send it off? I did find http://www.rondebruin.nl/sendmail.htm in my searching but it seems like a long way to go when all I seem to need to do is push that E-mail button, and send the sheet off. Can anyone tell me if there's a simple way to do what I'm trying to do or if I need to work with the sendmail thing? Thank you for your time. CB Hamlyn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
Sending E-mail | Excel Worksheet Functions | |||
Sending e-mail - Ron, you still there? | Excel Programming | |||
Help sending mail... | Excel Programming | |||
Help sending mail... | Excel Programming |