Help to Send as attachment.

  • Thread starter Thread starter Pools
  • Start date Start date
P

Pools

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
 
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
 
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,

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
Click to expand...

Gord Dibben MS Excel MVP
 
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
 
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,

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
Click to expand...

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

Start>Settings>Control Panel....Internet options (Program Tab)
Close Excel first before you make a change.
 
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
 
Back
Top