Copy a string variable to the clipboard

  • Thread starter Thread starter Duncs
  • Start date Start date
D

Duncs

Based on the contents of controls on my form, I have constructed a
text string that contains the information, as follows:

strClipText = "Transactions Process." & vbCrLf & _
"Information sent to release payments for
Acct= " & Me.txtAcct.Value & " from " & Me.txtFirstPaymentDate.Value &
vbCrLf & _
"Payments for Acct= <<Acct Num for foreign
account>> transferred to Acct= <<Acct for foreign account>> (Code=
<<Code for foreign account>>" & vbCrLf & _
"<<Your Name>> / <<Your Manager>> / Account
Processing." & vbCrLf

What I want to do now is, copy this text to the clipboard so that
agents can paste it directly into a contact note, thereby reducing
their processing time and limiting the possibility of errors.

My question is, how can I do this?

Many TIA

Duncs
 
Back
Top