Paste clipboard contents using VBAI need a macro that adds a specific text, plus the content of my clipboard, at the end of the subject of all messages I have selected. How do I get the content of the clipboard automatically, without first pasting it into an Input Box Although Outlook VBA doesnt include a paste from clipboard function directly, you can use the MSForms dataobject to transfer the clipboard contents to a string which is then called from VBA. KB/aspnet/WebBrowser/script-vs.jpg' alt='Microsoft Web Browser Control Vba String' title='Microsoft Web Browser Control Vba String' />You could also use use the Word object model to copy the message body to the clipboard. You can also use Words Keep Source Formatting to paste formatted text into an Item Body. Code sample is at Paste formatted text using VBAAdd code similar to this to your macro. Dim Data. Obj As MSForms. Data. Object. Set Data. Obj New MSForms. Access utilities and addins, as well as code samples and tips. MS Access DLookup Function. This MSAccess tutorial explains how to use the Access DLookup function with syntax and examples. Description. The Microsoft Access. Data. Object. Data. Obj. Get. From. Clipboard. Paste Data. Obj. Get. Text1. The finished code will look something like the following. Note, you will need to have a reference to the Forms library in Tools, References. If you receive a User defined type not defined you are missing the reference to Microsoft Forms 2. Object Library. If its not listed, add C WindowsSystem. FM2. 0. dll or C WindowsFM2. Sub Addto. Subject. Dim ex As Explorer. Dim mail As Mail. Item. Set ex Application. Active. Explorer. VB_HTMLDisplay/wb1.jpg' alt='Microsoft Web Browser Control Vba String' title='Microsoft Web Browser Control Vba String' />Dim str. Paste As Variant. Dim Data. Obj As MSForms. Data. Object. Set Data. Obj New MSForms. Data. Object. Data. Obj. Get. From. Clipboard. Paste Data. Obj. Get. Text1. If str. Paste False Then Exit Sub. If str. Paste Then Exit Sub. For Each mail In ex. Selection. mail. Subject mail. Although Outlook VBA doesnt include a paste from clipboard function directly, you can use the MSForms dataobject to transfer the clipboard contents to a string which. Subject my text str. Paste. Set Data. Obj Nothing. Copy to Clipboard. If youve followed along with some of the programming articles that Ive published here at MUO, then you know that I have a major love affair with VBA. It isnt. You referred to an object property or method, but didnt provide a valid object qualifier. Specify an object qualifier if you didnt provide one. For. I am trying to grab some football player data from a website to fill a privately used database. Ive included the entire code below. This first section is a looper. What about going in the other direction copying text to the clipboard Use Put. In. Clipboard to capture the text. Remember, if you receive a User defined type not defined you are missing the reference to Microsoft Forms 2. Object Library. If its not listed, add C WindowsSystem. FM2. 0. dll or C WindowsFM2. Sub Captureto. Clipbaord. Dim o. Mail As Mail. Item. Data. Obj As MSForms. Data. Object. Set o. Mail Active. Explorer. Selection. Item1. Set Data. Obj New MSForms. Data. Object. Data. Obj. Set. Text o. Mail. Body. Data. Obj. Put. In. Clipboard. Use Word Object Model to Copy and PasteCurrent versions of Outlook use Word as the email as the email editor and can use the Word object model library to do things not normally supported in Outlook. This sample copies the body of the selected message to the clipboard. To paste, useobj. Sel. Paste. And. Format wd. Format. Original. FormattingDont forget to set a reference to Words Object model in Tools, References. Sub Copy. Message. Dim obj. Mail As Outlook. Mail. Item. Dim obj. Insp As Inspector. Dim obj. Doc As Word. Document. Dim obj. Sel As Word. Selection. Set obj. Mail Application. Active. Explorer. Selection. Item1. If Not obj. Mail Is Nothing Then. If obj. Mail. Class ol. Mail Then. Set obj. Insp obj. Mail. Get. Inspector. If obj. Insp. Editor. Type ol. Editor. Word Then. Set obj. Doc obj. Insp. Word. Editor. Set obj. Word obj. Doc. Application. Set obj. Sel obj. Word. Selection. With obj. Sel. Whole. Story. Copy. End With. End If. Set obj. Mail Nothing. End Sub. This sample shows how to paste the copied content into a new message. Dim obj. Mail As Outlook. Mail. Item. Dim obj. Insp As Inspector. Dim obj. Doc As Word. Document. Dim obj. Sel As Word. Selection. Set obj. Mail Application. Create. Itemol. Mail. Item. To Aliasdomain. Subject This is the subject. Set obj. Insp obj. Mail. Get. Inspector. If obj. Insp. Editor. Type ol. Editor. Word Then. Set obj. Doc obj. Insp. Word. Editor. Set obj. Word obj. Doc. Application. Set obj. Sel obj. Word. Selection. obj. Sel. Paste. And. Format wd. Format. Original. Formatting. Set obj. Mail Nothing. End Sub. Paste format types are below. For more information see Wd. Recovery. Type Enumeration Word. Name. Descriptionwd. Chart. Pastes a Microsoft Office Excel chart as an embedded OLE object. Chart. Linked. Pastes an Excel chart and links it to the original Excel spreadsheet. Chart. Picture. Pastes an Excel chart as a picture. Format. Original. Formatting. Preserves original formatting of the pasted material. Format. Plain. Text. Pastes as plain, unformatted text. Format. Surrounding. Formatting. With. Emphasis. Matches the formatting of the pasted text to the formatting of surrounding text. List. Combine. With. Help For Cracked Tooth Pain. Existing. List. Merges a pasted list with neighboring lists. List. Continue. Numbering. Continues numbering of a pasted list from the list in the document. List. Dont. Merge. Not supported. wd. List. Restart. Numbering. Restarts numbering of a pasted list. Paste. Default. Not supported. Single. Cell. Table. Pastes a single cell table as a separate table. Single. Cell. Text. Pastes a single cell as text. Table. Append. Table. Merges pasted cells into an existing table by inserting the pasted rows between the selected rows. Table. Insert. As. Rows. Inserts a pasted table as rows between two rows in the target table. Table. Original. Formatting. Pastes an appended table without merging table styles. Table. Overwrite. Cells. Pastes table cells and overwrites existing table cells. Use. Destination. Styles. Recovery. Uses the styles that are in use in the destination document.