I'm very new to excel and I have created a very simple sheet that will
allow some friends to make some football predictions. I will post a
link to what I have so far, but what I want to be able to do is,
instead of the email link that I have put into it, to be able to let
them click it and it emails it to me as an attachment.

Ultimately, I would like to be able to incorporate this into an
executable (for those without excel, but I am also lacking in
programming knowledge so for now I'll settle for this method.

Here is the link: http://poolgod.zftp.com/predictions.xls

Any help with this would be tremendously appreciated!

Thanks in advance,
Steve


--
Pools
------------------------------------------------------------------------
Pools's Profile: http://www.excelforum.com/member.php...o&userid=35961
View this thread: http://www.excelforum.com/showthread...hreadid=557523

Hi Pools

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Pools" wrote in message
...

I'm very new to excel and I have created a very simple sheet that will
allow some friends to make some football predictions. I will post a
link to what I have so far, but what I want to be able to do is,
instead of the email link that I have put into it, to be able to let
them click it and it emails it to me as an attachment.

Ultimately, I would like to be able to incorporate this into an
executable (for those without excel, but I am also lacking in
programming knowledge so for now I'll settle for this method.

Here is the link: http://poolgod.zftp.com/predictions.xls

Any help with this would be tremendously appreciated!

Thanks in advance,
Steve


--
Pools
------------------------------------------------------------------------
Pools's Profile: http://www.excelforum.com/member.php...o&userid=35961
View this thread: http://www.excelforum.com/showthread...hreadid=557523

Ron,

Thank you very much, the first option there (example 1) seems to be
what I'm looking for, although I'm unsure of how to make the cell that
I place the code in into a link that will actually allow someone to
click it and have the workbook mailed as an attachment. Forgive me if
this is knowledge that I'm assumed to have.

Thanks again,
Steve


--
Pools
------------------------------------------------------------------------
Pools's Profile: http://www.excelforum.com/member.php...o&userid=35961
View this thread: http://www.excelforum.com/showthread...hreadid=557523

The code does not go into a cell.

The code must be pasted into a general module and the macro run.

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project by name and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo


Gord Dibben MS Excel MVP

On Sat, 1 Jul 2006 11:58:31 -0500, Pools
wrote:


Ron,

Thank you very much, the first option there (example 1) seems to be
what I'm looking for, although I'm unsure of how to make the cell that
I place the code in into a link that will actually allow someone to
click it and have the workbook mailed as an attachment. Forgive me if
this is knowledge that I'm assumed to have.

Thanks again,
Steve

Gord Dibben MS Excel MVP

Gord,

Thank you very much for the quick response. I was able to attach the
macro to a button and that is exactly what I wanted!

I suppose that it will only work for those using Outlook or Outlook
Express as their mail client, is that correct?

Thanks for your tremendous help,
Steve


--
Pools
------------------------------------------------------------------------
Pools's Profile: http://www.excelforum.com/member.php...o&userid=35961
View this thread: http://www.excelforum.com/showthread...hreadid=557523

I would wait for Ron to speak to whether it only works for Outlook or OE.

The only experience I have had with Ron's mail sending code was to use his
SENDMAIL add-in which is built specifically for Outlook or OE

Version 2.0 for Outlook and OE

Version 3.2 for Outlook only


Gord

On Sat, 1 Jul 2006 13:26:00 -0500, Pools
wrote:


Gord,

Thank you very much for the quick response. I was able to attach the
macro to a button and that is exactly what I wanted!

I suppose that it will only work for those using Outlook or Outlook
Express as their mail client, is that correct?

Thanks for your tremendous help,
Steve

Gord Dibben MS Excel MVP

hi Pools

For other mail programs it is possible that the code is working if
you use the SendMail code.
There are so many mail programs on this moment.

If you test it be sure that the mail program is the mail program that you see in

StartSettingsControl Panel....Internet options (Program Tab)
Close Excel first before you make a change.



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
I would wait for Ron to speak to whether it only works for Outlook or OE.

The only experience I have had with Ron's mail sending code was to use his
SENDMAIL add-in which is built specifically for Outlook or OE

Version 2.0 for Outlook and OE

Version 3.2 for Outlook only


Gord

On Sat, 1 Jul 2006 13:26:00 -0500, Pools
wrote:


Gord,

Thank you very much for the quick response. I was able to attach the
macro to a button and that is exactly what I wanted!

I suppose that it will only work for those using Outlook or Outlook
Express as their mail client, is that correct?

Thanks for your tremendous help,
Steve

Gord Dibben MS Excel MVP

OK, thanks so much for you guys' help, I feel like I'm learning
something about this finally.

I'll assume that The Bat (my email client) isn't supported, but I
really only wanted to include that button for others to send the
results to me, so I think it's just how I need it to be.

Thanks again,
Steve


--
Pools
------------------------------------------------------------------------
Pools's Profile: http://www.excelforum.com/member.php...o&userid=35961
View this thread: http://www.excelforum.com/showthread...hreadid=557523