How to embed email link in excel document to distribution list

N

Natalie

I am trying to insert (embed) an email link within an excel document that
could be clicked so the excel document would automatically be send to a
distribution list of predefined users. For example this is a Warehouse
Requisition that an enduser would fill out and within the excel document I
would like to include an Icon that would send that sheet to a list of users
who manage the requisitions. Does anyone know if that is possible.

Thanks,
Natalie
 
D

Dave F

It's possible.

It would require VBA code which is assigned to a button.

What that code would be, I'm not sure, but I'm pretty confident that if you
search in the Excel programming forum, you'll find your answer. This is a
pretty common request.
 
Top