A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Copy Email Subject Macro?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 19th 08, 05:33 PM posted to microsoft.public.outlook.program_vba
G
external usenet poster
 
Posts: 25
Default Copy Email Subject Macro?

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  
Old August 19th 08, 08:19 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Copy Email Subject Macro?



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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 07:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.