e-mail a file

Posted by mcarter on June 22, 2001 7:20 AM

i'm trying to place a form button to send an e-mail (see tip #16). i'm able to drag the command icon to the worksheet but it doesn't ask me to assign a macro to the button. also, will this function allow me to e-mail the entire file or just the worksheet where the button appears?

thanks.

Posted by Dax on June 22, 2001 7:26 AM

The reason that you can't assign a macro is because you're using the command button from the control toolbox, not the forms toolbox. To add code to the button just double click it and put whatever code you want in the empty procedure provided. Alternatively, use the command button from the Forms toolbar.

You can email whatever you want with the right VBA code.

Regards,
Dax.