|
Retrieving Calendar Info
Can anyone tell me why this code (VBA Excel2003) is NOT returning recurring
meetings? Thanks.
Sub Get_Meeting_Details()
Dim myOlApp As Outlook.Application
Dim myNamespace As Outlook.Namespace
Dim myMeetings As Outlook.Items
Dim myItems As Outlook.Items
Dim myItem As Object
Set myOlApp = CreateObject("Outlook.Application")
Set myNamespace = myOlApp.GetNamespa...
|
3 |
12/19/2008 10:06:02 PM |
|
|
Send message with attachment
I need to be able to automate creating a message, attaching a file, and sending the message without manual intervention. I can create the message with an attachment in several different ways, but I haven't been able to find a way to automate the sending of it. I have been able to create a macro in Outlook and manually run it successfully, but I can't run it using the outlook /autorun switch. I fou...
|
2 |
12/19/2008 9:28:16 PM |
|
|
Interface not supported at Redemption.IRDOSession.set_MAPIOBJECT
Hi Guys,
I have posted the similar error previously to the following thread and
thanks to "Dmitry Streblechenko", with his suggestions it was fixed by
re-installing the error.
http://groups.google.com.au/group/microsoft.public.outlook.program_vba/browse_thread/thread/9531a18e576becaf/16aa1ddd6edcf937?hl=en&lnk=gst&q=Interface+not+supported#16aa1ddd6edcf937
Now, I am randomly getting t...
|
8 |
12/19/2008 7:35:31 AM |
|
|
Setting up a reminder for an appointment.
Hello,
I have been putting this together to control the cases I work on. I am Using
Excel 2003. I have a work sheet were I enter details of the cases I work on.
One of the cells has the date I sent the Individual or company a letter or
fax. I want to create an appointment 15 days out from this date , and to
remind 15 minutes on the day of the event (so i can call the individual as a
...
|
4 |
12/19/2008 3:49:01 AM |
|
|
Table Question in Outlook Email
I've created a template in Outlook
In the body I have a created a table - and have been manually entering the
data - but am looking for a way to take:
Row 1 Column 2 of table to be the Subject line
Row 2 Column 2 of table to be the name of the person in the To:
Is there a way to get this so that it automatically does it? VBA? Maybe?...
|
5 |
12/18/2008 9:57:02 PM |
|
|
Need money
You need fast money?????, visit http://dinero4ever.blogspot.com
Now!!! ...
|
1 |
12/18/2008 3:22:27 PM |
|
|
Need money
You need fast money?????, visit http://dinero4ever.blogspot.com
Now!!! ...
|
1 |
12/18/2008 3:22:07 PM |
|
|
Slow retrieving items from Outlook
I am accessing Outlook from Access VBA and whilst the following code works
just fine it seems really slow to just show a list of the mail items that are
in the Inbox are there any suggestions on how this could be speeded up.
Set objFolder = objOutlook.GetNamespace("MAPI").GetDefaultFolder(MailBox)
With objFolder
lngCount = .Items.Count
...
|
12 |
12/17/2008 6:57:01 PM |
|
|
Rules In Error: The Operation Failed.
Hi 2 All!
I've faced with very strange problem:
I have rule fires after arrival of the letter and execute VBA script ("run a
script" option) located in the ThisOutlookSession Module.
It looks like:
------
Sub FailTest(Item As MailItem)
'Log ("FailTest")
End Sub
------
Yes, it does nothing :) In the original there was a useful logic, but I've
simplified code to localize a place...
|
1 |
12/17/2008 7:03:04 AM |
|
|
Forcing "From" field value in oft template document
Hi
I am currently creating a simple template for use by some folks who will be
using the same Email account, and therefore already have priviledges to use
this account.
Because we will be constantly using this outlook form, I want to create one
template, with most of the fields we need already filled in - then we would
only need to call this standard outlook form from a button create...
|
5 |
12/16/2008 7:45:04 PM |
|
|
Retriving a Failed Recipient' email address
I am just wondering if there is a small VBA routine for Outlook 2003 that
will help me to automatically "reterive" (saving in it on an EXCEL file) a
Failed Recipient' email address. The bounced emails will be "manually"
re-located on a separate Inbox' folder. Thank you....
|
2 |
12/16/2008 7:42:08 PM |
|
|
How do I embed image in Outlook Message in VBA?
Hi, I have a macro that auto sends out emails. However I'm encountering a
problem with add a logo image into the email message. I searched the net
about this topic and the only example I found uses MSMAPI32.ocx and CDO to
embed the image. However the MSMAPI32.ocx I downloaded doesn't contain all
the types in the example like: Attachments, Fields, Field that are used in
the example.
...
|
5 |
12/16/2008 5:59:01 PM |
|
|
Clicking on the inbox folder of my outlook account or the display method of MAPIFolder
Hello, All. Currently, I am programming a tool which is supposed to
set a group of outlook settings programmatically. For that purpose I
simulate manual clicking through the Outlook with my program code.
Now, I encountered the following problem:
I want to "click" on the Inbox symbol in my Outlook folder bar.
Currently I do that this way:
FpApp := CoOutlookApplication.Create;
FpApp.GetNa...
|
3 |
12/16/2008 5:04:20 PM |
|
|
SaveAsOutlookContact
Microsoft Access has a new feature that allows one to send contact
information from a form directly to outlook however I can't find enough
information on how this is done. I have posted on the access site but have
received no answers.
Has anyone been able to do this? Can you provide somewhere I can find more
information on what is expected in outlook to make this work. I have tried a
...
|
1 |
12/16/2008 4:11:01 PM |
|
|
Getting handle of an active dialog window
Hello, all. Currently, I write a tool, which clicks through Outlook
2007 automatically. I have selected the inbox of one of my accounts.
Then I clicked on "View" in the main outlook bar. Then I clicked on
"Current View" in the opened command bar. Then I clicked on "Customize
current view" in the new opened command bar. Everything worked so far.
But after the last click a dialog window opened....
|
7 |
12/16/2008 3:35:27 PM |
|
|
Send emails to an access database?
My company recently banned pst files and will only allow emails to be stored
for 90 days (damn those lawyers) in my inbox. I was wondering if anyone had
any ideas how I could go about running a macro and have it save the file into
an access database? the pain i'm having is that when I have several email
messages come in for a project I'm working on, they all have the same title
and won...
|
4 |
12/16/2008 2:37:26 PM |
|
|
Redemption Shared Folder Problem when moving to Outlook 2007
We currently have an application that works with Outlook 2003. In order to
get the owner of a shared contact folder, we simply call:
Redemption.RDOSessionClass.GetFolderFromID() and then took that folder and
got the RDOFolder.Store.Name property.
However, when trying this with a shared contact folder in Outlook 2007, the
RDOFolder.Store.Name is null.
Everything still works fine f...
|
7 |
12/16/2008 2:11:01 PM |
|
|
Changes in Tasks
Hello,
I would like to replace text in the body of tasks. If the tasks are in an
outlook folder, i know how to do it:
Set myNameSpace = myOlApp.GetNamespace("MAPI")
Set myFolder = myNameSpace.GetDefaultFolder(olFolderTasks)
Set olTaskItem = myFolder.Items
For i = olTaskItem.Count To 1 Step -1
....
Next
But the tasks are saved in a directory (\\server\test\) as *.msg-Files...
...
|
4 |
12/16/2008 2:08:04 PM |
|
|
Resetting list of senders who have received automated replies
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 Outlook ...
|
1 |
12/16/2008 3:01:58 AM |
|
|
Show error message " No Such Interface Supported "
when i add the attachment to new maill,this message to be show.
who can help me to fix it! please ~~...
|
4 |
12/15/2008 2:02:19 PM |
|
|
Macro to insert date/time stamp into Notes?
Looking for a routine that will let me insert the current date/time in a Note
(or anywhere, I suppose).
TIA...
|
2 |
12/15/2008 11:47:38 AM |
|
|
Event of Changing the Task Status
I would like to be able to execute some code when the user changes the status
of a task from "Not Started" to "Complete"
Any help would be appreciated
Mark...
|
2 |
12/15/2008 11:41:01 AM |
|
|
On click event for mail item selection
I have a mail folder called MyInfo when I click on a mail item inside that
folder I want to execute vba code to go and grab details from a SQL Server
Database,
My problem is I cant find an "OnClick" event when a mail item is mouse clicked
Can any one help!...
|
5 |
12/15/2008 2:31:01 AM |
|
|
Automatically Save Attachment
Dear All,
I would like to know how to automate saving the attachment while I open
email. I have no idea where to start. I plan to write VBA. I do resecrh on
VBA and try to work on SaveAsFile Method, it doesn't work. Please give me
suggestions.
Thanks,
March
...
|
7 |
12/12/2008 7:52:08 PM |
|
|
Update Recipient Tracking from VBA
I get lots of meeting replies, so I have a VB routine that scans for postive
meeting replies with no additional notes added, and I move them to a folder
where I can bulk delete them.
My problem is that the response tracking is not updated. It will update if
I open the meeting response manually, but not with the code below. Is there
a way I can get the Response Tracking updated?
...
|
5 |
12/12/2008 5:33:09 PM |