Thread
Last Author Messages read/total Date
elandau1@gmail....0/9 29 Feb 2008
I am creating an Explorer class which triggers on the SelectionChange
event and I want to move the email I was just on... but I want to make
sure that i did not move it manually first so in other words, before I
use the mail's MOVE action, I want to make sure it is still in the
inbox. I was looking for something like a ParentFolder property or
something similar.
Any clues?
Thanks
McKilty0/1 28 Feb 2008
Grasping at straws... It turns out that the CDO.DLL was a reference
and shouldn't have been. It was used for some old code that was
removed.
We are both using Office 2003. What library is needed that would not
be registered?
It's a pretty fresh install of 2003. It didn't work on her previous
computer either which was built just for her.
On Feb 28, 4:38 pm, "Ken Slovak -
elandau1@gmail....0/1 28 Feb 2008
Reposting with a new subject-line since my search has now progressed
to suspecting I'm catching an event too early:
I created an Explorer class which triggers on the SelectionChange
event. For each event
1) If myLastInboxItem is not nothing, move it to an Archive folder
2) set myLastInboxItem = ExplorerClass.Selection.Item(1)
... Of course, I need to make sure the email I was
reader0/3 28 Feb 2008
Have Outlook 2003. At times when I import the archived file I find that
there are multiple copies of the same message. I have to (1) delete the
archive file, (2) painstakenly eliminate the duplicate messages, and then (3)
create a "fresh" archive file. Is there some setting that can be used to
prevent multiple copies of the same message in the archive file (pst)? Thank
you.
Ashok0/1 25 Feb 2008
Hi All,
I am developing Com Addin for outlook using VB 6.0. If the outlook email
editor is word(OL 2003), I am unable to pop up my form on the current
inspector, it always goes to the outlook explorer.
Could anyone of you guide me how to achieve the same?
I'm able to display my form, if the editor is normal.
Your prompt reply would be appreciated.
Thanks & Regards
Ken Slovak - [M...0/10 25 Feb 2008
We use the dialog below to set a textvar to the address of a folder.
While we are in the dialog, shortcuts (to the various folders we use often)
don't work.
How can we modify the dialog so that shortcuts to file folders will work
inside the dialog?
Here's the code:
Set objFolder = objShell.BrowseForFolder(&H0, "Select the file", _
BIF_editbox + BIF_browseincludefiles, "")
Darshan0/1 25 Feb 2008
Hello,
I have configured an IMAP account in my Outlook 2003. I have observed that
some of the emails in the IMAP account are still accessible in Outlook, even
when i am not connected to the network. This does not happen always, and
each time a different set of emails is accessible.
This leads me into thinking that Outlook is caching some of the emails
according to some policy like:
Sue Mosher [MVP...0/2 24 Feb 2008
I have written a macro, originally for in Outlook 2003, that seems to be
affected by our upgrade to Outlook 2007.
The macro searches the subject of all of the messages in the inbox for a
certain string (BCE #), and if it finds the string, it extracts a job number
following the string, and saves it to a matching job number folder on the
network. Some subjects contain multiple instances
delfino.nunez@g...0/11 22 Feb 2008
Does anyone knows how to get the property FLAGICON from a post item.
something like this
If mpfInbox.Items(1).Class = olPost Then
MsgBox mpfInbox.Items(1).FlagIcon
End If
But not for olMailItem, should be for the Posts.
I need to move POSTS from one folder to another based on the flag
color.
For example, only post with green and completed flag will be moved to
another folder.
Ken Slovak - [M...0/2 22 Feb 2008
Hi,
I'm a neophyte when it comes to coding VBA in Outlook. I do all of my work
primarily in Excel.
Here's my issue: I run a file that executes SQL data in the background. I
set the parameters in the GUI ie; date, location etc and the application
sends me an email with a link on it when the SQL is complete. I open the
message in Outlook and click the underlined link that says file
Darshan0/1 22 Feb 2008
Hello,
Outlook internally uses a unique EntryId as an identifier for every item in
Outlook.
Every time Outlook synchronizes the emails in its IMAP account, is it
possible that each item gets assigned a different EntryId? or does Outlook
somehow remember what EntryId had been assigned to each item and makes sure
that the same is reassigned?
--
Darshan
Frank S0/3 18 Feb 2008
Can I use VBA to read the Options > Other > "Empty the Deleted Items folder upon exiting" setting?
--
Regards,
Frank
Ken Slovak - [M...0/2 18 Feb 2008
is it possible to insert multiple reminders into another users' calendar
using VBA?
what i'm hoping to achieve is to populate several users' Outlook calendars
with an array of reminders with minimal fuss to them (e.g. a click of a
button on a spreadsheet).
thanks in advance.
Christian Lafra...0/1 17 Feb 2008
Hello,
I want to change view mode (day, 5 days, 7 days...) through command buttons
in a HTML page. See code below. It gives me error in script - in status bar.
Calendar shows up properly.
Any idea?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>View Control</TITLE>
<META http-equiv=Content-Type content="text/html;
Ken Slovak - [M...0/15 15 Feb 2008
My outlook 2007 has a default stationary and a default signature. When I
start a new email from Outlook, the stationary and signature appears as
expected.
When I start an email through MSAccess from a command button that runs an
Access
macro who's action is "Send Object", the default stationary is correct, but
the default signature is missing. The arguments of my "Send Object" action
Ken Slovak - [M...0/2 14 Feb 2008
Hi
Can somebody please help with the VB6 code to check if outlook is running
and if it is close it
Thank you in advance
JP0/7 13 Feb 2008
I have a pretty good routine to move mail items in my Inbox to an
Archive folder. I do this by declaring a mailItem and I use its MOVE
method.
I found that not all items in the inbox are mailItems though. Some
are meeting responses (example: some are of class: olMail and some are
olMeetingResponsePositive) . How can I declare an object to cover
all possible items in my inbox, and
Ken Slovak - [M...0/2 13 Feb 2008
We created a Windows Service (c#) that runs on users' machines. It
interacts with the desktop to alert the user of certain events. I
would also like it to be able to interact with the user's Outlook to
populate an e-mail for them that they can edit and send. When the
service is running under my account, it works fine, but when I set it
to run as SYSTEM I get this error:
Exception
Kathy Webster0/4 13 Feb 2008
Outlook 2007:
1. My default account is KW1.
2. I start a new email.
3. I type the text of the email.
4. Before sending, I select the Account button and change to account KW2.
5. MY ENTIRE EMAIL IS LOST! THE ENTIRE TEXT DISAPPEARS!! The TO and SUBJECT
remain, but that's it. By changing the FROM with the Accounts button, I lose
the message.
6. I prepare to die, unfulfilled.
Please
landau@skiz.net0/3 13 Feb 2008
So I'm almost done with my VBA code... my routine sets a private to my
default Inbox (as per the title of this post) and in my routine, I
check to make sure the current Explorer is in my default Inbox or else
I don't want my macro executing. Here's the test:
At Application launch: Set myOlDefaultInboxFolder =
myNameSpace.GetDefaultFolder(olFolderInbox)
In my macro: If
landau@skiz.net0/3 12 Feb 2008
Appologies if this is a double post: I tried to reply to the original
post (help writing a VBA to move email) but that didn't seem to work.
I use Outlook 2007 on a Win XP machine. I have 1 large Outlook window
open with Preview turned ON. This is how I view all my email. I just
use the down-arrow to go to the next email. If I don't explicitely
move an email, or flag it before moving
Ken Slovak - [M...0/4 12 Feb 2008
Hi,
I have a number of users that will be receiving an Excel file on a regular
basis. I want an outlook rule (I think) that when the email is received will
automatically open the file.
The excel file contains macros that will be trusted by each of the users and
when it completes is can be closed.
Is that possible within outlook to perform this type of action ?
Thanks
Scott
Ken Slovak - [M...0/2 11 Feb 2008
Hi -
Can someone explain why this code doesn't work possibly?
Sub AddDate()
Dim msg As Outlook.MeetingItem
Dim str As String
str = CStr(Now())
msg.Body = str & vbCrLf
msg.Display
Set msg = Nothing
End Sub
I assigned it to a toolbar button, and want to be able to
automatically add the current date to the body of the meeting
invite...any ideas please? I
Ken Slovak - [M...0/2 11 Feb 2008
I have an application that allows the user to create a recurring e-
mail. My issue is when I open the address book, select a name, and
then continue, I get an error. This used to work, but now I'm on a
different development computer since I first wrote it.
My CDO.DLL version is 6.5.7651.61
The exact line the code breaks on is:
AddRecipsViaCDO = AddRecipsViaCDO &
colCDORecips.
Ken Slovak - [M...0/3 11 Feb 2008
I've added a couple of VBA macros to my Outlook 2003 and the security level
for macros is set at medium. As a result, every time Outlook starts it
displays a warning message box and asks if it is OK to enable macros. I
don't want to lower security to allow all macros to run but it would be nice
if Outlook would start without asking stupid questions, too. What is the
procedure to tell
Ken Slovak - [M...0/2 08 Feb 2008
Hi,
I am writing a backup routine which will automatically file/move
emails from the inbox of any of our staff, into Public Folders, using
some simple rules. We have a team of remote workers, all using Outlook
2003 connected via VPN to Exchange. When testing the code, I've found
that manually moving a standard 'test set' of emails from Inbox to
Public Folder takes (say) 20 seconds.
Ken Slovak - [M...0/2 08 Feb 2008
How to install Microsoft Office Document Imageing on Windows 2003(x64), when
i install it the OCR in MODI doesnt work:
System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM
class factory for component with CLSID
{40942A6C-1520-4132-BDF8-BDC1F71F547B} failed due to the following error:
80040154.
at MODIDocumentTest.Form1.Form1_Load(Object sender, EventArgs
Ken Slovak - [M...0/2 07 Feb 2008
HI,
with the following code I can add a folder to the favorites view:
Dim myOlApp As New Outlook.Application
Dim myNS As Outlook.NameSpace
Set myNS = myOlApp.GetNamespace("MAPI")
Set myAPF = myNS.Folders("Public Folders").Folders("All Public Folders")
myAPF.Folders("Shared Contacts").AddToPFFavorites
How can I list all the folders stored within that view at the moment?
Could you
Michael Bauer [...0/3 07 Feb 2008
Hi,
i try to show a attachments from a e-mail in Outlook.
I can use a TaskPane, but that not works in a E-Mail how Word or Excel.
I have file's with my extension and i want write a code for my Application
and show this in Outlook2007.
I must use XP und can' t use a Previehandle from Vista.
Thanks for idea.
greetings from berlin
Asim
bluesbrthr@gmai...0/15 05 Feb 2008
I've written a macro that will export all of my appointments to
Excel. With Office 2007, this works fine, but on other computers
running Office 2003, it does not work. The issue that 2003 does not
show the recurring items while 2007 does.
The start of my code is this:
Dim SafeAppointment, oAppointment
Dim olOutlook As Outlook.Application
Dim nsNameSpace As NameSpace
Dim
Ken Slovak - [M...0/2 02 Feb 2008
I have code to create a meeting which seems to work. As part of the meeting
i want to use a Resource - a calendar for a meeting room. How can I get the
resource (meeting room) to accept and display the meeting in its shared
Outlook calendar.
Here is the code:
Public Function CreateAppointment(SubjectStr As String, BodyStr As String,
LocationStr As String, AttendeesStr As String,
Michael0/1 01 Feb 2008
I have a rule that reads:
Apply this rule after the message arrives
sent to "Terminations"
and with "Termination Notification" in the subject
move it to the "Terminations" folder
Everything in quotes are the instructions the rest is the standar label
applied by Outlook. This rule was working fine until a few days ago. I do not
get any errors or anything but the emails are not being
Ken Slovak - [M...0/7 01 Feb 2008
This is a multi-part message in MIME format.
------=_NextPart_000_00E5_01C86409.B500F040
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a simple script that logs into a profile - grabs the inbox and =
junk folder and removes all the items. It's an unmonitored box and the =
process is simply inplace to keep it from filling up.
Sue Mosher [MVP...0/2 30 Jan 2008
Hi - I'd like to create a really simple macro that sets the mailitem
property deleteaftersubmit to true, ie so that a message will not be
saved when it is sent. I normally have Save turned on by default, but
I'd like to have a toolbar button to quickly turn this off in an
individual message before I hit send. It would be the same as opening
the options dialog and removing the check box
Sue Mosher [MVP...0/4 30 Jan 2008
Res.All
This type of coding works well in Outlook 2002. Why it gives errors in
outlook 2007?
Thanks in advance
Prashant
Dim mycfolder As MAPIFolder
Dim oFolderItems As Object
Dim oItemC As ContactItem
Dim nChars1 As Integer
Dim nChars2 As Integer
Dim newNote As String
Set mynamespace = Application.GetNamespace("MAPI")
Set myfolders = mynamespace.
Clive0/1 30 Jan 2008
I'm trying to upgrade support in a VB6 app I finished last year - from
Outlook 2003 to Outlook 2007.
The problem is with the View Control. (ViewCtl1). I can't get it to work
at all on a new PC with just Outlook 2007 on it.
It works on my development PC that used to have Outlook 2003 - which is now
upgraded to 2007, but I can't see what is left behind that keeps the View
Control
Ken Slovak - [M...0/6 30 Jan 2008
Hello,
I'm using OL2003, AC97, WinXP
when I store a new contact folder from AC97 via VBA this folder is
visible in OL only in the "folderview".
But I would like to make it automatic visible in the contact view for
the users.
How can I make the new folder automatic visible in the conatct view?
Tanks a lot
best regards
Werner
(under pressure)
Ken Slovak - [M...0/2 30 Jan 2008
Hi,
I am working with ribbons in Outlook 2007. I have added one group and
some controls in the pre-existing ribbon.
My problem I am not able to assign a custom image to the controls
which I hv programatically added using the XML. Although I am able to
add a image using the imageMSO property but I want to assign the
custom image. Could anyone help me in the context?
Regards.
Ashu
info@telenet.be0/1 29 Jan 2008
Beste klant,
Telenet heeft een migratie gedaan van haar nieuwsservers.
Wat betekent dit concreet voor jou als gebruiker?
Er verandert niets aan de service, maar om verder gebruik te maken van de
Telenet nieuwsgroepen service moet je bij de instellingen van je nieuwslezer
het adres van de nieuwsserver veranderen van news.telenet.be of
newsbin.telenet.be in newsgroups.telenet.be.
Sue Mosher [MVP...0/2 29 Jan 2008
Res. All
Can I get/set the "From" field of a new mailitem?
Thanks in advance
Prashant
Prashant Shah0/1 29 Jan 2008
Res. All
Can I get/set the "From" field of a new mailitem?
Thanks in advance
Prashant
Ken Slovak - [M...0/8 29 Jan 2008
Hello,
I'm using OL2003, AC97, WinXP
I can't close Outllok.exe.
To make a copy of the Outlook.pst I'm using this code.
But after this code outlook.exe is still running.
How can I close it?
-------------------------------------------------------------------------------
Dim myolApp As Outlook.Application
Dim myNameSpace As Outlook.NameSpace
Dim
LPC0/1 29 Jan 2008
Eat dogs, cats and baby look below:
http://z.about.com/d/urbanlegends/1/0/v/7/eating_babies1.jpg
http://z.about.com/d/urbanlegends/1/0/w/7/eating_babies2.jpg
http://888.rockin.net/propaganda-of-baby-eating/rumour.htm#true_story
info@imagiam.com
Michael Bauer [...0/4 28 Jan 2008
Hi,
I am trying to use âMicrosoft Outlook Object Libraryâ.
I have found a site, which mentions same.
http://support.microsoft.com/kb/310258
when I try to run the code given in above site I am getting annoying message
saying
"A program is trying to access e-mail addresses you have stored in Outlook.
Do you want to allow this?"
I would like some how, totally avoid this
Werner Faßbend...0/2 26 Jan 2008
Hello,
I'm using OL2003, AC97, WinXP
From Access I'wolud like to store contacts in a new Outlook contact
folder "Ramigos".
At first I store FirstName, LastName, Title etc...
Set myitem = myRAMFolder.Items.Add
If Len(Trim(Nz([Anrede]))) <> 0 Then
.Title = Anrede
End If
If
Brian Tillman0/4 25 Jan 2008
Hi All!
I use the Task application of Outlook 2003 intensively. However, as many of
my tasks involve attachments which must be stored with the task until
completion, my Inbox file size increases rapidly, triggering company IT to
send me "your Inbox is over its size limit" messages frequently.
When a task is complete, I don't want to delete it in case I need to come
back to it for
Ken Slovak - [M...0/4 25 Jan 2008
I'm new to VBA and was wondering if anyone could give me any pointers
on how I could speed up the following script for Outlook. It seems to
run extremely slowly, expecially if there are a number of mail items
selected....
* * * * *
Option Explicit
Sub TrashMail()
Dim ImapRoot As MAPIFolder: Set ImapRoot =
Application.GetNamespace("MAPI").Folders("imap.telus.
Michael Bauer [...0/2 25 Jan 2008
I can't get this macro to work. i'm trying to save the email item that is open
to a file. I'm trying two alternatives, i.e., save to .txt and save to .html
Nothing gets saved, when I use the code line below ("objItem.SaveAs strname
& ".txt", olTXT") and I input "e:\Harvey" to the inputbox.
But when I use the code line below ("objItem.SaveAs strname & ".html",
olHTML), I get an error
Rima0/3 23 Jan 2008
hello i have installed a program that was made in visual basic 6.0 that
utilizes MS access 2003 . however, when i try to save or view the data (which
it calls up the MSaccess file which it saves to), I get the error
Error 3170: Can not find installable ISAM
and when i hit debug it goes to this line of code:
data1.refresh
please urgent
what can i do
Ken Slovak - [M...0/6 23 Jan 2008
Good morning,
I have asked a similar question to the excel.programming group, but have yet
to see a response. I have code attached below. What it does is create a new
workbook in memory using data from a worksheet. I have the following two
basic questions/requests. Answer whatever you can, I'll sort it out in the
end. :)
1) From Excel I would like to be able to place the e-mail
