Forum: Outlook and VBA
August 1st 06, 09:29 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 651
Run a Scipt - Move to folder - Got stuck
Am 31 Jul 2006 23:00:58 -0700 schrieb RosH:
olMail.Move myDestFolder should work.
If you create that folder then you should use the same variable or call
olMail.Move myNewFolder
--
|
|
Forum: Outlook and VBA
August 1st 06, 05:22 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 651
Outlook macro question
Am 31 Jul 2006 10:40:11 -0700 schrieb c mateland:
Here´s a sample how to use the commandbars for setting the account:
http://www.outlookcode.com/codedetail.aspx?id=196
--
Viele Gruesse / Best...
|
|
Forum: Add-ins for Outlook
July 31st 06, 06:42 AM Posted to microsoft.public.outlook.program_addins
|
|
Replies: 5
Views: 1,024
Delete an item
Am Fri, 28 Jul 2006 19:40:02 -0700 schrieb Bob Smith:
Private WithEvents Items As Outlook.Items
Private Sub Application_Startup()
...
|
|
Forum: Outlook and VBA
July 31st 06, 06:37 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 560
Distribution Lists
Am Fri, 28 Jul 2006 22:41:21 -0700 schrieb Dmitry Streblechenko:
plugNext version of Redemption, besides already exposing AddMemberEx
method which takes name and address as parameters, will...
|
|
Forum: Add-ins for Outlook
July 28th 06, 02:39 PM Posted to microsoft.public.outlook.program_addins
|
|
Replies: 5
Views: 1,024
Delete an item
Am Fri, 28 Jul 2006 05:44:02 -0700 schrieb Bob Smith:
Depends on what is "nativly". With the OOM there's no direct way. But using
ItemAdd the item doesn't end up in the deleted items folder - it...
|
|
Forum: Add-ins for Outlook
July 28th 06, 06:32 AM Posted to microsoft.public.outlook.program_addins
|
|
Replies: 5
Views: 1,024
Delete an item
Am Thu, 27 Jul 2006 12:07:02 -0700 schrieb Bob Smith:
You could use CDO 1.21 or Redemption (www.dimastr.com). Or with the Outlook
object model you'd need to track the folder's ItemAdd event and...
|
|
Forum: Outlook and VBA
July 28th 06, 06:26 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 4
Views: 1,502
Saving and Renaming Attachments
Am Thu, 27 Jul 2006 07:42:02 -0700 schrieb csergent:
The MailItem has an Attachment collection. You could loop through that and
save each object with SaveAsFile. That object also has a FileName...
|
|
Forum: Outlook and VBA
July 28th 06, 06:22 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 368
|
|
Forum: Outlook and VBA
July 28th 06, 06:14 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 831
Tasks--Export to MS Access
Am Thu, 27 Jul 2006 12:32:53 -0400 schrieb craigs:
This way you can open a connection to the db:
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider =...
|
|
Forum: Outlook and VBA
July 28th 06, 06:07 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 1,701
|
|
Forum: Add-ins for Outlook
July 27th 06, 06:20 AM Posted to microsoft.public.outlook.program_addins
|
|
Replies: 2
Views: 788
Add-in Send Script
Am Wed, 26 Jul 2006 14:18:01 -0700 schrieb Bob Smith:
Bob, "Application" is the object to declare and "ItemSend" is one of its
events, which you can use after the declaration.
The statement...
|
|
Forum: Outlook and VBA
July 27th 06, 06:13 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 8
Views: 1,441
MAPIMESSAGE Setting Sensitivity to Confidential
Am Wed, 26 Jul 2006 07:41:01 -0700 schrieb Ian Fry:
Regarding the Enum values Ken wrote &H3 would be:
&H1 OR &H2
That is, both flags are set.
--
Viele Gruesse / Best regards
Michael Bauer - MVP...
|
|
Forum: Outlook and VBA
July 27th 06, 06:05 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 666
Change event to a repeating event
Am Wed, 26 Jul 2006 12:48:49 -0400 schrieb John Marshall, MVP:
John, loop through the folder´s items and call that sample for each item
that you´d like to change:
Private Sub...
|
|
Forum: Outlook and VBA
July 27th 06, 05:55 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 752
script to parse ip addresses from outlook headers
Am Wed, 26 Jul 2006 17:29:13 -0700 schrieb JTL:
Reading sender´s address depends on the Outlook version. In OL = XP you´d
need e.g. CDO 1.21 or Redemption (www.dimastr.com) to do that. With CDO...
|
|
Forum: Outlook and VBA
July 27th 06, 05:47 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 2,193
|
|
Forum: Outlook and VBA
July 26th 06, 06:02 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,623
|
|
Forum: Outlook and VBA
July 25th 06, 02:24 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 727
If not found?
Am 25 Jul 2006 01:58:12 -0700 schrieb vortex2k4:
Please try this one:
tms.Find ("[Subject] " & chr(34) & Newmsgarray(i) & chr(34))
--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
...
|
|
Forum: Outlook and VBA
July 25th 06, 02:21 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,141
Need a script to OPEN and then save as .msg
Am 25 Jul 2006 05:56:13 -0700 schrieb :
Why don´t you just create a new PST and copy all items or folders into that
manually? That´s done in just a few minutes.
--
Viele...
|
|
Forum: Outlook and VBA
July 25th 06, 05:40 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 558
Outlook
Am Mon, 24 Jul 2006 10:21:01 -0700 schrieb :
I suppose no one here understands your language. This is an English speaking
group. Please translate or try another group...
|
|
Forum: Outlook and VBA
July 25th 06, 05:18 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 2,864
ArrayList or equiv in VBA?
Am 24 Jul 2006 18:11:42 -0700 schrieb :
You can use collections:
Dim col as VBA.Collection
Set col=New VBA.Collection
or an array, e.g. for 10 items (0 to 9):
Dim...
|
|
Forum: Outlook and VBA
July 24th 06, 05:28 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,623
|
|
Forum: Outlook and VBA
July 24th 06, 05:22 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 593
Saving attcahments to a folder with a rule.
Am 23 Jul 2006 21:06:48 -0700 schrieb :
For new incoming e-mails you can use the ItemAdd event of the Inbox. With
Instr you can check for a substring of the item´s Subject...
|
|
Forum: Outlook and VBA
July 21st 06, 05:29 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 464
I Need A (kind of) Dangerous Macro
Am Thu, 20 Jul 2006 09:19:02 -0700 schrieb Jimboluke:
You could use the follwing template to walk through all the folders. For
starting at the top level you´d call it e.g. with:
LoopFolders...
|
|
Forum: Outlook and VBA
July 20th 06, 05:34 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,232
Outlook Calendar to open on Startup
Am Wed, 19 Jul 2006 05:59:02 -0700 schrieb dmc:
In Outlook´s option dialog you can determine which folder to show when
Outlook starts. If you additionally want to start Outlook on Windows...
|
|
Forum: Outlook and VBA
July 19th 06, 05:37 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,232
Outlook Calendar to open on Startup
Am Tue, 18 Jul 2006 13:24:02 -0700 schrieb dmc:
Tools/Options/Advanced/Adcaned Options/Folder at startup (or similar).
--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
--...
|
