| Thread | Last Author | Messages
read/total | Date |
|---|
| VBA to assign category on calendar item does not work ?? why ?? |
Michael Bauer [MVP - ... |
0 / 5 |
22 Dec 2009 |
| If you want the function to ignore lower/upper cases, use the start
parameter and vbTextCompare:
pos=Instr(1, Item.Subject, "vrij", vbTextCompare)
Are you sure, "vrij" doesn't start at the beginning of the Subject? If it
does, the function would return 1, and that is not > 1.
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.... |
| Outlook 2003, Rules and Alerts, Script |
Andy Smith |
0 / 1 |
22 Dec 2009 |
| Sue -- or anyone else: is there really no way to create rules and alerts,
change their parameters, or even examine them in code? There's no way to
enumerate the rules and dump all their parameters to a text file, for
example? Is it really all hidden away? How then is the Rules Wizard
implemented?
--
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC
"Sue Mosher... |
| Running a rule in a different folder |
Andy Smith |
0 / 1 |
22 Dec 2009 |
| Eric -- or anyone else: is there really no way to create rules and alerts,
change their parameters, or even examine them in code? There's no way to
enumerate the rules and dump all their parameters to a text file, for
example? Is it really all hidden away? How then is the Rules Wizard
implemented?
--
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC
"Eric... |
| Making custom Outlook 2007 folders emptiable like "Deleted Items" |
Ken Slovak - [MVP - O... |
0 / 2 |
22 Dec 2009 |
| Use the Application.FolderContextMenuDisplay() event. You will need to add a
CommandBarButton object to the CommandBar passed to you in that event
handler, so you will need to add a new menu entry when the event fires.
Your code then will have to iterate the folder's contents and delete
everything in the folder, then it will need to delete everything moved from
the folder to the... |
| VBA to assign category on calendar item does not work ?? why ?? |
PGT |
0 / 1 |
22 Dec 2009 |
| Below i wrote code to assign a categorie to a calendar item based on the word "vrij" in the subject.
I got to automate a lot of words for a lot of people so this just the first keyword.
I think this code should work.. but somehow it doesnt
I use Outlook 2003 with macro security set to lowest level. The code is placed in "this outlook session"
Any ideas why it doesnt work ??
>... |
| Question on add-in interception with Outlook functionality |
paresh |
0 / 14 |
22 Dec 2009 |
| I got it. It has to something to do with Wwlib.dll that handles HTML
rendering for Outlook and Word is having difficulty in parsing certain
messages(has lot of special symbols) and ends up looping indefinitely. We
have logged case with M$ and they are going to provide hotfix for this.
Thanks.
"Ken Slovak - [MVP - Outlook]" wrote:
> There's probably something corrupted in that... |
| ListIndex problems, |
Mr. GetRight |
0 / 1 |
21 Dec 2009 |
| Hey, on the below code, I am having problems. i dont know why it is not
selecting the same row in list box 101 as in listbox 102
Sub Item_CustomPropertyChange(ByVal ListBox101)
Set ListBox101 = Item.UserProperties("ListBox101")
Set ListBox102 = Item.UserProperties("ListBox102")
ListBox102.ListIndex = ListBox101.ListIndex
End Sub... |
| Using Bookmarks and User Form within Outlook |
RPMitchal |
0 / 4 |
21 Dec 2009 |
| Michael and Sue:
Thank you both very much. I can't tell you how much I appreciate all that
you "Gurus" do. :-)
Rod
"Sue Mosher [MVP]" wrote:
> Use the Application.ActiveInspectort.WordEditor method to return a
> Word.Document object from the currently open message.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for... |
| Sending a copy of an incoming email to a network folder |
JP |
0 / 2 |
21 Dec 2009 |
| Since you want it to be saved automatically, you'll need an event
handler. See http://www.codeforexcelandoutlook.com/outlook-vba/stock-event-code/
for starter code.
To save the message, use the MailItem.SaveAs method.
http://msdn.microsoft.com/en-us/library/aa210279(office.11).aspx
Since the folder name is determined by the subject, you'll need to
check the server for a folder with... |
| set calendar coloring filters through VBA |
Ken Slovak - [MVP - O... |
0 / 3 |
21 Dec 2009 |
| For Outlook 2003 and earlier you can't do what you want.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"PGT" <user@msgroups.net/> wrote in message
news:eY4I7glgKHA.5564@TK2MSFTNGP06.phx.gbl...
>I also couldnt find it in... |
| set calendar coloring filters through VBA |
PGT |
0 / 1 |
21 Dec 2009 |
| I also couldnt find it in registry (used regmon to trace for it). Apperently it is stored in the mailbox.. but where?, and how to access it CDO maybe ?
---
frmsrcurl: http://msgroups.net/microsoft.public.outlook.program_vba/set-calendar-coloring-filters-through-VBA... |
| Macro for Viewing mails one after the other in the Reading Pan |
san |
0 / 3 |
21 Dec 2009 |
| Thanks for your reply....
Is there any other alternative or workaround to do the same thing in Outlook
2003/2007 ?
"Michael Bauer [MVP - Outlook]" wrote:
>
>
> Before OL2010 you cannot select an item in a folder by code.
>
> --
> Best regards
> Michael Bauer - MVP Outlook
> Manage and share your categories:
> <http://www.vboffice.net/product.html?pub=6&lang=en>
>
>... |
| I Found it -->item.recipients.item(i).AddressEntry |
Shreekanth Murali |
0 / 5 |
20 Dec 2009 |
| Hey I found it
its item.recipients.item(i).AddressEntry
THANKS A LOT FOR YOUR INFORMATION.
Shreekanth Murali wrote:
item.recipients.Count
20-Dec-09
item.recipients.Count gives me number of recipients in the mail. How can i get the details of that . What should i user.
eg: I have three email address in to field and for testing purpose i wrote msgbox(item.recipients.... |
| Try OutLock |
Robert Bollinger |
0 / 3 |
20 Dec 2009 |
| http://www.brothersoft.com/outlock-for-outlook-28886.html
ND Pard wrote:
VBA Procedure (or Macro) to Stop Outlook from Closing?
10-Dec-09
I am new to using Outlook, but have written many Access and Excel VBA
procedures.
Often, I unintenionally click the "X" close button in the upper right corner
of the application.
Outlook provides a dialog box that states, "Are you sure... |
| using macro for sending multiple mail in outlook |
Michael Bauer [MVP - ... |
0 / 2 |
18 Dec 2009 |
| See the CreateItem function in the VBA help file, which can be used to
create a new email. For the email you can set properties like Subject, Body,
Recipient etc.
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>
Am Fri, 18 Dec 2009 06:25:01 -0800 schrieb Hatice Başak YILDIROÖ:
> Hello,... |
| Time calculation problem |
Michael Bauer [MVP - ... |
0 / 4 |
18 Dec 2009 |
| With Debug.Print you can print the values of end2 and start1 (ctrl+g). I
doubt they really change.
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>
Am Thu, 17 Dec 2009 18:14:09 -0500 schrieb bear:
> Hello
>
> Tried DateDiff("h", [end2], [start1]). Did not work, it is constantly
shows... |
| Creating an Outlook 2007 macro that attaches a signature to new me |
Michael Bauer [MVP - ... |
0 / 2 |
17 Dec 2009 |
| 1) See the NewInspector event.
2) http://www.outlookcode.com/article.aspx?id=28
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>
Am Wed, 16 Dec 2009 03:05:02 -0800 schrieb IDC:
> Hi, I'm new to macro creation and have several questions. I created code
that
> adds a random signature to... |
| Problem in permanent type add-in toolbar |
paresh |
0 / 7 |
17 Dec 2009 |
| Thanks that makes perfect sense to me but I think I don't need to write
wrapper class for explorer as my requirements are very simple and nothing is
shared between the toolbar clicks that might cause the issue.
What all I want is to put toolbar whenever new explorer open and perform the
operation when button click.
Thanks a lot for your help.
Paresh
"Ken Slovak - [MVP -... |
| Using Access to obtain E-mail address |
Ken Slovak - [MVP - O... |
0 / 6 |
16 Dec 2009 |
| Yes, an email address is a string (text), but you indicated that you were
seeing a null string. Obviously that won't work.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"JIMC5499" <JIMC5499@discussions.microsoft.com> wrote in... |
| Programming Outlook from MS Access (Inbox) |
JP |
0 / 2 |
15 Dec 2009 |
| ... |
| Problem in temporary type toolbar |
Michael Bauer [MVP - ... |
0 / 2 |
15 Dec 2009 |
| Why don't you test whether your toolbar exists already? And as to the
position, you need to store that anywhere, for instance, in the registry,
and reload it when you create the toolbar.
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>
Am Tue, 15 Dec 2009 01:46:02 -0800 schrieb paresh:
>... |
| After resizing Custom Task Pane "BeforeFolderSwitch" Event handler stopps bei... |
Ken Slovak - [MVP - O... |
0 / 12 |
14 Dec 2009 |
| Understanding the operation and limitations of the garbage collector,
especially for COM objects, is difficult to figure out at first.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"escamoteur" <mail@burkharts.net> wrote in... |
| Autosending emails. |
Heera Chavan |
0 / 3 |
14 Dec 2009 |
| Any other way....can we install any add-in to triger that?????
Basically i want to trap the login date & time........ |
| Costa Ricas Real Estate |
Bret G Dudl |
0 / 1 |
14 Dec 2009 |
| ... |
| MailItem object has no property for when a reply was sent |
mmoore |
0 / 4 |
13 Dec 2009 |
| Hi Michael,
I finally understand. I installed OutlookSpy & saw that the last verb was
reply to sender. Then I noticed that the time shown in the property isn't
entirely different. It's different by exactly 8 hours. My time zone is 8
hours off GMT.
Problem solved. Thanks for your help.
Thank you, Mike
-----------------
"Michael Bauer [MVP - Outlook]" wrote:
>
>
> Since... |
| move folders in outlook using vba |
Sue Mosher [MVP] |
0 / 2 |
13 Dec 2009 |
| > how do you identify the current folder
Application.ActiveExplorer.CurrentFolder
> and then how do you move it
When in doubt, check the object browser: Press ALt+F11 to open the VBA
environment in Outlook, then press F2. Switch from <All Libraries> to
Outlook to browse all Outlook objects and their properties, methods, and
events. Select any object or member, then press F1 to... |
| trust access to visual basic project greyed out in outlook 2003 |
JP |
0 / 2 |
11 Dec 2009 |
| ... |
| Can I set a specific account for sending a message ? |
Sue Mosher [MVP] |
0 / 2 |
11 Dec 2009 |
| Outlook 2007 adds a MailItem.SendUsingAccount property.
For earlier versions, Outlook provides no direct way to change the account
for an outgoing message. These are known workarounds using native Outlook
functionality:
1) If the user has Outlook 2003 and is not using WordMail as the editor, you
set the sending account using CommandBars techniques. See
http://www.outlookcode.... |
| exception when I call ActiveDocument.Range(0,0).Editors.Add(-1 |
Tom |
0 / 3 |
10 Dec 2009 |
| The exception is "[object Error]".
"Michael Bauer [MVP - Outlook]" wrote:
>
>
> And what does the message of the exception tell you?
>
> --
> Best regards
> Michael Bauer - MVP Outlook
>
> : Outlook Categories? Category Manager Is Your Tool
> : VBOffice Reporter for Data Analysis & Reporting
> : <http://www.vboffice.net/product.html?pub=6&lang=en>
>
>
> Am Wed, 9... |
| CustomTaskPane in PLace of Reading Pane |
escamoteur |
0 / 4 |
10 Dec 2009 |
| Hi,
I found out how to do it. But as this Formregion is only displayed when an Item is selected, I think I will go for the Task Panel,
even if it's a bit too big.
Thanks
Best
Tom
"escamoteur" <mail@burkharts.net> schrieb im Newsbeitrag news:6CFBA85E-6C13-4455-9E95-8F634CEAE706@microsoft.com...
> Do you have any link how to use a form region to replace the preview pane?
>
>... |
| Maintain Outlook Distribution List from Access |
SoCal Rick |
0 / 3 |
09 Dec 2009 |
| Hi Sue,
First, thank you for responding to my question.
The Outlook version we use is Outlook 2003(11.8313.8221) SP3. I do most of
my work in Excel and Access, so I don't have much experience with Outlook.
An option available, but I haven't tried it with this quantity, is to
maintain the mailing lists in the Access database. When the user wants to
send a message to everyone on... |
| Retrieve Meeting Response Text Associated with an Appointment |
Michael Bauer [MVP - ... |
0 / 2 |
09 Dec 2009 |
| If haven't checked it, but I think you need to look at the emails, i.e.
responses, you've received in order to get the body.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>
Am Tue, 8 Dec 2009 01:00:01 -0800 schrieb... |
| Adding automaticly recipents-Outlook 2007 |
Michael Bauer [MVP - ... |
0 / 2 |
08 Dec 2009 |
| See the AttachmentAdd event of the Mailitem. With that it should work.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>
Am Mon, 7 Dec 2009 10:43:02 -0800 schrieb אלעד:
> Hi.
> I want to know how to do the next... |
| book with basics of using vba ? |
Sue Mosher [MVP] |
0 / 7 |
08 Dec 2009 |
| My latest book is available in both hard-copy and Kindle versions, plus an
electronic version (that looks quite costly) from
http://www.sciencedirect.com/science/book/9781555583460. You can also search
for particular topics in it at Google Books.
VBA is the same in every Office application. My books cover the VBA basics
that are most useful for Outlook programming. If you need a... |
| Outlook 2003 macro security problem |
John Blessing |
0 / 7 |
07 Dec 2009 |
| Ok, thanks for trying
John
Sue Mosher [MVP] wrote:
> Sorry, but I have no ideas on what to do about that.
>
> "John Blessing" <nospam.lbe@REMOVE_THISgmail.com> wrote in message
> news:4b1d2ff4$0$2525$da0feed9@news.zen.co.uk...
>> No COM add-ins, no anti-virus integration. safe:2/3/4 make no
>> difference There is an "Exchange extensions property pages" listed in
>> the
>>... |
| Rule to Forward email but delay delivery 10 minutes |
Jake |
0 / 3 |
07 Dec 2009 |
| Good point. I'll check over at the Exchange Group. Thanks Michael.
-Jake... |
| Using the CurrentFolder property |
Sue Mosher [MVP] |
0 / 4 |
04 Dec 2009 |
| No, but you can modify any toolbar in the main Outlook window to add a macro
and give it an Alt+ accelerator key by putting an ampersand & in front of
the character you want to use for the accelerator.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54... |
| use only views defined for this folder |
escamoteur |
0 / 3 |
04 Dec 2009 |
| Thanks!
That was exactly the Property I was looking for!
Best
Tom
"Sue Mosher [MVP]" <suemvp@gmail.com> schrieb im Newsbeitrag news:uY1njZOdKHA.2164@TK2MSFTNGP02.phx.gbl...
> Take a look at the Folder/MAPIFolder object and its CustomViewsOnly
> property.
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and... |
| Can I use a macro within Outlook ? |
Roger |
0 / 3 |
04 Dec 2009 |
| Great, thanks
Roger
"Sue Mosher [MVP]" <suemvp@gmail.com> wrote in message
news:uJh7jZOdKHA.2164@TK2MSFTNGP02.phx.gbl...
> Yes, Outlook has a VBA environment, accessed just like that in other
> applications with Alt+F11 or Tools | Macros | VBA. These pages can help
> you get started:
>
> http://www.outlookcode.com/article.aspx?id=49
> http://www.outlookcode.com/article.... |
| modify New mesage SEND button |
JP |
0 / 2 |
04 Dec 2009 |
| ... |
| Usage Policy Notice pop-up |
Sue Mosher [MVP] |
0 / 3 |
03 Dec 2009 |
| You could do that with an add-in, but after the first couple of views, users
will just click through. I'd call it a productivity waster.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"TQIT" <TQIT@discussions.microsoft.com> wrote in message... |
| Outlook File Attachment Based on Contact Name |
Ken Slovak - [MVP - O... |
0 / 6 |
03 Dec 2009 |
| You don't get a COM addin, you develop it. It can be done using VB.NET, C#,
VB6, Delphi and various other languages. If you aren't familiar with any of
the languages like that and don't have access to some version of Visual
Studio or other development platform you might consider hiring someone to
write the code for you.
As I said, search on that Web site for information on ItemSend.... |
| How to obtain the Distribution List of a Sender |
Dmitry Streblechenko |
0 / 5 |
02 Dec 2009 |
| Actually on the MAPI level, PR_EMS_AB_IS_MEMBER_OF_DL property can be
retrieved as IMAPITable. It will list all the DLs that the giveb user is a
member of.
<plug>
Redemption exposes PR_EMS_AB_IS_MEMBER_OF_DL as
theRDOAddressEntry.IsMemberOfDL property -
http://www.dimastr.com/redemption/rdo/RDOAddressEntry.htm
set Session = CreateObject("Redemption.RDOSession")
Session.... |
| 14 COMPRAR CARTUCHOS NINTENDO DSI R4I,EzFLASH |
tesddalw |
0 / 1 |
02 Dec 2009 |
| Visitanos en www.Dsiconsolas.com
COMPRAR R4I Dsi en www.Dsiconsolas.com COMPRAR R4I-SDHC.COM en www.Dsiconsolas.com
COMPRAR M3i Zero en www.Dsiconsolas.com
COMPRAR EZFLASH VI www.Dsiconsolas.com
VEnPj$!+?+$*LtD#bMJ#Bzbiq... |
| GAL program acces in outlook 2007 |
Guille |
0 / 3 |
01 Dec 2009 |
| About your questin, yes im using the same user in both cases.
When i try to access GAL the program logs with the RED user, but, with any
other ser it conects normaly in Outlook 2003 and when i try to ejecute the
same macro in Outlook 2007 it keeps getting me the error.
"Dmitry Streblechenko" wrote:
> Are you logged as as the same user and accessing the same mailbox in both
> cases?... |
| Outlook 2007 SQL syntax to filter views of tasks and todo items |
Ken Slovak - [MVP - O... |
0 / 2 |
01 Dec 2009 |
| The DASL MAPI tags look OK to me for Completed = false plus the conditions
for categories and your UDF.
Is that UDF defined so that it's a field in the folder where you are
filtering? Perhaps also including a clause that tests for the UDF existing
might be helpful.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder... |
| Better way of writing Macro? Identify multiple types of attac |
Sue Mosher [MVP] |
0 / 6 |
01 Dec 2009 |
| I would suggest that you analyze each loop for what it does and write it out
in "pseudocode" -- i.e. focusing on the operations and decision points, as
in a flow chart, without worrying about the actual code syntax. If you do
that, you should see where you can consolidate.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and... |
| Reading Recipients in a folder |
Sue Mosher [MVP] |
0 / 2 |
01 Dec 2009 |
| Recipients is a collection, not a string property:
Set recips = obj.Recipients
For Each recip in Recips
MsgBox recip.Address
Next
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Neil Perry" <NeilPerry@discussions.microsoft.com>... |
| Losing format after any movement on the folder |
Alberto |
0 / 3 |
01 Dec 2009 |
| Thanks Ken
- It works fine with ActiveExplorer.CurrentView.
- By translating my code to make it more readble i confused a line and
that's why Vista.apply shouldn't have appeared this way but that wasn't the
problem.
"Ken Slovak - [MVP - Outlook]" wrote:
> What is Vista.Apply?
>
> Why not use ActiveExplorer.CurrentView?
>
> --
> Ken Slovak
> [MVP - Outlook]
>... |
| How to make money through the post |
rj |
0 / 1 |
01 Dec 2009 |
| How to make money through the post
HOW TO MAKE THOUSANDS IN LESS THAN A MONTH!!!!!!!!!!!!!
MAKE EASY AND QUICK CASH MONEY by doing almost nothing (NO JOKE, NO SCAM,
AND VERY LEGAL) Please read on! You will be very thankful you did! A little
while back, I was browsing through newsgroups, just like you are now, and
came across an article similar to this that said you could make... |