contact email button

[javajon]

Hi,
I’ve just done a workbook for a local company and it works well, even the Gantt chart. When the document opens it automatically opens a form with my details on it, which I've done with a macro/form. It has a cancel button and I want to have a contact button, where the user would click and it opens their mail with my address on it.

I'm quite new at this and especially the programing vb side of things and still running office 2000. Thanks for reading my plea for help.

[Leith Ross]

Hello javajon,

Welcome to the Forum!

This macro will launch the user's default email program with your email listed in the recipient (To section. Change the code in blue to your email address.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name LaunchEmail to Run it.

Sincerely,
Leith Ross