Forum: Outlook - Calandaring
June 3rd 10, 08:24 AM Posted to microsoft.public.outlook.calendaring
|
|
Replies: 1
Views: 2,800
Statistics on usage of meeting rooms
Outlook can't do that itself. Please see VBOffice Reporter (link in my
signature). You can use it for a report on how many appointments there are,
and to sum up the duration.
--
Best...
|
|
Forum: Outlook and VBA
June 3rd 10, 08:14 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 1,322
Save Current email in Directory.
So far it's hard to say what you're missing.
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Easily share your categories:
SAM - Automatically choose sending account, signature,...
|
|
Forum: Outlook - Calandaring
May 28th 10, 06:01 AM Posted to microsoft.public.outlook.calendaring
|
|
Replies: 2
Views: 1,511
|
|
Forum: Outlook and VBA
May 28th 10, 05:56 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 801
can you do this with Outlook?
For instance, you could add all the addresses to a contacts folder, and in
the ItemSend event check whether or not the recipient of the email is stored
in that folder.
--
Best regards
Michael Bauer...
|
|
Forum: Outlook - Calandaring
May 22nd 10, 09:06 AM Posted to microsoft.public.outlook.calendaring
|
|
Replies: 3
Views: 1,934
Calendar Default Category
This VBA example does it:
http://www.vboffice.net/sample.html?mnu=2&smp=76&cmd=showitem&lang=en
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Easily share your categories:
SAM...
|
|
Forum: Outlook - Using Contacts
May 22nd 10, 05:48 AM Posted to microsoft.public.outlook.contacts
|
|
Replies: 1
Views: 672
Mark contact as someone not to contact again
If you want to keep the item in your contacts folder but never want to call
him or send emails to the contact, you could assign categories like
"active", and "no contact". Then group the view by...
|
|
Forum: Outlook and VBA
May 22nd 10, 05:30 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,435
VBA coding
What is the difference between a timer event and an event raised by an
appointment item?
If you'd use the appointment, especially with such a long interval of once a
week, Outlook would handle the...
|
|
Forum: Outlook and VBA
May 22nd 10, 05:23 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 867
add a date without holidays
For adding days, use the DateAdd function. It won't return an invalid date
like 31/5.
The Weekday function returns the number of the day, for instance this
Weekday("22.05.2010"...
|
|
Forum: Outlook and VBA
May 21st 10, 08:47 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,435
VBA coding
Here's an example for how to do it in Outlook:
http://www.vboffice.net/sample.html?lang=en&mnu=2&smp=10&cmd=showitem
The code won't execute if Outlook isn't running.
--
Best regards
Michael Bauer...
|
|
Forum: Outlook and VBA
May 21st 10, 08:41 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 1,277
|
|
Forum: Outlook and VBA
May 20th 10, 10:08 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 986
vba timing
In this function replace
Public Sub SaveEmailAttachmentsToFolder(OutlookFolderInInbox As
String, ExtString As String, DestFolder As String)
by
Public Sub SaveEmailAttachmentsToFolder(Item as...
|
|
Forum: Outlook and VBA
May 19th 10, 08:04 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,814
Mark copy of sent email as read - VBA?
Put the code into the module ThisOutlookSession, and add this:
Private Sub Application_Startup()
Initialize_handler
end Sub
Application_Startup is the procedure called by Outlook at startup, and...
|
|
Forum: Outlook and VBA
May 18th 10, 07:54 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 4
Views: 1,049
Macro to speed email creation
For instance, for OL07 right click the toolbar of the email window, then
Edit Quick Access Toolbar (or similar). Select macros, then drag the macro's
name to the pane right hand.
--
Best...
|
|
Forum: Outlook and VBA
May 18th 10, 07:51 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 7
Views: 950
send mail every days
What happens if you walk through the code step by step? For that set a
breakpoint on the first line, and use f8 after the code execution has
stopped at that line.
--
Best regards
Michael Bauer -...
|
|
Forum: Outlook and VBA
May 18th 10, 07:46 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,814
Mark copy of sent email as read - VBA?
The event you're looking for is the ItemAdd event of the folder for sent
items. That event fires when an item is added to the folder. There's an
example available in the VBA help file.
The added...
|
|
Forum: Outlook and VBA
May 18th 10, 07:43 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 986
vba timing
In TestSave you already have a reference to the email (see the msg
variable). Pass that to the SaveEmailAttachmentsToFolder procedure, and
handle only that one item. Then you don't need to loop...
|
|
Forum: Outlook and VBA
May 16th 10, 09:31 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 13
Views: 2,707
|
|
Forum: Outlook and VBA
May 16th 10, 09:28 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 778
|
|
Forum: Outlook and VBA
May 16th 10, 09:27 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 7
Views: 950
send mail every days
This might help you:
http://www.vboffice.net/sample.html?lang=en&mnu=2&smp=10&cmd=showitem
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM...
|
|
Forum: Outlook and VBA
May 14th 10, 08:21 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 4
Views: 1,049
Macro to speed email creation
You can access the email via
Application.ActiveInspector.CurrentItem
It has a Body, and a Subject property, and an Attachments.Add funtion. For
an example see the VBA help file.
--
Best...
|
|
Forum: Outlook - Calandaring
May 13th 10, 11:30 AM Posted to microsoft.public.outlook.calendaring
|
|
Replies: 1
Views: 3,966
Reporting on Outlook Calendar Categories
Please see if VBOffice Reporter meets your needs:
http://www.vboffice.net/product.html?lang=en
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
...
|
|
Forum: Outlook and VBA
May 13th 10, 11:13 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 4
Views: 998
|
|
Forum: Outlook and VBA
May 13th 10, 11:12 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 865
Insert Text and Send
This example demonstrates how to change the Subject of a reply:
http://www.vboffice.net/sample.html?mnu=2&smp=9&cmd=showitem&lang=en
you can write your text into the Body or HTMLBody property.
--...
|
|
Forum: Outlook and VBA
May 13th 10, 11:09 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 774
|
|
Forum: Outlook and VBA
May 12th 10, 09:25 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 757
Warning message
You might also look on www.slipstick.com. There're are ready-to-use Addins
for that available.
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
...
|
