Do you have a formas burron or a control toolbox button on your sheet ?



--

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


"MeMe" wrote in message ...
hi Ron,

my Command Button doesn't work anymore. I have to run the macro from the menu.

I can't even right-click to get to format our properties. I don't know what
I did, but I did try to get that signature to work.

Help, please.

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/mail/folder3/signature.htm


Lastly, when I type the text for the body, it is to the left of the icon
What do you mean with icon
Do you use a old version of Outlook


--

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


"MeMe" wrote in message ...
Hi Ron,

thank you for your link. It helped out a lot. I have another, hopefully
quick, question: can I add an auto signature to this macro? The trick is that
there are multiple signatures that could be chosen and I would want the
signature to appear after the icon.

Lastly, when I type the text for the body, it is to the left of the icon and
I would like to have the intro sentence on the first line saying here is your
weekly file, then the icon underneath the intro, then our department
signature underneath the icon kinda idea.

Opps, one more, what is the best way to protect a macro from being
viewed/changed?

Appreciate any help you can offer.

"Ron de Bruin" wrote:

Hi MeMe

You find all the code you need on this page
(click also on the Tip page link on each example page0
http://www.rondebruin.nl/sendmail.htm



--

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


"MeMe" wrote in message ...
I have an excel file that I send weekly to some Managers. Currently, I copy
and paste a list of e-mail addresses in a new Outlook message and then send
the file. I wanted to create a Command Button, but I can't create the VBA
code to send the excel file via Outlook. Can I get some help please?

thanks, meme