Copy Contents of Variable or FormField to Clipboard in Word

[ACH381]

How can I copy the contents of a variable, or the result of a formfield, to the Windows clipboard?

I need to pass an e-mail address stored in a variable or in a FormField from Word to the address field in a Lotus Notes e-mail document. To keep it simple I was just going to copy the address to the clipboard during the .sendmail script and have the user simply click in the address field in Lotus Notes and select edit-paste. However, I can't seem to get the address loaded onto the clipboard.

I'm open for any suggestions to get the address transferred over to the address field in a Lotus Notes memo.

 

[ACH381]

I have found my own solution. Here is the script:

Dim myDO As DataObject
Set myDO = New DataObject
myDO.SetText = "Something to copy to clipboard"
myDO.PutInClipboard