Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail XLS file
Hi,
I browsed a while throug this forum to find some code to send an e- mail with a XLS workbook (one sheet) from within Excel. There are different aproches for this (see Ron De Bruin site), using MAPI, SMTP, CDO ... but what i'm looking for is the following: - Must work with Outlook, Outlook Express, Mozilla, and other non MS e- mail clients, - must be cappable to place some text in the subject line, body and support attachment(s), - must run on Win 98 SE, XP and higher, - run with Office 2000 and higher. - installation on an other PC must be as simple as possible, because not every user is a PC / software guru. Why this question? I'm writing a Excel application that need to run on different PC's with different mail clients and different operating systems. One person (living 120km from my home) is entering the data in an excel file, and send this to 2 other persons for evaluation and print out expence forms. Once the expence forms are printed, the data file need te be send back the the person who initialy fill it out to add new data. So the data file is going from person A to person B and C, and after evaluation and printout goes back from person B to person A and C. Person C keeps the file as backup. Now my question is as follow: What code (MAPI, SMTP, ...)would you recommendt to use for it, to work in this diversity of mail clients and operating systems? I'm getting a bit lost in the wood! Any help is welcome. Regards, Ludo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail XLS file
There is no standard code that will work in all mail programs and Windows versions and do all this stuff
- Must work with Outlook, Outlook Express, Mozilla, and other non MS e- mail clients, - must be cappable to place some text in the subject line, body and support attachment(s), - must run on Win 98 SE, XP and higher, - run with Office 2000 and higher. Maybe there is a third party program that can do it -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ludo" wrote in message oups.com... Hi, I browsed a while throug this forum to find some code to send an e- mail with a XLS workbook (one sheet) from within Excel. There are different aproches for this (see Ron De Bruin site), using MAPI, SMTP, CDO ... but what i'm looking for is the following: - Must work with Outlook, Outlook Express, Mozilla, and other non MS e- mail clients, - must be cappable to place some text in the subject line, body and support attachment(s), - must run on Win 98 SE, XP and higher, - run with Office 2000 and higher. - installation on an other PC must be as simple as possible, because not every user is a PC / software guru. Why this question? I'm writing a Excel application that need to run on different PC's with different mail clients and different operating systems. One person (living 120km from my home) is entering the data in an excel file, and send this to 2 other persons for evaluation and print out expence forms. Once the expence forms are printed, the data file need te be send back the the person who initialy fill it out to add new data. So the data file is going from person A to person B and C, and after evaluation and printout goes back from person B to person A and C. Person C keeps the file as backup. Now my question is as follow: What code (MAPI, SMTP, ...)would you recommendt to use for it, to work in this diversity of mail clients and operating systems? I'm getting a bit lost in the wood! Any help is welcome. Regards, Ludo |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail XLS file
Why can't the users email the XLS?
Why can't you have a form that prompts the user for the type of email program they use and then use a case statement to select from one of the methods from the de Bruin site? If things have to be transparent to the user then you need a website where users can get fetch the Workbook (or an XML representation of the data in the Worksheet which can be converted into a WorkSheet in an XL Template), process it, and then post their changes to the site - with some email going on for the workflow. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-mail XLS file
On 2 sep, 06:20, "
wrote: Why can't the users email the XLS? Why can't you have a form that prompts the user for the type of email program they use and then use a case statement to select from one of the methods from the de Bruin site? If things have to be transparent to the user then you need a website where users can get fetch the Workbook (or an XML representation of the data in the Worksheet which can be converted into a WorkSheet in an XL Template), process it, and then post their changes to the site - with some email going on for the workflow. Thanks anywy for the reply. You gave me a hint. Think to use a selectionbox where the user select his mail client, as Outlook, Outlook Express, or Other and depending on this selection use different code to send the mail (MAPI, SMTP,...). Because of the nature of the contents of the XLS file (payment amount) don't i like to place this on a website as a "pass throug" to collect the data on an other PC. Regards, Ludo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Sending file using File/Send to/Mail Recipient | Excel Discussion (Misc queries) | |||
Excel - Sending file using File/Send to/Mail Recipient | Excel Discussion (Misc queries) | |||
append file on e-mail | Excel Programming | |||
E-Mail File Q | Excel Programming |