ThreadLast AuthorMessages
read/total
Date
Move emails not working VB-Help!
Sergio Neves
0 / 3 04 Jul
Hi I think I had a similar problem. Is it an IMAP account?! I tried to move messages of my Gmail IMAP account but since they use a slightly different system (because of the labels) the move command does not always work! If you move the message manually in Outlook it works, but in VBA it does not. I used the exact same code in another IMAP account and the code works fine. Does...
Attatchment detach issues VB-Help
Rivers
0 / 11 04 Jul
oh and ken the line is > Item.Move otherInbox.Folders("Flash Processed") hope you can help as this code is vital thank you so much for being patient lol "Rivers" wrote: > hi ken > > this is the code thanks > > Private Sub CommandButton1_Click() > 'On Error GoTo SaveAttachmentsToFolder_err > Dim ns As NameSpace > Dim Inbox As MAPIFolder > Dim...
How to detect that an AppointmentItem is a birthday?
Sue Mosher [MVP-Outlook]
0 / 4 04 Jul
Such items will be all-day events with "Birthday" or "Anniversary" in the Subject property. If you need more confirmation than that, you can extract the person's name from the Subject, get their contact record and compare the birthday value for the contact with the Start date for the appointment. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart...
Need Help to Set MS Office Outlook
Michael Bauer [MVP - ...
0 / 2 03 Jul
I'm not sure what you're doing. The code is for Access, it doesn't work in Outlook. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool : <http://www.vboffice.net/product.html?pub=6&lang=en> Am Thu, 3 Jul 2008 08:06:01 -0700 schrieb March: > Hello All, > > I need help to...
Outlook 2007 - VBA macro
Michael Bauer [MVP - ...
0 / 2 03 Jul
You cannot collapse the folders by code. Expanding folders works if you set the folder as CurrentFolder. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool : <http://www.vboffice.net/product.html?pub=6&lang=en> Am Thu, 3 Jul 2008 09:29:03 -0700 schrieb Sergio Neves: > Hi >...
Outlook email automation help
Ken Slovak - [MVP - O...
0 / 2 03 Jul
I think what you need to use is Outlook COM automation. Take a look at various item Send examples at www.outlookcode.com for ideas. -- 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 "Markus" <Markus@discussions.microsoft.com>...
move mails to folder in a local pst depending on date
verhaba
0 / 1 03 Jul
dHello For support reasons we backup mails that are send from the mail server. Whenever a user complains he didn't receive a mail we can check and prove otherwise or not :-). These mails are saved per month, ie. for each month another pst. Now I have created rules that look when the mail is sent (eg between 30/6/2008 and 1/08/2008) and the mail is moved to folder 'X' of backup 200807.pst...
Create a Macro in Outlook
Sue Mosher [MVP-Outlook]
0 / 11 02 Jul
Great! And now you have a whole new set of skills that you can apply to your next Outlook productivity task. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Bert" wrote: > I GOT IT SUE. And it works as follows: > > Sub ms() > Set objItem...
Extrating Daily File
Michael Bauer [MVP - ...
0 / 2 02 Jul
You might google for any library that is able to extract files from the zip. I'm sure there's freeware available. If you have the xls extracted, you may open it with the objects exposed by Excel. Add a reference to Excel to your project, open the object browser (f2), switch from <All libraries> to Excel, and see what's available. For opening a workbook see the Workbooks.Open function....
changing locating inbox Via VB HELP
Rivers
0 / 7 02 Jul
ken you star you were right all along it was me and my stupidity!!!! i am looking for folders that are inside my inbox however i had the folders on the outside! lol sorry Ken thanks very much for you help. greatly apreciated "Ken Slovak - [MVP - Outlook]" wrote: > Is "Main" the name of that mailbox you want to log into? You need to use the > actual name of the user who owns that...
Invoking Word/Print from an Outlook macro
Ken Slovak - [MVP - O...
0 / 2 02 Jul
There are various examples at www.outlookcode.com, one might be http://www.outlookcode.com/threads.aspx?forumid=3&messageid=12098. Search there for "Word template" and look at the search results for other examples. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options....
Outlook automation - import/create rules
Sue Mosher [MVP-Outlook]
0 / 2 02 Jul
No, Outlook doesn't provide any support for importing a .rwz file programmatically. Outlook 2007 is the first version with support in its object model for creating rules programmatically. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Marchi...
Activate macro on External Outlook add on
guyy
0 / 5 02 Jul
thanks. "Ken Slovak - [MVP - Outlook]" wrote: > Now I'm confused. If the items are in Outlook from that addin they are > Outlook items and you can act on them just as you'd act on any other items > with Outlook macro code. If you mean adding functionality to that addin > you'd have to talk to its developers to see if it supports that. > > -- > Ken Slovak > [MVP - Outlook] >...
OTLK2K3-VBA : Application_ItemLoad.
Ken Slovak - [MVP - O...
0 / 2 01 Jul
No, that event was added in Outlook 2007. If you want to handle the opening of an item use Inspectors.NewInspector(). To get which item or items are being handled in a folder view use the ActiveExplorer.Selection collection. You can instantiate objects for each member of Selection and handle the read event for those items to see which are being read. ActiveExplorer.SelectionChange()...
popup balloon on saving email attachments
Ken Slovak - [MVP - O...
0 / 4 01 Jul
It has nothing to do with Outlook. It depends on your development platform. For VBA you'd use a VBA UserForm, for .NET code you'd use a Windows Form, for unmanaged code you'd use a form provided by your development environment. You'd show the form when you want, set a timer control to fire after an interval you select, and when the timer fires you close your form. -- Ken Slovak...
Retrieving Mail Information
Ken Slovak - [MVP - O...
0 / 2 01 Jul
Use ActiveExplorer.CurrentFolder.Items to get the collection of items in the folder (if the Inbox is currently being displayed). Otherwise use NameSpace.GetDefaultFolder(olFolderInbox).Items to get that collection. Iterate the collection and retrieve whatever properties you want from each item. Make sure to test for item.Class = olMail if you are only interested in mail items. --...
Saving an attachment
Ken Slovak - [MVP - O...
0 / 2 01 Jul
See http://www.slovaktech.com/code_samples.htm#StripAttachments -- 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 "DMc2004" <DMc2004@discussions.microsoft.com> wrote in message news:0423EC14-D2CA-471D-BEAA-B1671BD46BD9@microsoft....
macro forward + reply in one
Jeroen Heijmans
0 / 3 30 Jun
On Fri, 27 Jun 2008 08:35:49 -0400, Ken Slovak - [MVP - Outlook] wrote: > It's possible, yes. Where are the selected addresses coming from? Addresses are in local addresslist, but I think best is to have an external file with only the addresses to select from (or in the macro itself). > You might want to take a look at > http://www.outlookcode.com/article.aspx?id=72 and see if...
Send Message on Behalf Question
Eka1618
0 / 4 30 Jun
If anyone using Access is having the same issue, I have found some code that seems to work! After many hrs of searching, I have found and applied the following code to my DB. I changed some things from the example I got the code from. In order to apply this code to my DB, I had to add the Microsoft Outlook 12.0 reference. This code will also solve the other problem that I was...
Outlook Message Formatting - thru Excel VBA
Ken Slovak - [MVP - O...
0 / 2 30 Jun
The best way to do that would be to use HTML encoding and to create the table in the email HTMLBody property using HTML code to design the table. If the table already exists then you could attach the template as an embedded attachment, which would put it into the HTMLBody of the email. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook...
Repetitive mailings-different subjects/attachments
Doug Robbins - Word MVP
0 / 3 30 Jun
See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Savannah" <Savannah@discussions.microsoft.com> wrote in message...
Hate Your Job?
btb.102@ntlworld.com
0 / 1 29 Jun
Do You Hate Your Job? If You Are Like Me And REALLY Hate Your Job, You Can Do What I have Done And Tell All About Your Company At A Great And CHEAP New Site Called Dont Work For These . Com http://www.dontworkforthese.com This Site Has Chat Rooms, A Joke Section, A Great Story Section Where You Can Tell All The Funny Or Stupid Things That Happen Or Have Happened To You During Your...
Differentiate the archives folders by putting them in red, in ital
Sue Mosher [MVP-Outlook]
0 / 2 28 Jun
Answered at http://www.outlookcode.com/threads.aspx?forumid=3&messageid=27139 -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Helios" <Helios@discussions.microsoft.com> wrote in message news:BDFAA238-A69F-4C2B-ACD5-5E69D48CC76E@microsoft.com... > First...
Differentiate the archives folders by putting them in red, in ital
Helios
0 / 1 28 Jun
First of all for my bad english. In my work, I often this claim which is regularly: "There I often confuse archives folders and those of my mailbox since they have the same name". I would like to differentiate the archives folders by putting them in italics or red for example. Have you an idea to resolve this "problem"? Thanks in advance...
Misdirected e-mail in Outlook with multiple accounts
M. Boss
0 / 1 28 Jun
My husband and I have separate accounts on the same computer. We work with Outlook and roadrunner servers our e-mail addresses. Road Runner and HP (our computer) has directed me to Microsoft to correct this issue. The issue is that mail that is sent to my husband is showing up in my outlook inbox and missing his inbox completely. It appears that this is just a miss-setting...
What folder does Outlook 2007 use for scripts?
High Desert
0 / 3 27 Jun
On Fri, 27 Jun 2008 15:21:23 -0400, "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote: >Outlook doesn't use .vbs scripts with rules. A "run a script" rule action uses not an external script but a VBA procedure with a MailItem or MeetingItem as its parameter. That item is processed by the code. Here's an example: > >Sub RunAScriptRuleRoutine(MyMail As MailItem) > Dim strID As...
Meeting Request Update/Cancel VBA
Joshua McLemore
0 / 1 26 Jun
Hello, I have an access database that I'm taking form information and inserting it into a outlook meeting request. I've that that working, thanks forum posts here. But now I'm trying to create two more buttons on that form that allow the user to update or cancel the meeting request that has already been created. I'll give you the code I have for creating the meeting request:...
Notification on deleted task
Ken Slovak - [MVP - O...
0 / 4 26 Jun
If you send them a task request they can accept or reject it. If rejected you get a notice and what they do afterwards is up to them, you get nothing. If they accept it and you have those properties set then if they delete it you will be notified, unless possibly they delete it after marking it as complete. Then you might not get notice, I don't recall offhand how that scenario would...
How set Recipient status of exception
Sujata
0 / 1 25 Jun
I am trying to set the recipient status as 'accepted / decline' of recurring appointment using extended MAPI PR_RECIPIENT_TRACKSTATUS. It is working fine for Master event. But for Exceptions to series showing some weird behaviour. For excepion, status is set as Accepted but if outlook is closed and opend again this status is goes back to old status. For example: If status of...
Automate possible??
Ken Slovak - [MVP - O...
0 / 2 25 Jun
See if the information at http://www.outlookcode.com/d/forms/skedrpt.htm helps. -- 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 "ali" <gdreporter@yahoo.com> wrote in message news:eGthIzw1IHA.5728@TK2MSFTNGP06.phx.gbl... >...
Export Outlook Personal Folder to a .PST file
Chris Gregory
0 / 3 25 Jun
Ken, thanks for your reply and the ideas you suggest. Yes I want to program this so I can copy all my emails in Outlook 2000 (.pst file) to another .pst file for backup, while Outlook is still running (that's important). The next step will be to schedule a job automatically to do this. -- Chris "Ken Slovak - [MVP - Outlook]" wrote: > About all you can do for that with...
Opening Outlook Address Book from Web Page
Ken Slovak - [MVP - O...
0 / 2 25 Jun
Any server side code would need to access Exchange directly to download the GAL and display it using its own rendering. If the code runs at client then you can use the Outlook 2007 object model to display the address book using the NameSpace.GetSelectNamesDialog() dialog. Versions of Outlook before 2007 don't expose any methods for displaying the address book. For server side code...
See drop-down values for Contact fields using a table view
Sue Mosher [MVP-Outlook]
0 / 2 25 Jun
Outlook does not support custom drop-down lists in views. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Haruspex" <Haruspex@discussions.microsoft.com> wrote in message news:25C38BD1-7486-4DFB-A5D1-A28FCB36CF62@microsoft.com... > Hi, > > I have...
before print my mail ;show me a "save a tree" message
RobCowell
0 / 6 25 Jun
On 6 Jun, 15:14, "Sue Mosher [MVP-Outlook]" <sue...@outlookcode.com> wrote: > Outlookprovides no way to do that, at least not directly. It exposes no events for printing and has no programmaticmethodfor printing data from a view, only thePrintOutevent for individual items. <RANT> ...and its on of the biggest intentional oversights I've seen in the Outlook programming model. The net is...
Private data in an appointment
Guy
0 / 4 24 Jun
Thanks Sue, works like a charm. Your a sweetie "Sue Mosher [MVP-Outlook]" wrote: > Take a look at the new PropertyAccessor object in Outlook 2007. There are a number of articles in Help that explain how to use it to add custom properties, both those that can be visible to the user and those that aren't. > > -- > Sue Mosher, Outlook MVP > Author of Microsoft Outlook 2007...
A Powerpoint VBA question
Doug Robbins - Word MVP
0 / 3 24 Jun
Oops! I must have still been half asleep. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote in message news:u1vRoHj1IHA.4912@TK2MSFTNGP03.phx.gbl... > Hi Doug, where's the Outlook question here? > > -- > Ken Slovak...
Attach file to Current Email
Dmitry Streblechenko
0 / 7 24 Jun
I meant "How many *open* messages do you have when the code is executed?" -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message news:uxUFIsj1IHA.2068@TK2MSFTNGP05.phx.gbl... > How many messages do you have when te hcode is executed? > Does it work if you explicitly...
Macro changes ReceivedTime when it shouldn't
Dmitry Streblechenko
0 / 4 24 Jun
You can't this is just what Outlook Object Model does. Extended MAPI (and Redemption) do not have this bug. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Galen Murdock" <GalenMurdock@discussions.microsoft.com> wrote in message news:0DB9F101-2162-4BCA-B0AC-1009E8015ACA@microsoft.com... > Hmm, but I'm not moving it...
Creating appointment from ASP web site HTML file
Dave the Wave
0 / 2 24 Jun
On Tue, 24 Jun 2008 15:11:18 -0400, "Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote: >Does that Web site support passing logon information that way? That and how >it supports it are things no one here would know anything about. On some >sites you can add a parameter to the URL: >http://www.foobar.com?password=foobar. On other sites you'd have to encode >the information or...
Merging Word doc to Mail
Ken Slovak - [MVP - O...
0 / 2 24 Jun
Probably the best way is to convert the Doc into HTML format in code and then to use HTML in the Outlook item. You might have to work on HTMLBody to get things exactly as you want but that would be easier than trying to manipulate RTF format text. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended...
Get Appointment owner (calendar owner)
Ken Slovak - [MVP - O...
0 / 2 24 Jun
When an item is moved to a different store (mailbox, PST, public folder) the EntryID and StoreID both will change so your information is not valid. You probably would need to set a user property on the original item with a guid of some sort, possibly even the original EntryID and use that property to search for the item. In addition if you want to open another user's mailbox folders...
Iterating Through UserProperty Values
Henry Stockbridge
0 / 3 22 Jun
...
popup balloon on process
Bob
0 / 9 22 Jun
...
Delete Message with VBA
Sue Mosher [MVP-Outlook]
0 / 3 20 Jun
You need to use a countdown loop instead: c = MyFolder.Items.Count For i = c to 1 Step -1 Set MailItem = MyFolder.Items(i) MailItem.Delete 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 "Luis" <Luis@discussions.microsoft.com> wrote in...
Reading outlook appoinment details into access database
TheShack
0 / 1 20 Jun
Hello. I'm new to VBA programming and need a bit of help. After searching the internet I have found the following VBA code to add an appointment into outlook from Access. I also need to be able to import appointments created in outlook into an access table. How can I do this and can it be done using automation? Thanks Private Sub cmdAddAppt_Click() On Error GoTo...
Need some help with macro for outlook (2007)
Madmann
0 / 1 19 Jun
Basically, I need the help with the following macro which involves acting on selecting an email (or multiple emails) and sending them to a folder in "Public Folders". Both folders involved are under "Public Folders". I can find tons of examples. I have attempted to tweak a few to no avail. Any help is greatly appreciated in advance. Thanks,...
Need for speed (parsing all contacts)
Mike
0 / 3 19 Jun
"Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote: >For read-only access, the Table object delivers performance similar to that of CDO 1.21. Thanks Sue! -mike...
Create Outlook - Script
Test
0 / 3 19 Jun
Thanks, it is working "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:ORr0kJj0IHA.2292@TK2MSFTNGP03.phx.gbl... A macro is, by definition, a public subroutine with no arguments. A "script" for use with a "run a script" rule needs to have an argument -- a MailItem or MeetingItem. That item is the item that triggers the rule and is processed by the code....
Custom Toolbar Menus (Outlook 2007) - Want to share with co-worker
Sue Mosher [MVP-Outlook]
0 / 3 19 Jun
The .oft files might work if they're just message body templates with no code or custom fields. But there's no way to extract a specific menu from Outlook as a file that can be shared with other users. You'd have to write and distribute code that recreates the menu. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and...
Outlook metting room resource
Monkey
0 / 1 19 Jun
I created a meeting room resource so users can book an appointment in the meeting room by creating a meeting request and selecting the Meeting Room user from the Resources button not the To button. I wondered if there was a way to configure Outlook for everyone so when creating a new meeting request the To button is not available? Thanks for any help....
All times are in (US) Eastern Daylight Time (GMT -4:00)