Copying a string to the clipboard

[stemar]

I want to be able to use an address from an access database into Word for odd one-off letters.

It seems logical to me to open the personal details form which has all the data I want and click a button to copy the address, suitably formatted with VBCRs, to the clipboard, from where I can use it wherever I want. I have the address in string A, but how do I get A to the clipboard?

 

[Marbles]

Holding down the CTRL key and pressing C twice copies what is highlighted to the Clipboard, but I don't know the code for that, sorry.

 

[CT Witter]

Check out http://www.mvps.org/access/api/api0049.htm API: Copy variables/control contents to memory

for vba code.

HTH,
CT