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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Showing results 1 to 25 of 250
Search took 0.27 seconds.
Search: Posts made by: Michael Bauer
Forum: Outlook and VBA August 1st 06, 09:29 AM Posted to microsoft.public.outlook.program_vba
Replies: 1
Views: 644
Posted By Michael Bauer
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: 628
Posted By Michael Bauer
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: 998
Posted By Michael Bauer
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: 541
Posted By Michael Bauer
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: 998
Posted By Michael Bauer
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: 998
Posted By Michael Bauer
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,470
Posted By Michael Bauer
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: 353
Posted By Michael Bauer
Selecting Spreadsheet Cell Information for e-mail

Am Thu, 27 Jul 2006 07:53:02 -0700 schrieb csergent:

Please add a ref to Excel to your Outlook VBA project (via
Tools/References). Then you can see Excel's objects, methods etc. in the
Object...
Forum: Outlook and VBA July 28th 06, 06:14 AM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 807
Posted By Michael Bauer
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,672
Posted By Michael Bauer
script to clear out categories on incoming emails

Am 27 Jul 2006 13:37:22 -0700 schrieb :

Did you write that code into the module "ThisOutlookSession"? Additionally,
the security setting must be medium at least to allow scripts,...
Forum: Add-ins for Outlook July 27th 06, 06:20 AM Posted to microsoft.public.outlook.program_addins
Replies: 2
Views: 765
Posted By Michael Bauer
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,402
Posted By Michael Bauer
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: 638
Posted By Michael Bauer
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: 743
Posted By Michael Bauer
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,171
Posted By Michael Bauer
Sort Outlook emails by domain names of sender (grouped together)

Am Wed, 26 Jul 2006 18:53:01 -0700 schrieb Arthur Van Buren:

Arthur, you could add a UserProperty to each e-mail and write the domain
name into that. By that field you can sort.

--
Viele Gruesse /...
Forum: Outlook and VBA July 26th 06, 06:02 AM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 1,603
Posted By Michael Bauer
VBA to list all created PST file name/location in personal fol

Am Tue, 25 Jul 2006 06:26:03 -0700 schrieb Pitak:

Easy it´s with the Redemption from www.dimastr.com. You can iterate through
the stores, then read the RDOStore.StoreKind property.

Via Outlook...
Forum: Outlook and VBA July 25th 06, 02:24 PM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 717
Posted By Michael Bauer
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,106
Posted By Michael Bauer
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: 546
Posted By Michael Bauer
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,850
Posted By Michael Bauer
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,603
Posted By Michael Bauer
VBA to list all created PST file name/location in personal folder

Am Sat, 22 Jul 2006 04:43:01 -0700 schrieb Pitak:

Do you mean the PSTs listed in your Outlook profile?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --
Forum: Outlook and VBA July 24th 06, 05:22 AM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 579
Posted By Michael Bauer
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: 447
Posted By Michael Bauer
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,208
Posted By Michael Bauer
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,208
Posted By Michael Bauer
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
--...
Showing results 1 to 25 of 250

 
Forum Jump

All times are GMT +1. The time now is 02:11 AM.


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