Hi folx,

Perhaps u can help me?

I have a field C2 ").
With a click on a button, Outlook generates an email with Email-Adress,
Body, Subject, Attachment and Signatur.
But I want that the email-Adress for the To-Field is not given in the code,
I want for that the Email is taken from field C2.

Therefore I thought, that I can provide this field dynamic, so that VBA
takes the Name of the Button (in this Case C2) and after that it chooses the
field C2, lookes inside, takes the adress in C2 and puts it in the To-Field!

How can I get the name of the button if I have over 500 Buttons?
The Code should something like:
adress = Mebutton.name

But if I use "Me." it takes actually sheet1 and not my Button C2.

Do I want to much?
I know everything about that process but now idea how to query the the name
of the button in that button.
How do I get the name?

So I hope someone can help me.

Kindly
oener