ThreadLast AuthorMessages
read/total
Date
Resetting list of senders who have received automated replies
Dudely
0 / 1 15 Dec 2008
After much gnashing of teeth, hair pulling, cussing and many, many hours of research, I finally figured out why I can't send more than one automated reply to the same person. Apparently, this is a feature. Microsoft states "The reply using a specific template rule in the Rules Wizard sends your automated reply only once to each sender during a single session. This rule prevents...
Show error message " No Such Interface Supported "
Ken Slovak - [MVP - O...
0 / 4 15 Dec 2008
I repeat. Show the code you use. -- 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 "Sikchun" <Sikchun@discussions.microsoft.com> wrote in message news:C8D8190A-EE4B-4876-A145-C7DFD55D303A@microsoft.com... > what can i fix the...
Macro to insert date/time stamp into Notes?
Michael Bauer [MVP - ...
0 / 2 15 Dec 2008
Do you want to add that at the beginning or at the current cursur position? The latter isn't possible with the Outlook object model before OL07. You'd need the Redemption for that (www.dimastr.com) -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : <http://www.vboffice....
On click event for mail item selection
Mark
0 / 5 14 Dec 2008
Thankyou Ken, Once again I appreciate your help All is no working well "Ken Slovak - [MVP - Outlook]" wrote: > You can put the code in the ThisOutlookSession class and use something like > this: > > Dim WithEvents oExpl As Outlook.Explorer > > Private Sub Application_Startup() > Set oExpl = Application.ActiveExplorer > End Sub > > Private Sub oExpl_SelectionChange() >...
Automatically Save Attachment
March
0 / 7 12 Dec 2008
If (Item = "Statement") or (Item = "Sub2") Then ....... ...... ........ End If Above what I've got the answer for myself and I would like to share for everyone. March "March" wrote: > With the following code, I could get the attachments transfer to HardDrive. > > Dim ns As NameSpace > Dim Inbox As MAPIFolder > Dim Item As Object > Dim Att As...
Update Recipient Tracking from VBA
Andy Boruta
0 / 5 12 Dec 2008
OK. Thanks for the help. -- Thanks, Andy "Dmitry Streblechenko" wrote: > It is a third party COM library - http://www.dimastr.com/redemption/ > > -- > Dmitry Streblechenko (MVP) > http://www.dimastr.com/ > OutlookSpy - Outlook, CDO > and MAPI Developer Tool > - > "Andy Boruta" <AndyBoruta@discussions.microsoft.com> wrote in message >...
Add a Contacts folder to My contacts( "add to my contacts" action)
Ken Slovak - [MVP - O...
0 / 2 12 Dec 2008
Dim oFolder As Outlook.MAPIFolder Dim oContacts As Outlook.MAPIFolder Set oContacts = Application.Session.GetDefaultFolder(olFolderContacts) Set oFolder = oContacts.Folders.Add("My New Contacts Folder", olFolderContacts) -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options....
comment faire aparaitre la barre des langues sur differents sites???merci a v...
serge
0 / 1 12 Dec 2008
...
Determining a Constant value?
Salad
0 / 3 11 Dec 2008
Ken Slovak - [MVP - Outlook] wrote: > You have to select each item in that enum in turn until you find the one > you're looking for in the Object Browser. FWIW, Class = 43 = olMail. > Thanks for the help....
Creating a Task in an Personal Outlook Folder
Mark
0 / 5 10 Dec 2008
Thanks Ken your help is appreciated, I will give it a go ___________________________________________________ "Ken Slovak - [MVP - Outlook]" wrote: > If you have a handle to the folder where you want the new task created, use > the folder.Items.Add() method. That will create a new blank task and you can > set its properties from your SQL data. > > If you're asking how to get a...
CHANGING BACKGROUND DESIGN/STYLE/COLOR OF SELECTED BUSINESS CA
FARAZ QURESHI
0 / 15 10 Dec 2008
Thanx anyway my dear 4 supporting for so long. Do wish me luck in success of finding the goal in researching myself! Thanx agan!!!! -- Best Regards, FARAZ A. QURESHI "Ken Slovak - [MVP - Outlook]" wrote: > That XML just uses the contact photo I believe. > > You're going to have to research this yourself and maybe download various > sample business cards and examine how...
Creating a new contact with multiple line address
Michael Bauer [MVP - ...
0 / 4 10 Dec 2008
I think, you can join the content of the two cells with vbCRLF and write that into the *Street property of the contact. -- 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, 9 Dec 2008 13:10:00 -0800 schrieb Jason:...
How to get the default email address ?
Michael Bauer [MVP - ...
0 / 2 10 Dec 2008
See Application.Session.CurrentUser.Address -- 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, 10 Dec 2008 08:56:06 -0800 schrieb Anthony_fr: > Hi, > > I would like to retreive the default email adress used...
Using task categories in vbs for email notifications
Ken Slovak - [MVP - O...
0 / 2 10 Dec 2008
I don't understand the problem. If you have a TaskItem declared as objTask then objTask.Categories is the categories for that item. You can either read or write that string property. If you want to know what it contains then read it into a string and do whatever string parsing you want. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming...
Frustrating little problem
Lou
0 / 5 09 Dec 2008
Note: I have found a work around using Actual Window Manager. This program has the ability to run a keyboard macro upon start up of a window. First I made the "Show Fields..." menu item appear on the Advanced Find Menu bar and made the "S" the active menu key by prefixing it with an "&" (and no other Advanced Find Menu bar has a active menu key of "S"). Then in Actual Window...
Strip attachments from Outlook calendar items
Dale Fye
0 / 3 09 Dec 2008
Thanks, Michael. The boss thought he was going to have to open each calendar item to determine whether it had an attachment, and then delete the attachment if he no longer needed it. We figured out how to change the view within Outlook to view all calendar events in a list, then sorted on those with attachments. Then he reviewed those. It made the job more tolerable, but still...
VBA Optimization
Michael Bauer [MVP - ...
0 / 4 09 Dec 2008
I think, Copy and Move is what consumes so much time, and I don't think you could accelerate that code. If you add a counter, that would make it even slowlier. However, you could do that by adding a UserForm to the project, put a label on it, and update it in every loop. You must display the form with Show 0, for that it displays non-modal, and call DoEvents after every update. --...
Forward email as attachment
Michael Bauer [MVP - ...
0 / 2 09 Dec 2008
Call the Forward function, which returns a new MailItem. Then pass the selected MailItem to Attachments.Add of the new item. The selected item is Application.ActiveExplorer.Selection(1). -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : <http://www.vboffice.net/product....
Change Account Server/Port information
Dmitry Streblechenko
0 / 2 08 Dec 2008
Not using the Outlook Object Model. If you are using C++ or Delphi, you can use IOlkAccountMgr interface to modify/delete (but not add) Outlook accounts. <plug> If you are using VB or .Net, you can use Redemption to manage the accounts - RDOSession.Accopunts collection wraps the IOlkAccountMgr MAPI interface: http://www.dimastr.com/redemption/rdo/RDOAccounts.htm </plug> -- Dmitry...
Outlook VBAProject.otm reverted to prior version
Steve Kiwi
0 / 7 08 Dec 2008
All I have is a textbox in the corner of the form containing the version number, which I update each time I release a new version. When the user logs in, I pass the contents of the textbox along with their username/password to SQL Server. In the stored procedure I simply write that value to the users table, which tells me the version the last time they ran the program. I also have...
Outlook 2003 or 2007 autoexec macro to check for disabled item
Sue
0 / 3 08 Dec 2008
Thank you Ken - Your advise is well taken. I appreciate the feedback. Sue "Ken Slovak - [MVP - Outlook]" wrote: > You can put the code in ThisOutlookSession and call it from the > Application_Startup() event handler available there in that module. Drop > down the General drop-down at the top of the window when in > ThisOutlookSession and select Application then select the...
HOW 2 VIEW THE XML SCHEMA OF AN EBC?
FARAZ QURESHI
0 / 1 07 Dec 2008
A praiseworty MVP "Ken Slovak" sure did present me with an special idea in respect of changing the layout of a contact card with the following code: Public Sub ConvertToDesiredBusinessCard() Dim obj As Object Dim oFolder As Outlook.MAPIFolder Dim oContact As Outlook.ContactItem Dim oModel As Outlook.ContactItem Dim colItems As Outlook.Items Dim i As Long...
dynamic text source for RULES and ALERTS reply
GlenB
0 / 1 05 Dec 2008
I really need some help here (please). I need a way to create a RULES AND ALERTS reply which gets it's text/body information from central sources on the network (eg .txt or .html files), so that when we need to change our office closure dates for Christmas (for eg) we don't need to update every profile separately (which takes hours). The body needs to use each users unique...
Scope of InAppFolderSyncObject property?
Dmitry Streblechenko
0 / 4 05 Dec 2008
But it does stick for the primary Exchange mailbox, does it not? -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Tadwick" <Tadwick@discussions.microsoft.com> wrote in message news:6A650216-6460-474B-883B-0064DDCD1A4F@microsoft.com... > Hi Ken, > > Trouble is I cannot read the property for shared folders. So, I will >...
Even simple macros fail with Automation Error (outlook 2003)
Ken Slovak - [MVP - O...
0 / 2 05 Dec 2008
Certainly an upgrade from Office 2003 to 2007 and then back again could mess up lots of things. In general the MVPs recommend completely uninstalling Office 2003 before installing Office 2007 and then creating a brand new profile for Outlook 2007 (not copying an existing profile). I'd try the Office repair and see if that helps. -- Ken Slovak [MVP - Outlook] http://www....
CDO Open Mailbox
Ken Slovak - [MVP - O...
0 / 4 05 Dec 2008
It's the logon. The logon arguments "", "", False, False can only be used when a MAPI session is already running (Outlook is running). Otherwise you have to specify a profile to use or start a profile logon dialog. On http://www.cdolive.com/cdo5.htm look at the "Log on, send a message and log off" section. That shows how to use different logons depending on existing conditions....
code for event: everytime i save an item ...
Ken Slovak - [MVP - O...
0 / 5 05 Dec 2008
In Outlook 2007 you can use the Folder.BeforeItemMove() event. That passes you a reference to the item being moved and the target folder the item is being moved to. If the target folder is Nothing then the item is being deleted. There's also a Cancel argument, set that to True in the event handler and that cancels the deletion. So you'd declare the Folder object: Private...
Is InAppFolderSyncObject write-only?
Tadwick
0 / 5 04 Dec 2008
If it's a bug how does one resolve it? Is it readable some other way eg MAPI property or in the registry? FYI - Here's my code.... Public Sub appfolders() Dim olApp As New Outlook.Application Dim nsp As Outlook.NameSpace Dim sycs As Outlook.SyncObjects Dim syc As Outlook.SyncObject Dim fdr As Outlook.MAPIFolder Dim myRecipient As Outlook.Recipient...
Intermittent type mismatch error
Dmitry Streblechenko
0 / 10 04 Dec 2008
If the folder only has MailItem objects, the code will work. If you have other objects as well (reports, meeting requests, etc), it will fail. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "lmcd" <lmcd.3jwqbd@thecodecage.com> wrote in message news:lmcd.3jwqbd@thecodecage.com... > > Hi, thanks for the reply. I finally...
use Access data to create appt. in outlook
MKMurphy
0 / 1 04 Dec 2008
I have an Access scheduling database that lists Instructor, name of class, class room, and startdate. Right now, each instructor must manually enter their teaching schedule into Outlook (mostly to sync with handhelds!) I can export a query, per instructor, as Excel and XML. I would like to be able to use this information to generate appts. in outlook, given the Excel or XML data....
My Links/Domain Names-No Longer Send in My Emails
M & C
0 / 1 04 Dec 2008
I no longer can include my Business Web Addresses as a link in my emails. Either going out, or as a test, an associate sent them to me. They do not reach me nor do they get to their destination. They leave my Out box and show they were Sent. Dell worked on the issue, McAfee, my Internet/Email Server. I called my Domain (housing company). This has now been going on for just about...
Deleting Mail Items - Code
Ken Slovak - [MVP - O...
0 / 8 04 Dec 2008
OK, then you might have to add a test after the loop to see if there's still any items left in that collection and if so try either getting that last item as an object item and calling its Delete() method again or using Items.Remove(1) and see if either of those works. In some versions of Outlook removing the last item in a collection using Delete() doesn't work. That might be what...
how to use vba
paultip
0 / 4 04 Dec 2008
Thanks for the info, but I was already aware of that, this function is to safeguard my position when the email is sent to several others and they can see a date/time along with the text of the mail. "JP" wrote: > For what it's worth, all incoming and outgoing messages are already > timestamped by Outlook. Just right-click an email in the explorer > window and go to Options. Or if...
Can I access the Outlook Express .DBX file directly from VB.NET 2005
Steve Cochran
0 / 4 04 Dec 2008
It is very difficult but can be done. Its easier to use C++ than to try it in VB. see http://msdn.microsoft.com/en-us/library/ms709546(VS.85).aspx steve "ngr" <ngr@tdrd.karoo.co.uk> wrote in message news:hJqdnXI1L-cv36nUnZ2dnUVZ8vSdnZ2d@eclipse.net.uk... >I want to create an application which will retrieve message headers and >messages and store them in a SQL database. > >...
public folder calendar
Tony WONG
0 / 3 04 Dec 2008
thanks a lot. restrict method is my choice. "JP" <jp2112@earthlink.net> ???????:282f8d00-2c79-4a6c-a0eb-65ebd6f1d5f7@w35g2000yqm.googlegroups.com... You might want to archive calendar items, so there won't be so many in your current calendar. Also, the Restrict Method can be used to limit the amount of items you are iterating through. HTH, JP On Nov 28, 4:43 am, "Tony...
Outlook 2003 - create new menu
Ken Slovak - [MVP - O...
0 / 2 03 Dec 2008
That would be a custom Explorer context menu. It's a hack in Outlook 2003 because there's no way to tell where the right-click occurred. In Outlook 2007 it's fully supported. Search at www.outlookcode.com for "Explorer context menu" to see the hacks that have been developed for this. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming...
Saving attachments from multiple emails
JP
0 / 4 03 Dec 2008
...
Recurring email and attachments
Ken Slovak - [MVP - O...
0 / 2 03 Dec 2008
' previous code NewItem.Save NewItem.Attachments.Add "string path to the file to attach" NewItem.Display -- 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 "JenniferCHW" <JenniferCHW@discussions.microsoft.com> wrote in message...
Deleting old messages
ngg
0 / 2 02 Dec 2008
I got my answer from another section in the Outlook forum: Use the AutoArchive function located under Tools, Options, Other. You can also set specific AutoArchive settings for each folder by right-clicking and selecting Properties/AutoArchive. ngg "ngg" wrote: > I want to have a script run automatically every day that will delete messages > in my deleted items folder...
hide sender email add
DStrong
0 / 3 02 Dec 2008
As Ken says you cannot concel, but you can use he "Have replies sent to" option. This does not solve your issue 100%, but it might help some. It is found in the options portion where you can ask for a read or delivery receipt. Simply add an email address such as noreply@yourcompanyname.com and when the user replies, it does not make it to your inbox. "Junior728" wrote: > Hi,...
Extracting data from an e-mail to Excel
Michael Bauer [MVP - ...
0 / 2 02 Dec 2008
You can use the Instr function to find the position of a specific text in the body of the e-mail. Then use the Left, Right, and Mid functions to extract the text. -- 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...
print preview and user properties...
Dmitry Streblechenko
0 / 2 02 Dec 2008
Outlook always prints named properties. <plug> Redemption can hide user properties - see RDOUserProperty.Printable property: http://www.dimastr.com/redemption/rdo/rdouserproperty.htm </plug> -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "wes2" <wes2@discussions.microsoft.com> wrote in message...
Copying selected text from a message body
CharlieH
0 / 5 02 Dec 2008
Ken - great info. Thank you very much. I'll take your advice and get the Redemption Library. "Ken Slovak - [MVP - Outlook]" wrote: > A user can set WordMail on or off and also set the format (plain text, RTF > or HTML). You need to check what is being used something like this: > > Select Case item.GetInspector.EditorType > Case olEditorHTML > Dim oHTML As MSHTML.HTMLDocument...
Macro names not available in script window
Ken Slovak - [MVP - O...
0 / 2 02 Dec 2008
Your macro should follow this type of format: Public Sub MyMacro(Item As Outlook.MailItem) ' whatever End Sub -- 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 "Jiles" <Jiles@discussions.microsoft.com> wrote in message...
ANY WAY TO MAKE COMPLETED TASKS SHOW AS HIGHLIGHTED?
Ken Slovak - [MVP - O...
0 / 2 02 Dec 2008
You don't need code for that unless you want to distribute something. Just customize the current view in the Tasks folder. Select View, Customize Current View and select the Automatic Formatting button. In that dialog select the rule you want to change and set the Font to use. You can change from strike-through to underline (or both) and use whatever font and font style you want...
Permanently enabling macros
NJS
0 / 8 01 Dec 2008
Thanks Sue, unfortunately I need to deploy this on multiple machines, (and without a public cert)so need the ability to leverage the 'trusted location' facility (that is missing from Outlook?) "NJS" wrote: > Hi Sue > is there no way to create a trusted folder in Outlook? > thanks > > "Sue Mosher [MVP-Outlook]" wrote: > > > You need to use the Selfcert.exe tool (on the...
run macro when autoarchive stops
Dmitry Streblechenko
0 / 4 01 Dec 2008
No. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Indrek Tiidrus" <Indrek Tiidrus@discussions.microsoft.com> wrote in message news:B728C81A-70EA-4B11-B1EC-2FE98DB1C7EA@microsoft.com... > But is there any Autoarchive starting or running event to catch? Maybe > then I > can perform continious check and execute my part...
AppointmentItem's lable color in public folder on exchange server.
Ken Slovak - [MVP - O...
0 / 2 01 Dec 2008
Answered also in the VSTO group, please do not multi-post. If you have the correct rights to the public folder it should work the same way as with a mailbox folder. Are you getting a valid MAPIFolder object for that public folder? Any exceptions being thrown? You do know that Extended MAPI is not supported for use with managed code? -- Ken Slovak [MVP - Outlook] http://www....
Embedding Images in Outlook email via Delphi
Rudy Hentzen
0 / 1 01 Dec 2008
Hi, I know this is a VB Group, however, i am at a brick wall now. Essentially i am trying to send an email with an Embedded image via Outlook. I have been told that this cannot be done via the Outlook Object Model and that i should use CDO or Extended MAPI. I got some VB Code from http://www.outlookcode.com/d/code/htmlimg.htm and tried to translate it to Delphi code (see...
Archives
Dmitry Streblechenko
0 / 4 30 Nov 2008
...
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)