LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Sending E-mail

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
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
General mail failure when sending e-mail from Excel Adrienne Excel Discussion (Misc queries) 5 November 4th 05 12:59 PM
Sending E-mail litew_8 Excel Worksheet Functions 1 November 21st 04 06:13 AM
Sending e-mail - Ron, you still there? Steph[_3_] Excel Programming 2 September 22nd 04 12:52 AM
Help sending mail... Dick Kusleika[_3_] Excel Programming 1 August 13th 04 04:13 AM
Help sending mail... Bob Phillips[_6_] Excel Programming 1 August 12th 04 08:50 PM


All times are GMT +1. The time now is 07:41 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"