Copy to Clipboard

[ottograham]

How can I take multiple fields and copy them to the clipboard with a pushbutton?

For example, I want a Click event to do the following
Dim str as String
str = [TradeName] & vbcr & vblf & [Address] & vbcr & vblf & [City-st-zip]

THEN copy str to the clipboard to paste in a Word document.

Also, if there a quick error trap around empty fields other than an If Then seeing if they are empty?

Thanks

 

[Databaseguy]

You'd be better off doing a mail merge. Or, even better, instanciating a Word object and populating bookmarks with fields from your recordset.... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[ottograham]

Dear Databaseguy:

Thanks for the reply but you didn't answer the question.

Can I put the contents of the variable str into the Clipboard, and if so, how?

Mail Merges take too long for quick letters that I need to get out. Tell me more about instantiating a Word document and populating it with bookmarks (it sounds like a mail merge to me).

Thanks in advance