Popup box where I can copy paste text from there to email

[03Explorer]

I have a list of instructions for monthly reports. We have a team of people who rotate on performing the monthly reports. I want to standardize the report announcement to the receipients by having a popup screen (from within Excel) have the exact verbage to put into the message body. How can I do this in Excel? Or better yet, have a button next to each line item and the button opens Outlook send message and auto populates with the standard verbage.

Thanks!

 

[Bong]

Maybe here?

http://www.tek-tips.com/faqs.cfm?fid=4334

_________________
Bob Rashkin

 

[SkipVought]

Hi,

How can I do this in Excel?

Put your instructions in a list with a NAMED RANGE. you can put this list on a separate sheet if you want.

set up a Data > List that uses Data > Validation --LIST feature, where the referenced list is your instruction list. This will propogate the Data > Validation format to the next row

Make selections from the Data > Validation drop down.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}