Create macro with button in excel spreadsheet

I'm trying to create a macro in an excel workbook and have a button so that
when a customer completes the form, they hit the macro button and it creates
an EMail and populates the subject line. The folks who use the form download
it from my company's internal portal; all users are internal to the company.

Note, I have a rule set up in Outlook so that these EMails automatically
route to another folder so they don't get "lost" in my general inbox. Users
send the excel attachment to me OK, but the subject line is usually missed,
even though I have mistake-proofed it as best I can.

Gord
Wed Jul 23 15:55:40 CDT 2008

Just about all you need for email functions from Excel can be found at Ron
de Bruin's site.

http://www.rondebruin.nl/sendmail.htm


Gord Dibben MS Excel MVP



On Wed, 23 Jul 2008 12:10:01 -0700, Lori <Lori@discussions.microsoft.com>
wrote:

>I'm trying to create a macro in an excel workbook and have a button so that
>when a customer completes the form, they hit the macro button and it creates
>an EMail and populates the subject line. The folks who use the form download
>it from my company's internal portal; all users are internal to the company.
>
>Note, I have a rule set up in Outlook so that these EMails automatically
>route to another folder so they don't get "lost" in my general inbox. Users
>send the excel attachment to me OK, but the subject line is usually missed,
>even though I have mistake-proofed it as best I can.

gary
Thu Jul 24 07:43:01 CDT 2008

Thanks Gord.
I was looking for something like this.
I guess I'm going to have to check out Ron's site more thoroughly!
--
Sincerely,
Gary Brown


"Gord Dibben" wrote:

> Just about all you need for email functions from Excel can be found at Ron
> de Bruin's site.
>
> http://www.rondebruin.nl/sendmail.htm
>
>
> Gord Dibben MS Excel MVP
>
>
>
> On Wed, 23 Jul 2008 12:10:01 -0700, Lori <Lori@discussions.microsoft.com>
> wrote:
>
> >I'm trying to create a macro in an excel workbook and have a button so that
> >when a customer completes the form, they hit the macro button and it creates
> >an EMail and populates the subject line. The folks who use the form download
> >it from my company's internal portal; all users are internal to the company.
> >
> >Note, I have a rule set up in Outlook so that these EMails automatically
> >route to another folder so they don't get "lost" in my general inbox. Users
> >send the excel attachment to me OK, but the subject line is usually missed,
> >even though I have mistake-proofed it as best I can.
>
>