ThreadLast AuthorMessages
read/total
Date
having a sent e-mail expire at the recipients after it is read
Michael Bauer [MVP - ...
0 / 2 18 Nov
You can set the expiry only by date. -- 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, 17 Nov 2008 13:11:01 -0800 schrieb KODA: > can someone show me a good way to do this?...
Incorrect received date on some messages (using Redemption)
Ken Slovak - [MVP - O...
0 / 10 18 Nov
Then I'm not sure. I'd probably experiment with getting the DateTime values and using ToUTC() and play with that for a while to see if things are being converted as expected and also try converting back, as well as trying the MAPIUtils methods for local to UTC and UTC to local to make sure everything is being converted both ways as expected. -- Ken Slovak [MVP - Outlook]...
Code pause when disconnecting from Terminal Services.
Trefor
0 / 1 18 Nov
I am running some code on a Windows XP PC using Office 2003 and I am connecting to this PC via Remote Desktop (Terminal Services). While I am connected everything appears to be fine, but if I disconnect and leave the remote PC to run by itself I get issues. This code is in an Excel Module that processes emails from an Outlook folder, so I am not sure if this is an Excel issue or an...
Address Book Control?
Nathan
0 / 4 18 Nov
I think I could resolve my problem this time. O(&#8745;_&#8745;)O~ I think I could resolve my problem this time. O(&#8745;_&#8745;)O~ Dmitry Streblechenko Wrote: > Use Namespace.SelectNamesDialog (Outlook 2007 specific) > > > > -- > Dmitry Streblechenko (MVP) > http://www.dimastr.com/ > OutlookSpy - Outlook, CDO > and MAPI Developer Tool > - > "Nathan" <Nathan....
Two questions about how to use textboxes in userforms
Michael Bauer [MVP - ...
0 / 5 17 Nov
I'm sorry, I have no solution to #2. If the project file is corrupt, this might help: Export all of your project files, close Outlook, and delete the *.otm project file. Then re-open Outlook, start the VBA editor, and import your project files and save, which creates a new project file. -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your...
Save Email message as HTML file on Harddrive
Michael Bauer [MVP - ...
0 / 9 17 Nov
Terry, recommended books are: Professional Programming Outlook 2007, Wrox Press, by Ken Slovak Microsoft Outlook Programming, by Sue Mosher -- 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, 11 Nov 2008...
How to set button priority in groups on Outlook 2007 Inspector tab
Ken Slovak - [MVP - O...
0 / 2 17 Nov
No, the ribbon doesn't work that way. You can make your button visible and invisible, that's about it. -- 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 "a3kumarz" <a3kumarz@discussions.microsoft.com> wrote in message...
How to connect a contact to an appointment in Outlook 2007
MarceepooNu
0 / 3 16 Nov
Thank you. -- MarceepooNu "Michael Bauer [MVP - Outlook]" wrote: > > Click Tools/Options/Contact Options/Show Contact Linking on all Forms > > -- > 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> > > >...
Moving Calendar items to a folder
Michael Bauer [MVP - ...
0 / 2 16 Nov
Get the default calendar with the olFolderCalendar constant. As items in a calendar are AppointmentItems and not MailItems, you need to change the declaration of the objItem variable. -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : <http://www.vboffice.net/product....
Displaying Calendar Explorer
Dan
0 / 4 14 Nov
Sorry, my bad. Should have been Set expActive.CurrentFolder = objFolderCalendar Thanks, works great. Dan "Dan" <dartuso@NOSPAMpagepearls.com> wrote in message news:O1rh57oRJHA.4916@TK2MSFTNGP06.phx.gbl... > Hi Ken, > Thanks. > I've tried this but it errors out... is this what you meant? > > MyStartTime = Now > Set objFolderCalendar = objNamespace....
open source removing duplicate contacts
Ken Slovak - [MVP - O...
0 / 5 14 Nov
Look at the Navigation Pane when displaying the Folder List. If it says something like "Personal Folders" or "Outlook Today" at the top of the folder list you're using a PST file and not an Exchange mailbox. If you're using Exchange it would say something like "Mailbox - your name here". The quoting is confusing because of how it works with multiple quote characters. I usually try to...
moving email messages from one folder to another existing fold
DanWo
0 / 7 14 Nov
the message is moved there using a rule. "Dmitry Streblechenko" wrote: > Where are these folders located relative to the root/Inbox/etc folders? > How does the messgae end up in the KanaDaily folder to begin with? > > -- > Dmitry Streblechenko (MVP) > http://www.dimastr.com/ > OutlookSpy - Outlook, CDO > and MAPI Developer Tool > - > "DanWo" <DanWo@discussions.microsoft.com>...
Outlook Contacts Macro to Change Info
Michael Bauer [MVP - ...
0 / 2 13 Nov
Use the GetDefaultFolder function to get the folder,then loop through its Items collection, and change each ContactItem's title property, then call Save. -- 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 Thu, 13 Nov...
Outlook VBAProject.otm reverted to prior version
Steve Kiwi
0 / 5 13 Nov
Yep, I know that now! When I began I was given a form someone else had started, and just continued developing from there. As time has gone on, it's become harder and harder to manage, and for users to install or update. Today I am starting the process of converting it to a COM add-in, which will hopefully not be too much more than copying and pasting the code I already have....
creating and setting userproperties programmatically
Preston
0 / 4 13 Nov
i guess it makes more sense if i consider it in light of the mailitem being an object. i was thinking along the lines of defining variables and such. strSweet = "sweet" or even DELETE * FROM tblWasMyLoot; those are the types of changes that I was thinking of. thank you for the response :) "Ken Slovak - [MVP - Outlook]" wrote: > What's to understand? In any code if you don't save a...
What is wrong with drop-down box?
Ken Slovak - [MVP - O...
0 / 8 13 Nov
Did you set the ComboBox.ListIndex property to a valid index value? -- 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 "cinnamngrl" <cinnamngrl@gmail.com> wrote in message news:39b26398-0c68-4768-a0db-7b18a9f3a7f9@r15g2000prh....
Macro with multiple Lines of text for email OL 2007
Winnipeg Michael
0 / 5 13 Nov
You mean to try this: mymail.body = "some text" & vbCrLf & "some more text" & vbCrLf & "yet more text" & vbCrLf "Preston" wrote: > If you have something that you want to append to the body then you might try > always making the last character in the body be vbCrLf. Then when you append > things to the body you can use the logic > mymail.body = mymail.body & "new text to add...
Recursively set Auto Archive settings on a sub folder
Tara H
0 / 1 13 Nov
A year or so ago I found a piece of code that, when attached to a toolbar button, allowed me to set the archive settings on a top-level folder, click on the button, and it would set all sub-folders to the same setting. Unfortunately I lost it when I got a new work laptop and now I can't track this down. I don't have the spare time or expertise to write it myself from scratch - does...
Link To Outlook Address Book Slow
Dmitry Streblechenko
0 / 4 12 Nov
Why do you want to retrieve *all* the GAL entries? Outlook never does that - it only retrieves whatever is visible to the user (220-30 entries at a time). I would take another look at your design if I were you - more than a dozen entries in a combo box makes it unusable to an end user. Thousands of entries is certainly unacceptable. -- Dmitry Streblechenko (MVP) http://www....
Modify default incoming Message form
Ken Slovak - [MVP - O...
0 / 2 12 Nov
See http://www.outlookcode.com/article.aspx?id=39 -- 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 "Diego" <Diego@discussions.microsoft.com> wrote in message news:2DB25093-E588-4E0C-B691-7B25EDBD5DCF@microsoft.com... > Hi, > >...
Summarizing personal folders
DKS
0 / 4 11 Nov
Seems to be working. I will work out the outputting stuff. Thanks for your assistance. "Alan Moseley" wrote: > You are asking for a fair bit here, and I don't really have the time to write > a full application. The code below should get you started, just replace the > Debug.Print line with file output code . Run the 'ScanAllFolders' macro. > This in turn calls the...
How to get the sent mail time stamp using VBA Macros or by rul
DKS
0 / 3 11 Nov
Hi Alan, This solution looks quite similar to what I am looking for (see my post Summarizing personal folders that was done just around the same time as you keyed your solution in). Only difference in my case is that I want a personal folder to be scanned and not a SENT folder. In the personal folder, there would be mails SENT by me and mails RECEIVED by me (as compared to only...
CSS formatting of emails
Graham Y
0 / 1 11 Nov
I know this is not VBA, but I couldn't see any better groups to post this question to! I am trying to create a html template for our emails, I've tried using tables and when someone replies, all the table borders suddenly appear, and if I just use CSS then Outlook seems to throw away all my div deffinitions, so the result looks awful. Any advice, or pointers gratefully received...
resending an email
Alan Moseley
0 / 3 10 Nov
I would get your Exchange administrator to set the forwarding up for you (in your Active Directory user properties), it won't take them more than a minute! -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "Rudy L." wrote: > Hi, pardon the simplicity of the question, but I'm a newbie at Outlook VBA > > I...
Clean up File Link
Ken Slovak - [MVP - O...
0 / 2 10 Nov
To do that you need to use HTMLBody and not Body and to format your new text correctly as HTML text using an <A> set of tags. Study some HTML messages that have text showing for an URL link and see how they do it. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options....
Need Help for fire department
Michael Bauer [MVP - ...
0 / 4 08 Nov
With the Outlook object model you can't read by which account an e-mail has been received. You could do that with Redemption (www.dimastr.com) for instance. Another workaround would be to create a rule to run a script. The condition for that rule would be 'through specified account'. That script could be something like this; you just have to add the recipients: Public Sub...
Add Hyperlink in Email
Michael Bauer [MVP - ...
0 / 5 08 Nov
That works only with html formatted e-mails. In html it looks like this: mail.htmlbody=<a href='d:\test.txt'>file</a> -- 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 Thu, 6 Nov 2008 15:58:21 -0800 (PST) schrieb...
Outlook CBA changing Fonts
Michael Bauer [MVP - ...
0 / 2 08 Nov
If that's an html formatted e-mail, you need to write into the HTMLBody property, and use html tags. -- 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 Sat, 8 Nov 2008 06:23:03 -0800 schrieb Sean McPoland: > Hi all,...
Sorting Inbox
Dan
0 / 4 07 Nov
Thank you gentlemen! Dan "Dan" <noone@nowhere.com> wrote in message news:%23fp96dNQJHA.5044@TK2MSFTNGP05.phx.gbl... > Hi, > I'm trying to time the sorting of the inbox on various fields like this: > > Set colItems = objFolderInbox.Items > MyStartTime = Now > colItems.Sort "From" > TimeToSortInbox = DateDiff("s",MystartTime,Now) > > Unfortunately this is not an accurate...
Display "Last Update on ..." message on Calendar in public folder
Ken Slovak - [MVP - O...
0 / 2 07 Nov
You can't access the information bar or status bar or any of those places. Your code could not show the menu button or toolbar button when the focus is in a different calendar folder, just check for which folder will be displayed by using the Explorer.BeforeFolderSwitch() event. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007....
FlagStatus question
Ken Slovak - [MVP - O...
0 / 5 07 Nov
FlagStatus is available in Outlook 2000, I don't have an earlier version running here at the moment. -- 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 "Salad" <oil@vinegar.com> wrote in message...
OL2007 - determine if shared calendar folder has been cached
Tadwick
0 / 2 07 Nov
From a registry comparison before and after setting this value I get : keypath is : [HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\<profileName>\13dbb0c8aa05101a9bb000aa002fc45a] key is : "00036601" hex value = hex:84,19,00,00 on hex value = hex:84,11,00,00 off "Tadwick" wrote: > It's my understanding that you can...
Notes field
Michael Bauer [MVP - ...
0 / 4 06 Nov
First you need to save the attachment as a file, then add the full name of the file in this notation to the body property: Body="<file:///d:\test.txt>" -- 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, 4 Nov...
add event macro
Michael Bauer [MVP - ...
0 / 2 06 Nov
Yes, I think so. But the main work isn't Outlook related: You need to automate the IE, and navigate to the site. Then you need to parse all the HTML that's returned, and find what you're looking for. It's not difficult but a lot of work. -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis &...
Outlook Redemption expand distribution list
Dmitry Streblechenko
0 / 2 06 Nov
Did you see my reply in microsoft.public.office.developer.outlook.vba? -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Kalyan" <Kalyan@discussions.microsoft.com> wrote in message news:D64D5C7D-57F5-4043-ACF1-15E94F3D1CD4@microsoft.com... >I need to expand the distribution list(DL).. both DL in Exchange and > private...
Trapping RDO (Redemption) Events in Delphi
Dmitry Streblechenko
0 / 13 05 Nov
You would need the RDOItems.ItemAdd event, where RDOItems is retreived from RDOFolder.Items collection, where RDOFolder points to the Deleted Items folder. This is the same as in the Outlook Obejc tModel. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Andrew Lockwood" <andrew@lockwoods.me.uk> wrote in message...
How to get an event when a meeting starts and ends
Jan K
0 / 4 05 Nov
The beginning and end are all I need, but it sounds like I have to use reminders for this....
Read all folders into an array
Martin@att
0 / 3 05 Nov
I knew it was just a simple matter of wording thanks!! "Ken Slovak - [MVP - Outlook]" wrote: > Doing a google search on "iterate Outlook folders" returned this as the > first response: > > http://www.outlookcode.com/codedetail.aspx?id=1748 > > -- > Ken Slovak > [MVP - Outlook] > http://www.slovaktech.com > Author: Professional Programming Outlook 2007. > Reminder Manager,...
Alt+F1
Larry S
0 / 5 05 Nov
yeah, i did that. i just can't leave well enough alone. maybe i have ocd, but i like just one button that simply says "Navigation Pane" to toggle on/off. if that's not workable guess i'll just have to live with it, and maybe even seek some counseling. btw, my previous computer was outlook 2007, although it was an upgrade from 2003. "Ken Slovak - [MVP - Outlook]" wrote: > So you've...
capturing data on sending emails
lhhlkh
0 / 5 05 Nov
Ken Slovak wrote: > A recipient would have to be running your software for that to be possible. > > "mdlister" wrote >> >> Thanks, that works really well on my machine, but if i send an email to >> someone and they reply is it possible to capture it at there end or is >> this not possible? here's how I do this 1. based on words in subject line "Install Software", I send back an...
Code to start Word -- now it's not working?
Ken Slovak - [MVP - O...
0 / 8 05 Nov
You can certainly set your Wd and Doc objects to Nothing at the end of your sub, but that's not likely the problem. You are using CreateObject() on Word.Application, so each call will create a new instance of the Word application process. You might want to look into using GetObject() instead. Use that and if it returns Wd as Nothing then call CreateObject() to create the instance...
Is there a way to get the profile name
Ken Slovak - [MVP - O...
0 / 3 05 Nov
The CDO download is only for Outlook 2007, where there is already a NameSpace.CurrentProfileName property available. CDO 1.21 for earlier versions of Outlook is located on the Office CD. Also, if the code is to be managed code CDO is not supported for use in managed code. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007....
Detect which attachment Item(s) is selected in an email
Ken Slovak - [MVP - O...
0 / 4 05 Nov
No, that's not possible in Outlook 2003 or earlier. -- 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 "a3kumarz" <a3kumarz@discussions.microsoft.com> wrote in message news:3175926D-248A-4507-905C-DEFBD0339A72@microsoft.com... >I...
What makes up a unique id for finding an email?
Salad
0 / 1 04 Nov
Using the Find method you can't use EntryID. Is the best way to find an email is using the subject and create time values?...
automatically show/hide toolbar
Peter T
0 / 9 04 Nov
Yes you're right, I must have missed something somehow. I never needed to manually add the (selfcert) certificate in IE Options/Content but it's there. On reflection I'll dispense with the ComAddin, VBA works just as well and easier to tweak! Regards, Peter T "Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote in message news:%2382wPKsPJHA.4480@TK2MSFTNGP05.phx.gbl.....
Force SMTP CreateRecipient() in Exchange environment
Dick Watson
0 / 11 04 Nov
Imagine my surprise. Microsoft codes a square wheel and it's always "by design". "Ken Slovak - [MVP - Outlook]" wrote: > Looks like "by design"....
Email Forwarding
Ken Slovak - [MVP - O...
0 / 6 04 Nov
Something like this, although this has no real error handling and needs to be tweaked so there's no possibility of an endless loop. This code would go into the ThisOutlookSession class module in the Outlook VBA project. You would of course have to sign the project or lower macro security to have it run. Private Sub Application_NewMailEx(ByVal EntryIDCollection As String) Dim...
Trying to have code close an open email after it saves.
Ken Slovak - [MVP - O...
0 / 6 04 Nov
See my signature :) My book does have some on VBA and forms but is geared to more advanced topics such as COM addins and concentrates on Outlook 2007. -- 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 "DStrong"...
Detect Fwd MtgItem on Send event
Ken Slovak - [MVP - O...
0 / 2 04 Nov
Until the item is actually sent the sender properties aren't filled in other than SenderName. If you save the item in the Send() event handler you can get that and the ConversationIndex and ConversationTopic properties. You can then look for items with the same ConversationTopic (based on Subject) and check for ConversationIndex length. Each new item in a conversation adds 6 bytes to...
DLL Hell with the View Control OUTLCTL.DLL
Ken Slovak - [MVP - O...
0 / 4 04 Nov
The old P&D wizard deployments are known for including everything including the kitchen sink in deployments. Years ago when I used to use that package I always spent a lot of time customizing what was deployed that wasn't needed. I never deployed the VB runtime or any standard VB OCX's or DLL's, those are already installed by Windows or Office, as long as you're targeting Office 98...
All times are in (US) Eastern Daylight Time (GMT -4:00)