Help to Send as attachment.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pools - 01 Jul 2006 03:15 GMT

I'm very new to excel and I have created a very simple sheet that wil
allow some friends to make some football predictions. I will post
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 le
them click it and it emails it to me as an attachment.

Ultimately, I would like to be able to incorporate this into a
executable (for those without excel, but I am also lacking i
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,
Stev

Reply to this Message

Ron de Bruin - 01 Jul 2006 10:01 GMT

Hi Pools

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

Signature

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

> 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
[quoted text clipped - 12 lines]
> Thanks in advance,
> Steve

Reply to this Message

Pools - 01 Jul 2006 17:58 GMT

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

Signature

Pools

Reply to this Message

Gord Dibben - 01 Jul 2006 18:12 GMT

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 Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to Tool>Macro>Macros.

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

Gord Dibben MS Excel MVP

>Ron,
>
[quoted text clipped - 6 lines]
>Thanks again,
>Steve

Gord Dibben MS Excel MVP

Reply to this Message

Pools - 01 Jul 2006 19:26 GMT

Gord,

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

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

Thanks for your tremendous help,
Stev

Reply to this Message

Gord Dibben - 01 Jul 2006 19:50 GMT

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

>Gord,
>
[quoted text clipped - 6 lines]
>Thanks for your tremendous help,
>Steve

Gord Dibben MS Excel MVP

Reply to this Message

Ron de Bruin - 01 Jul 2006 21:12 GMT

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

Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.

Signature

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

>I would wait for Ron to speak to whether it only works for Outlook or OE.
>
[quoted text clipped - 19 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message

Pools - 02 Jul 2006 03:03 GMT

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

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

Thanks again,
Stev

Reply to this Message