Hi

Show me the macro that you use now
I change it for you then tomorrow

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


"jhicsupt" wrote in message ...
Everything is working. Now I want to get fancy.

Can I also rename the worksheet "EmployeeWorksheet-(myworksheetname.xls&
Sheet1 Cell B2 & Cell B3)

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/mail/tips1.htm

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


"jhicsupt" wrote in message ...
Is there a way to include in the subject line the contents of cell A1? The
reason I want to include this is because the employee's name is in A1 and I
want the subject to appear as I have hundreds of emails that I will be
receiving.

Subject: "Thank you for your order - Smith"

Thanks again.

"Ron de Bruin" wrote:

Hi

This will stop the macro and you must fill in the address
ActiveWorkbook.SendMail "", _

Or if you use one of the Outlook object model examples from my site
use .Display instead of .Send


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


"jhicsupt" wrote in message ...
This is almost it!!!!!

Is there a way to not automatically send it? In other words, just get it to
Outlook and then have the user send it from Outlook?

"Ron de Bruin" wrote:

Hi jhicsupt

Sorry for the questions.
No problem

We open the VBA editor with Alt-F11
We use InsertModule to create a new module
We copy a macro from this page
http://www.rondebruin.nl/mail/folder1/mail1.htm
in this module

Sub Mail_workbook_1()
ActiveWorkbook.SendMail ", _
"This is the Subject line"
End Sub
Change it to your mail address

Now we go back to Excel with Alt-q
Save the file

When you use Alt-F8 you will get your list with macro's
Select "Mail_workbook_1" and press run

Or add a button from the Forms toolbar and assign this macro to it
Or add a button from the control toolbox and enter the macro name in the click event

See help for help about the buttons








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


"jhicsupt" wrote in message ...
I tried using your example, but where do I paste the code. How is the email
generated? Is there a button that needs to be added so user would click it
to send the email? Sorry for the questions.

"Ron de Bruin" wrote:

Hi jhicsupt

Use one of the examples from my site
http://www.rondebruin.nl/sendmail.htm

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


"jhicsupt" wrote in message
...
How do I email the entire active workbook?

I want it to go to a specific person with a specific subject.

In other words, to: , Subject: "This confirms your order".

Thanks in advance.