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

Make move mean copy..



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 21st 06, 04:41 PM posted to microsoft.public.outlook.program_vba
Slick_lar
external usenet poster
 
Posts: 4
Default Make move mean copy..

My corporation uses Blackberry devices. Moving somethign from my inbox
to a PST folder does not reconcile on teh Blackberry. The reason is
that the Blackberry server does not know where the mail went, so it
leaves it on the device inbox.

I want to take a drag and drop move to a PST and change it into:

1. Copy not move.
2. Mark as read
3. Delete through trash can
4. Permanently delete.

Any ideas or code I can start with?

Thanks

  #2  
Old August 21st 06, 06:02 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Make move mean copy..

I don't understand - why do you want to delete the message as soon as you
copy it?

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

My corporation uses Blackberry devices. Moving somethign from my inbox
to a PST folder does not reconcile on teh Blackberry. The reason is
that the Blackberry server does not know where the mail went, so it
leaves it on the device inbox.

I want to take a drag and drop move to a PST and change it into:

1. Copy not move.
2. Mark as read
3. Delete through trash can
4. Permanently delete.

Any ideas or code I can start with?

Thanks


  #3  
Old August 21st 06, 06:48 PM posted to microsoft.public.outlook.program_vba
Slick_lar
external usenet poster
 
Posts: 4
Default Make move mean copy..

Sorry if I wasn't clear. I want it out of my inbox on both the
Blackberry and on my desktop. If I move it to the PST, it stays on the
BB, Blackberry. If I copy it then delete it from my inbox so that it
goes through my exchange deleted items, the BB knows where it went and
it will remove it from my BB Inbox.

Does that help? Here is a link to a forum with someone having the same
issue I am having. I am trying to get around it with an Outlook macro
of some type.

http://blackberryforums.pinstack.com...ciliation.html

Thanks

Eric wrote:
I don't understand - why do you want to delete the message as soon as you
copy it?

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

My corporation uses Blackberry devices. Moving somethign from my inbox
to a PST folder does not reconcile on teh Blackberry. The reason is
that the Blackberry server does not know where the mail went, so it
leaves it on the device inbox.

I want to take a drag and drop move to a PST and change it into:

1. Copy not move.
2. Mark as read
3. Delete through trash can
4. Permanently delete.

Any ideas or code I can start with?

Thanks



  #4  
Old August 21st 06, 07:22 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Make move mean copy..

Ah, I see. Try this code, which you run after selecting the item in your
Inbox:

Sub CopyMessageAndDeleteOriginal()

Dim objOrig As Outlook.MailItem, objCopy As Outlook.MailItem
Dim objDestinationFolder As Outlook.MAPIFolder

If Application.ActiveExplorer.Selection.count = 0 Or
Application.ActiveExplorer.Selection.count 1 Then Exit Sub

'This will prompt you to choose a folder where you want to copy the
message to
Set objDestinationFolder = Application.GetNamespace("MAPI").PickFolder

If objDestinationFolder Is Nothing Then Exit Sub

Set objOrig = Application.ActiveExplorer.Selection.Item(1)
Set objCopy = objOrig.Copy
objCopy.Move objDestinationFolder
objOrig.Delete

Set objOrig = Nothing
Set objCopy = Nothing
Set objDestinationFolder = Nothing
End Sub

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

Sorry if I wasn't clear. I want it out of my inbox on both the
Blackberry and on my desktop. If I move it to the PST, it stays on the
BB, Blackberry. If I copy it then delete it from my inbox so that it
goes through my exchange deleted items, the BB knows where it went and
it will remove it from my BB Inbox.

Does that help? Here is a link to a forum with someone having the same
issue I am having. I am trying to get around it with an Outlook macro
of some type.

http://blackberryforums.pinstack.com...ciliation.html

Thanks

Eric wrote:
I don't understand - why do you want to delete the message as soon as you
copy it?

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

My corporation uses Blackberry devices. Moving somethign from my inbox
to a PST folder does not reconcile on teh Blackberry. The reason is
that the Blackberry server does not know where the mail went, so it
leaves it on the device inbox.

I want to take a drag and drop move to a PST and change it into:

1. Copy not move.
2. Mark as read
3. Delete through trash can
4. Permanently delete.

Any ideas or code I can start with?

Thanks




  #5  
Old August 21st 06, 09:00 PM posted to microsoft.public.outlook.program_vba
Slick_lar
external usenet poster
 
Posts: 4
Default Make move mean copy..

Great, thanks for the help. I would like some more functionality.

Is it possible to capture and perform this script on a drag and drop to
a PST? The folder name coming from the drag and drop action?

Lastly, can the email be permanently deleted from the trash can after?
It has to delete through the trash can, but can be obliterated once int
eh trash can.

Thanks again for the help.

ls

Eric wrote:
Ah, I see. Try this code, which you run after selecting the item in your
Inbox:

Sub CopyMessageAndDeleteOriginal()

Dim objOrig As Outlook.MailItem, objCopy As Outlook.MailItem
Dim objDestinationFolder As Outlook.MAPIFolder

If Application.ActiveExplorer.Selection.count = 0 Or
Application.ActiveExplorer.Selection.count 1 Then Exit Sub

'This will prompt you to choose a folder where you want to copy the
message to
Set objDestinationFolder = Application.GetNamespace("MAPI").PickFolder

If objDestinationFolder Is Nothing Then Exit Sub

Set objOrig = Application.ActiveExplorer.Selection.Item(1)
Set objCopy = objOrig.Copy
objCopy.Move objDestinationFolder
objOrig.Delete

Set objOrig = Nothing
Set objCopy = Nothing
Set objDestinationFolder = Nothing
End Sub

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

Sorry if I wasn't clear. I want it out of my inbox on both the
Blackberry and on my desktop. If I move it to the PST, it stays on the
BB, Blackberry. If I copy it then delete it from my inbox so that it
goes through my exchange deleted items, the BB knows where it went and
it will remove it from my BB Inbox.

Does that help? Here is a link to a forum with someone having the same
issue I am having. I am trying to get around it with an Outlook macro
of some type.

http://blackberryforums.pinstack.com...ciliation.html

Thanks

Eric wrote:
I don't understand - why do you want to delete the message as soon as you
copy it?

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

My corporation uses Blackberry devices. Moving somethign from my inbox
to a PST folder does not reconcile on teh Blackberry. The reason is
that the Blackberry server does not know where the mail went, so it
leaves it on the device inbox.

I want to take a drag and drop move to a PST and change it into:

1. Copy not move.
2. Mark as read
3. Delete through trash can
4. Permanently delete.

Any ideas or code I can start with?

Thanks





  #6  
Old August 21st 06, 09:23 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Make move mean copy..

It may be possible, but tricky, to trap the Explorer.BeforeItemCopy event.
However, if you tried to delete the original message during that event (which
isn't passed as a parameter, so you'd have to use
ActiveExplorer.Selection(1).CurrentItem), the copy action may not be done in
time. So I'd say no, unless you want to use a Timer class of some sort to
wait and then retrieve the selection and delete it.

In order to permanently delete a message, you'd need to use CDO (see sample
below) or find the message you just deleted in the Deleted Items folder and
delete it again.

Sub PermanentlyDeleteSelectedMesssage()
On Error Resume Next

Dim objSession As MAPI.Session
Dim objMessage As MAPI.Message
Dim objItem As Object

If Application.ActiveExplorer.Selection.count 1 Then GoTo Leave:
Set objItem = Application.ActiveExplorer.Selection.Item(1)
If objItem Is Nothing Then GoTo Leave:

Set objSession = New MAPI.Session
objSession.Logon , , , False
If objSession Is Nothing Then
'Error!
GoTo Leave:
End If

Set objMessage = objSession.GetMessage(objItem.EntryID,
Application.ActiveExplorer.CurrentFolder.StoreID)
Set objMessage = Nothing

Leave:
If Not objSession Is Nothing Then objSession.Logoff
Set objSession = Nothing
Set objItem = Nothing
End Sub

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

Great, thanks for the help. I would like some more functionality.

Is it possible to capture and perform this script on a drag and drop to
a PST? The folder name coming from the drag and drop action?

Lastly, can the email be permanently deleted from the trash can after?
It has to delete through the trash can, but can be obliterated once int
eh trash can.

Thanks again for the help.

ls

Eric wrote:
Ah, I see. Try this code, which you run after selecting the item in your
Inbox:

Sub CopyMessageAndDeleteOriginal()

Dim objOrig As Outlook.MailItem, objCopy As Outlook.MailItem
Dim objDestinationFolder As Outlook.MAPIFolder

If Application.ActiveExplorer.Selection.count = 0 Or
Application.ActiveExplorer.Selection.count 1 Then Exit Sub

'This will prompt you to choose a folder where you want to copy the
message to
Set objDestinationFolder = Application.GetNamespace("MAPI").PickFolder

If objDestinationFolder Is Nothing Then Exit Sub

Set objOrig = Application.ActiveExplorer.Selection.Item(1)
Set objCopy = objOrig.Copy
objCopy.Move objDestinationFolder
objOrig.Delete

Set objOrig = Nothing
Set objCopy = Nothing
Set objDestinationFolder = Nothing
End Sub

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

Sorry if I wasn't clear. I want it out of my inbox on both the
Blackberry and on my desktop. If I move it to the PST, it stays on the
BB, Blackberry. If I copy it then delete it from my inbox so that it
goes through my exchange deleted items, the BB knows where it went and
it will remove it from my BB Inbox.

Does that help? Here is a link to a forum with someone having the same
issue I am having. I am trying to get around it with an Outlook macro
of some type.

http://blackberryforums.pinstack.com...ciliation.html

Thanks

Eric wrote:
I don't understand - why do you want to delete the message as soon as you
copy it?

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Slick_lar" wrote:

My corporation uses Blackberry devices. Moving somethign from my inbox
to a PST folder does not reconcile on teh Blackberry. The reason is
that the Blackberry server does not know where the mail went, so it
leaves it on the device inbox.

I want to take a drag and drop move to a PST and change it into:

1. Copy not move.
2. Mark as read
3. Delete through trash can
4. Permanently delete.

Any ideas or code I can start with?

Thanks






 




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
how to move library Leah S Outlook - General Queries 3 June 7th 06 07:05 AM
Allow copy/move most recent email from a Conversation thread Kumarresen Kannadiapalayam Outlook - Using Contacts 1 May 4th 06 04:18 PM
How i export/copy/move messages in a public folder outlook 2003? Olatunde R. Adeniran Outlook - Using Contacts 1 May 3rd 06 06:51 PM
Can not move or copy message having "flag complete" Vinayakc Add-ins for Outlook 1 February 23rd 06 03:48 PM
Move emails coffeeman Outlook Express 12 February 17th 06 05:22 AM


All times are GMT +1. The time now is 10:42 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.