(Msg. 1) Posted: Wed Aug 27, 2008 4:50 am
Post subject: Quick/Easy Way to Copy Data from Email Archived from groups: microsoft>public>outlook>program_vba (more info?)
I want to copy email from an email (subject or text) for future use
(pasting). Is there a quick/easy way to do this in Outlook 2003?
(Msg. 2) Posted: Wed Aug 27, 2008 9:12 pm
Post subject: Re: Quick/Easy Way to Copy Data from Email [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Do you want to do that by code? if not, double click the text, then right
click, and choose Copy.
--
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 Wed, 27 Aug 2008 04:50:01 -0700 schrieb G:
> I want to copy email from an email (subject or text) for future use
> (pasting). Is there a quick/easy way to do this in Outlook 2003?
>
> Thanks.
>
> Gary
(Msg. 3) Posted: Thu Aug 28, 2008 5:36 am
Post subject: Re: Quick/Easy Way to Copy Data from Email [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Yes, I wnat to do that by code. Basically, I want to embed some sort of
trigger (in an email?) that copies the data.
Thanks for your response.
"Michael Bauer [MVP - Outlook]" wrote:
>
>
> Do you want to do that by code? if not, double click the text, then right
> click, and choose Copy.
>
> --
> 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 Wed, 27 Aug 2008 04:50:01 -0700 schrieb G:
>
> > I want to copy email from an email (subject or text) for future use
> > (pasting). Is there a quick/easy way to do this in Outlook 2003?
> >
> > Thanks.
> >
> > Gary
>
(Msg. 4) Posted: Sat Aug 30, 2008 9:55 pm
Post subject: Re: Quick/Easy Way to Copy Data from Email [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
By what do you want the trigger to be raised, do you want to copy all the
subject and body, and where do you want to paste it?
--
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 Thu, 28 Aug 2008 05:36:14 -0700 schrieb G:
> Yes, I wnat to do that by code. Basically, I want to embed some sort of
> trigger (in an email?) that copies the data.
>
> Thanks for your response.
>
> "Michael Bauer [MVP - Outlook]" wrote:
>
>>
>>
>> Do you want to do that by code? if not, double click the text, then right
>> click, and choose Copy.
>>
>> --
>> 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 Wed, 27 Aug 2008 04:50:01 -0700 schrieb G:
>>
>>> I want to copy email from an email (subject or text) for future use
>>> (pasting). Is there a quick/easy way to do this in Outlook 2003?
>>>
>>> Thanks.
>>>
>>> Gary
>>
(Msg. 5) Posted: Fri Sep 05, 2008 11:25 am
Post subject: Re: Quick/Easy Way to Copy Data from Email [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Sorry for the delayed response ... on vacation.
- By what do you want the trigger to be raised
## Click of the mouse
- do you want to copy all the subject and body
## Just the subject
- where do you want to paste it
## From the clipboard
Thanks, in advance.
G
"Michael Bauer [MVP - Outlook]" wrote:
>
>
> By what do you want the trigger to be raised, do you want to copy all the
> subject and body, and where do you want to paste it?
>
> --
> 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 Thu, 28 Aug 2008 05:36:14 -0700 schrieb G:
>
> > Yes, I wnat to do that by code. Basically, I want to embed some sort of
> > trigger (in an email?) that copies the data.
> >
> > Thanks for your response.
> >
> > "Michael Bauer [MVP - Outlook]" wrote:
> >
> >>
> >>
> >> Do you want to do that by code? if not, double click the text, then right
> >> click, and choose Copy.
> >>
> >> --
> >> 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 Wed, 27 Aug 2008 04:50:01 -0700 schrieb G:
> >>
> >>> I want to copy email from an email (subject or text) for future use
> >>> (pasting). Is there a quick/easy way to do this in Outlook 2003?
> >>>
> >>> Thanks.
> >>>
> >>> Gary
> >>
>
(Msg. 6) Posted: Sat Sep 06, 2008 2:25 pm
Post subject: Re: Quick/Easy Way to Copy Data from Email [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The Outlook objct model doesn't offer a way to work with the clipboard. If
you add a UserForm to your VBA project, the MSForms library will be
referenced, which in turn offers a DataObject.
After adding the UserForm, please open the object browser (f2), switch from
<All libraries> to MSForms, and select the DataObject left hand, then see
what methods are available right hand.
The subject of the currently opened item is:
Application.ActiveInspector.CurrentItem.Subject
With the DataObject you may write that subject into the clipboard.
--
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 Fri, 5 Sep 2008 11:25:01 -0700 schrieb G:
> Sorry for the delayed response ... on vacation.
>
>
> - By what do you want the trigger to be raised
>
> ## Click of the mouse
>
> - do you want to copy all the subject and body
>
> ## Just the subject
>
> - where do you want to paste it
>
> ## From the clipboard
>
> Thanks, in advance.
>
> G
>
>
>
> "Michael Bauer [MVP - Outlook]" wrote:
>
>>
>>
>> By what do you want the trigger to be raised, do you want to copy all the
>> subject and body, and where do you want to paste it?
>>
>> --
>> 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 Thu, 28 Aug 2008 05:36:14 -0700 schrieb G:
>>
>>> Yes, I wnat to do that by code. Basically, I want to embed some sort
of
>>> trigger (in an email?) that copies the data.
>>>
>>> Thanks for your response.
>>>
>>> "Michael Bauer [MVP - Outlook]" wrote:
>>>
>>>>
>>>>
>>>> Do you want to do that by code? if not, double click the text, then
right
>>>> click, and choose Copy.
>>>>
>>>> --
>>>> 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 Wed, 27 Aug 2008 04:50:01 -0700 schrieb G:
>>>>
>>>>> I want to copy email from an email (subject or text) for future use
>>>>> (pasting). Is there a quick/easy way to do this in Outlook 2003?
>>>>>
>>>>> Thanks.
>>>>>
>>>>> Gary
>>>>
>>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum