|
Deleting Mail Items - Code
The following snippet of VBA code (Outlook 2003) is used to selectively
delete mail items from a selected mail folder. where the mail item subject
matches a predefined string (MailSubject). This code works great except it
fails to delete the last item. If there are 10 items matching it will delete
9 but leave one behind. If there is only 1 it fails to delete it.
If I step the code i...
|
9 |
12/4/2008 2:43:01 PM |
|
|
how to use vba
I am a novice vba programmer,not even put my foot on first step of ladder. I
have bought a book on VBA and Excel but I have an urgent requirement to date
stamp my mail at work to protect myself. I found some code for a date stamp
Sub StampContact()
Dim objItem As Object
Dim objNS As namespace
Set objNS = Application.GetNamespace("MAPI")
Set objItem = Application.Ac...
|
4 |
12/4/2008 12:27:01 PM |
|
|
Can I access the Outlook Express .DBX file directly from VB.NET 2005
I want to create an application which will retrieve message headers and
messages and store them in a SQL database.
Does anyone know of a control or programming method which will allow me to
open and read the .DBX file format?
Thanks in advance.
...
|
4 |
12/4/2008 10:33:23 AM |
|
|
Outlook 2003 - create new menu
Hello all,
Is there any way to program a vba code that will do the following.
If i am highlighing a specific mail, and pressing right click on it
i would like to create a new folder in that menu and send the mail to a
specific folder in a local pst.
Is that possible?
Thank you
Amir ...
|
2 |
12/3/2008 6:29:19 PM |
|
|
Setting up a new outlook account programmatically
Hello, folks. I want to set up a new outlook account programmatically.
How can I do that? I looked at the MSDN Outlook library and found the
account object there http://msdn.microsoft.com/en-us/library/bb208228.aspx
But I see only readonly properties there. And even if they were not
readonly, I do not see the pop3-address, the password there....
BR
Ewgenij...
|
8 |
12/3/2008 6:27:06 PM |
|
|
Saving attachments from multiple emails
Hi, I'm new to VBA in outlook (though have been learning with excel)
I'm looking for a way to save the attachments from multiple emails into
a single folder automatically then mark the emails as read.
Ideally I would like to select all the emails and process the
selection, if this is not possible then I could move them all to a
specific folder first.
Any help in pointing me in the right dire...
|
4 |
12/3/2008 5:44:46 PM |
|
|
Recurring email and attachments
I have been using various help tools and was able to create a script that
creates a recurring email that meets most of my needs. I am looking to add
an attachment to that email. I have looked at several posts on this help and
can't seem to make any of them work. Can you help incorporate this into my
script. Current script is posted below.
Sub Item_PropertyChange (ByVal Name)
Selec...
|
2 |
12/3/2008 3:21:56 PM |
|
|
Deleting old messages
I want to have a script run automatically every day that will delete messages
in my deleted items folder that are over 60 days old. Is there a script that
somebody has already set up that I can use? I am not an Outlook programmer.
Thank you.
ngg...
|
2 |
12/2/2008 8:50:06 PM |
|
|
Extracting data from an e-mail to Excel
I am stymied..
I need to extract data from a series of e-mails, in each e-mail there are
two fields that need to be identified, and from those lines the numbers need
to be extracted and placed in a spread sheet for further analysis.
IW numbers would start in A1 and further data added below that, where as ST
would start in B1 and also collect data below that.
I have added a sampling...
|
2 |
12/2/2008 3:47:34 PM |
|
|
print preview and user properties...
I am sending user properties with the email created using my outlook add-in.
When I try to print preview it shows all the custom properties. In regular
printing I can cache the properties but print preview doesn't seem to have an
object that you can use. Is there some way to hiding the custom properties
when previewing..am I missing something simple?
Thanks!
...
|
2 |
12/2/2008 3:31:14 PM |
|
|
Copying selected text from a message body
Is there a way to (with code) copy user-selected text (within an email body
or other outlook object)?
I've created a form that captures several mailitem objects (SenderName,
SentOn, and Body), but I don't want the entire body. I'd like to give the
user the option of highlighting specific text and, with a command button on
the form, having it copy-pasted into the appropriate textbox on the...
|
5 |
12/2/2008 3:16:30 PM |
|
|
Macro names not available in script window
I created a macro to save message details to MS Access. I want to run this
macro when the message is received based on a rule. The problem is when I
create the rule and select the run script option, none of the macros appear
in the Script window. What do I need to do to make this macro appear in the
window....
|
2 |
12/2/2008 3:00:52 PM |
|
|
ANY WAY TO MAKE COMPLETED TASKS SHOW AS HIGHLIGHTED?
Just wondered if there was a way to change the display of completed items
from strikeout to highlighted in tasks. if it can be done programatically,
how advanced would one have to be to make it happen.
thank you,
Darren...
|
2 |
12/2/2008 2:58:22 PM |
|
|
run macro when autoarchive stops
How to catch autoarchive stoping event in outlook 2003 to run specific macro?
What I need is macro which is run after autoarchive function completes and
then macro copies autoarchive.pst file to network drive, when user is
connected to specific network subnet.
The problem is I don't know when to run it.
...
|
4 |
12/1/2008 4:51:46 PM |
|
|
AppointmentItem's lable color in public folder on exchange server.
hi,
I am trying to update the AppointmentItem's label using C# and ExMAPI. Its
working well for local folders but the label's color is not getting updated
in case of the public (shared) folders on exchange server.
How can i update the label's color of AppointmentItem on exchange server?
Thanks
Sudhir
...
|
2 |
12/1/2008 2:08:40 PM |
|
|
Embedding Images in Outlook email via Delphi
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 below). ...
|
1 |
12/1/2008 8:36:08 AM |
|
|
Archives
Allô!
Microsoft Outlook 2003...
Is it possible to manage Achives parameters with VBA code ??
(period, archive name, archive folder, etc)
If it is possible, where find information to begin to learn how do that ?
I have around 680 clients to make standard.
I make VBA code so easy in Excel. I have to learn Microsoft Outlook
mecanic.
Thanks for give me a hand.
GFortin
-----...
|
4 |
11/30/2008 11:47:06 PM |
|
|
Starting out help
I've created a macro in ThisOutlookSession under the event Application_NewMail.
This works fine in the debugger..
Is there a god beginner link where I can find documentation how to get this
setup to run automatically.. I'm missing something here..
Thanks..
--
Dave...
|
4 |
11/27/2008 6:37:52 PM |
|
|
RDOAddressBook.Resolve
Is it valid to pass in an email address for the name paramater on
RDOAddressBook.Resolve() and expect to get a valid address entry back?...
|
2 |
11/26/2008 7:57:13 PM |
|
|
Textboxes not poplating from listbox
Hello there :)
I am making an update delete form that should function such that my listbox
is populated based on a combobox selection, and then when a record in the
listbox is selected the data is put into textboxes that can then be updated,
or the record can be deleted.
My form populates the listbox based on the selection made in the combobox,
but the textboxes remain blank when I s...
|
2 |
11/26/2008 5:53:05 PM |
|
|
Adjust view for all message folders in a run
Hi,
Outlook 2003
Working with it for more than a year, so many folders for keeping some order
in all messages I need to keep at hand
I want to apply the same formatting of columns when viewing foders in a run,
instead of applying it manually to the 30 more folders I have. I want to
adjust width of columns, which columns I display in what order etc ( by
columns i mean those in the ...
|
2 |
11/26/2008 5:51:07 PM |
|
|
Favorites items in Outlook
I have a favorite folder in outlook. Is there anyway that I can address that
items in this folder (Favorites) and select and item. Then read the messages
in that item or folder.
If it is, can someone provide me the URL to read on How to do that? Or refer
me to some code samples.
I have been searching but not able to find any information on it. This
folder points to an Exchange Serv...
|
2 |
11/26/2008 5:48:56 PM |
|
|
Missing Store ID parameter for NameSpace.GetAddressEntryFromID()?
Why doesn't NameSpace.GetAddressEntryFromID() (http://
msdn.microsoft.com/en-us/library/bb175345.aspx) have a store ID
parameter like NameSpace.GetItemFromID() (http://msdn.microsoft.com/en-
us/library/bb219902.aspx)?
Should I infer something about address entries based on this
discrepancy?
Thanks,
Jeff...
|
3 |
11/26/2008 1:34:40 PM |
|
|
Outlook script macro issue
Hi,
I've created a script for use with a rule in Rules Wizard and have put it
into a module in my VbaProject.OTM. The first times that the rule runs it
works fine. However, after some time it stops working without giving any warn
or error. It seems like if it doesn't execute.
The only way I have found to make it work again is deleting the
VbaProject.OTM, restarting Outlook and typing...
|
9 |
11/27/2008 5:55:01 PM |
|
|
public folder calendar
i wrote a vba to extract some calender items in public folder calender for
rendering a web page.
it is time-consuming to loop through each items in public folder. Most
items are very old and not relevant. i only wish to extract those items
from now to future.
is there any faster way to do it?
Thanks a lot.
tony
...
|
3 |
12/4/2008 10:02:13 AM |