|
| 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
June 21st 07, 12:29 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Move MailItem
In VBA Outlook 2003, I simply want a macro to run and pass through a inbox
subfolder ("X"), test to see if there is an attachment. If there is, I want to move the mailitem to subfolder ("Y"). Is there a straightforward way to do this? Thanks. 
|
| Ads |
|
#2
June 21st 07, 07:07 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Move MailItem
You need to loop backwards through that folder's items (with a For i=Count To 1 step-1 loop). A MailItem object has an Attachments property which in turn has a Count property. If that propertie's value is 0 then call that MailItem's Move method, which is explained in the VBA help. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Organize Outlook email: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Wed, 20 Jun 2007 15:29:48 -0700 schrieb John Tripp: In VBA Outlook 2003, I simply want a macro to run and pass through a inbox subfolder ("X"), test to see if there is an attachment. If there is, I want to move the mailitem to subfolder ("Y"). Is there a straightforward way to do this? Thanks.
|
|
#3
June 22nd 07, 06:07 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Move MailItem
Thanks, I got it working pretty well. The problem I was having was
When I input "mailitem.move" in word 2003 I got no matches. I solved my problem by putting "mailitem.move" into word XP on a different machine. Got all the syntax and got it working. Thanks again "Michael Bauer [MVP - Outlook]" wrote: You need to loop backwards through that folder's items (with a For i=Count To 1 step-1 loop). A MailItem object has an Attachments property which in turn has a Count property. If that propertie's value is 0 then call that MailItem's Move method, which is explained in the VBA help. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Organize Outlook email: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Wed, 20 Jun 2007 15:29:48 -0700 schrieb John Tripp: In VBA Outlook 2003, I simply want a macro to run and pass through a inbox subfolder ("X"), test to see if there is an attachment. If there is, I want to move the mailitem to subfolder ("Y"). Is there a straightforward way to do this? Thanks.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Delete MailItem | j | Add-ins for Outlook | 5 | January 25th 07 07:47 PM |
| MailItem.Move changes Received Date | Frank Perugini | Outlook and VBA | 1 | January 22nd 07 12:27 AM |
| MailItem.Move changes Received Date | Frank Perugini | Add-ins for Outlook | 1 | January 22nd 07 12:27 AM |
| MailItem flags | Gary E. | Outlook and VBA | 8 | January 18th 07 01:11 AM |
| How can I create a MailItem that displays like a received MailItem ? | Clive | Outlook - Using Forms | 0 | February 27th 06 05:14 PM |
Linear Mode
