![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I want to run a basic copy function that simply copies the subject of an
email to the clipboard. Can anyone point me in the right direction? Thank you, in advance, for your help. G |
Ads |
#2
|
|||
|
|||
![]() The currently select e-mail (if any) is Application.ActiveExplorer.Selection(1). The easiest way of working with the clipboard from Outlook is to use the MSForms library: Once you have added an UserForm to your project, you also have a reference to the MSForms library (if you don't need the UserForm, you may delete it). Open the object browser (f2), and switch from All libraries to MSForms. Then see the DataObject and it methods. You may click any function, and press f1 for more help. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool : http://www.vboffice.net/product.html?pub=6&lang=en Am Tue, 19 Aug 2008 08:33:02 -0700 schrieb G: I want to run a basic copy function that simply copies the subject of an email to the clipboard. Can anyone point me in the right direction? Thank you, in advance, for your help. G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy contents of Excel range name to Email Subject line | [email protected] | Outlook and VBA | 3 | June 21st 07 07:14 AM |
Macro to extract subject and sender name of messages in folder to Excel file | bony_tony | Outlook and VBA | 0 | March 7th 07 02:16 AM |
can a macro copy all meetings of a category to another calendar | Gaurav | Outlook and VBA | 1 | October 3rd 06 05:47 PM |
Outlook Macro to Modify Subject and Send Message | jaysonsch | Outlook and VBA | 4 | September 27th 06 06:48 AM |
Macro to prompt for metadata and them place in the subject line | Ben Bazian | Outlook and VBA | 1 | April 12th 06 07:19 AM |