| Thread | Last Author | Messages
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.... |