Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy Outlook noteitem data to clipboard

Status
Not open for further replies.
Dec 9, 2002
29
US
I have a script attached to a button on an Outlook contact form that copies contact info and places it in an Outlook Note. I want to rather have the data copied to the Windows clipboard, so it can be pasted into Word docs. Here's the code so far:


Set itm = Application.CreateItem(5)
msgString = Item.FullName & chr(13)
msgString = msgString & Item.CompanyName & chr(13)
msgString = msgString & Item.BusinessAddress & chr(13)
msgString = msgString & chr(13)
msgString = msgString & "Office:" & chr(32) & Item.BusinessTelephoneNumber & chr(13)
msgString = msgString & "Fax:" & chr(32) & Item.BusinessFaxNumber & chr(13)
msgString = msgString & "Mobile:" & chr(32) & Item.MobileTelephoneNumber & chr(13)
msgString = msgString & Item.Email1Address
itm.Body = msgString


Instead of using "itm.Body = msgString" above, I've tried


msgString.select
selection.copytoclipboard


and


msgstring.putinclipboard


and


set myitm = itm.body
myitm.putinclipboard



Noe of these work. Any advice is welcome!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top