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

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

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.

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