Putting a value in Excel into Word

[MrsTFB]

I've written a macro to send an Outlook message using a Word document as the text of message.
It works great, but each message needs to be unique with a value inside the excel worksheet. I used Microsoft article Q1661812-xl97. It works! But I need the name of the worksheet involved in the message.

Any help appreciated. [sig][/sig]

 

[BobCrawf]

Add something like

& ActiveSheet.Name

to the code that creates the text block for output. [sig][/sig]