help with email buttons in excel

D

Dave Wylie

Good Afternoon all.

I am using excel to track merchandise and notify specific people upon its
arrival...
Currently I have a button per line that will execute code to send an email
to an individual listed in the adjoining cell...
problem is that to have that many individual buttons creates long open and
close times for the ap.(recreating the same code for each button and just
change the one cell (email address location))
how can I create a function (module) that would allow me to pass the
pertinent cell info to the function and send the email. thus having only 1
function but 20 buttons.

any help would be appreciated
thanks

QA
 
M

mudraker

Dave

Suggestion 1

activate (higlight) the cell containging details of who is to receiv
the email

press button

have macro get get activecell.value similar to what you would be doin
now
eg
SendTo$=activecell.value


Suggestion 2

You can activate a macro by event procedures attached to the workshee
module that you can code to get the email addressee similar to m
suggestion one

These event triggers inclde
Worksheet_SelectionChange
Worksheet_BeforeDoubleClick
Worksheet_BeforeRightClick
Worksheet_Chang
 
Top