software

Hi

I have an excel form which is emailed by users once a cmd button on the form
is click.

Is there anyway to code in a message in the main body of the email as you
can attach the document, enter in to the TO and the Subject field.

If it is possible is there a way that once the cmd button is clicked that a
message box appears requesting to have comments entered and once completed
and OK clicked then the email is sent with the comments in the main body that
was entered into the message box.

If I can please have how to do both scenarios that would be great as I need
to use both if possible.

Thanks
Noemi

Give this a go.

www.paulsadowski.com/WSH/cdo.htm

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
www.microsoft.com/protect

quot;Noemiquot; wrote:
| Hi
|
| I have an excel form which is emailed by users once a cmd button on the
form
| is click.
|
| Is there anyway to code in a message in the main body of the email as you
| can attach the document, enter in to the TO and the Subject field.
|
| If it is possible is there a way that once the cmd button is clicked that
a
| message box appears requesting to have comments entered and once completed
| and OK clicked then the email is sent with the comments in the main body
that
| was entered into the message box.
|
| If I can please have how to do both scenarios that would be great as I
need
| to use both if possible.
|
| Thanks
| Noemi
Hi Dave
I tried and it did not work. We have excel 2000 - Windows XP but we receive
the following error message and are not sure why or how to fix.

runtime error -2147220960 (80040220) The quot;SendUsingquot; configuration is invalid.

any help would be greatly appreciated.

Are you aware of anyother way.

Thanks
Noemi

quot;Dave Patrickquot; wrote:

gt; Give this a go.
gt;
gt; www.paulsadowski.com/WSH/cdo.htm
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Dave Patrick ....Please no email replies - reply in newsgroup.
gt; Microsoft Certified Professional
gt; Microsoft MVP [Windows]
gt; www.microsoft.com/protect
gt;
gt; quot;Noemiquot; wrote:
gt; | Hi
gt; |
gt; | I have an excel form which is emailed by users once a cmd button on the
gt; form
gt; | is click.
gt; |
gt; | Is there anyway to code in a message in the main body of the email as you
gt; | can attach the document, enter in to the TO and the Subject field.
gt; |
gt; | If it is possible is there a way that once the cmd button is clicked that
gt; a
gt; | message box appears requesting to have comments entered and once completed
gt; | and OK clicked then the email is sent with the comments in the main body
gt; that
gt; | was entered into the message box.
gt; |
gt; | If I can please have how to do both scenarios that would be great as I
gt; need
gt; | to use both if possible.
gt; |
gt; | Thanks
gt; | Noemi
gt;
gt;
gt;

Sounds like you tried using CDONTS.NewMail

I think you must use CDO.Message with Windows XP

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
www.microsoft.com/protect

quot;Noemiquot; wrote:
| Hi Dave
| I tried and it did not work. We have excel 2000 - Windows XP but we
receive
| the following error message and are not sure why or how to fix.
|
| runtime error -2147220960 (80040220) The quot;SendUsingquot; configuration is
invalid.
|
| any help would be greatly appreciated.
|
| Are you aware of anyother way.
|
| Thanks
| Noemi
Hi Dave
I used CDO.Message and I got the error.
I haven't tried using CDONTs.newmail

I think I will just forget the main body of the email and use the subject box.

Thanks for your help.

Noemi

quot;Dave Patrickquot; wrote:

gt; Sounds like you tried using CDONTS.NewMail
gt;
gt; I think you must use CDO.Message with Windows XP
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Dave Patrick ....Please no email replies - reply in newsgroup.
gt; Microsoft Certified Professional
gt; Microsoft MVP [Windows]
gt; www.microsoft.com/protect
gt;
gt; quot;Noemiquot; wrote:
gt; | Hi Dave
gt; | I tried and it did not work. We have excel 2000 - Windows XP but we
gt; receive
gt; | the following error message and are not sure why or how to fix.
gt; |
gt; | runtime error -2147220960 (80040220) The quot;SendUsingquot; configuration is
gt; invalid.
gt; |
gt; | any help would be greatly appreciated.
gt; |
gt; | Are you aware of anyother way.
gt; |
gt; | Thanks
gt; | Noemi
gt;
gt;
gt;

You need to fill in the smtp server name in your code. These may help.

How do I send e-mail with CDO?
www.aspfaq.com/show.asp?id=2026

Sending mail from Excel with CDO
www.rondebruin.nl/cdo.htm--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
www.microsoft.com/protect

quot;Noemiquot; wrote:
| Hi Dave
| I used CDO.Message and I got the error.
| I haven't tried using CDONTs.newmail
|
| I think I will just forget the main body of the email and use the subject
box.
|
| Thanks for your help.
|
| Noemi