|
Capturing cursor window
I am writing a routine to allow a user to classify an email from a drop down
box that will be placed on the main menu of Outlook.
I want to disable the lookup unless the user has an item with a mail address
in it.
For example, for a calendar item I don't want the selection box to be
enabled.
Is it possible to
a) identify what sort of item the cursor is positioned on
b) enable/...
|
3 |
5/16/2007 6:37:10 AM |
|
|
attach file with automation in Outlook
My program;
> > #define mailitem 0
> > oOutLookObject = CreateObject("Outlook.Application")
> > oEmailItem = oOutLookObject.CreateItem(mailitem)
> > WITH oEmailItem
> > .Recipients.Add([test@PLANET.NL])
> > .Subject = [TEST]
> > .cc=[ ]
> > .Importance=1
> > .Body = [ ] ??????? && here i need to attach a file *.msg or *.dot
...
|
5 |
5/15/2007 8:13:04 PM |
|
|
Unable to add "X-Header" to a mail that is being sent...
Environment:
-Outlook 2002(XP)
-Added references to "Microsoft Outlook 10.0 Object Library" & "Microsoft
CDO 1.21 Library"
I have written a VB project using MS Visual Basic 6.0. My intention is to
add a X-Header to a mail that is being sent from
Outlook. I am capturing the ItemSend event and trying to add the header in
that event handler.
Please find the complete source code b...
|
8 |
5/15/2007 4:55:36 PM |
|
|
Identifying components of email message
I am having difficulty trying to determine how to address the body of an
email message for a search.
Once I have pointed to the correct MAPI location, how do I tell the macro to
search the body of the email for a string?
I have been able to get pointers and indexes and boolean responses, but not
able to address the actual text of the body of the message for the search.
All sugge...
|
5 |
5/15/2007 4:41:02 PM |
|
|
Delete message after sending
I am running VBA behind Excel to send spreadsheets automatically. These
attachments are bogging down my Sent Items. So I am exploring two options.
Option 1: Ideally, I would like to add code within the Excel sheet after
sending the email to automatically delete. That way it would work for any
user running the macro from any machine.
Option 2: Other option would b to program within Outl...
|
3 |
5/15/2007 3:58:03 PM |
|
|
Set Item.SaveSentMessageFolder = objFolder run time error '424'
when running this macro in outlook run time error '424' occurs. when i
debug, i am taken to the line: Set Item.SaveSentMessageFolder = objFolder is
hilighted as the error. how do i fix this? the purpose of this macro is to
automatically be asked for a folder to store the message in after it is sent.
Private Sub Application_ItemSend(ByVal Item As Object, _
Cancel As Boolean)
Dim...
|
14 |
5/15/2007 3:06:03 PM |
|
|
Configure RPC over HTTPS
Rather than use the Office Resource Kit and the custom installation wizard, I
wanted to know if there was a way to configure RPC over HTTPS via a vbscript
file that my users would run on their laptops or external workstations. Most
of the Office installations are done either after the fact or by the
manufacturer of the computers; so we don't have a chance to run a custom
installer. Is ...
|
1 |
5/14/2007 7:46:00 PM |
|
|
Use of AdvancedSearch with wildcards in Outlook
I have been trying to build a search routine that will open the inbox and
cycle through the body of each message looking for a string that I define
using wild cards and the Like operator.
Here is the code snippet:
------------------------
Do While n < filecount
Set myitem1 = myFolder.Items(n) 'iterate through items in inbox
' send (myitem1) to a string search
Dim ob...
|
16 |
5/14/2007 4:58:01 PM |
|
|
moving email to subfolder
Hi. I have a macro (generously donated by Ken) which I have adapted to move a
throw-away email that I am sending to a temporary folder. The line:
objInbox.Folders("Temp Sent") does the job, but the folder is not in the
right place. I would like this Temp Sent folder to be a subfolder to the
standard Sent Items folder. Any ideas on the change to the syntax? Thanks....
|
5 |
5/14/2007 6:12:01 AM |
|
|
dialing codes
How can I add dialing codes such as 1 in Business Phone Number Field?
I found the code to do so with Business Fax Numbers but can't figure out the
Busines Phone Number field...
Thanks,
Lucie Chénier
...
|
2 |
5/12/2007 4:25:28 PM |
|
|
Read multiple workbooks and pulling data from diff cells
Hello,
Can anyone help to modify this code to read/copy specific cell data from the
myfile and send it or assign it to my active workbook? my active workbook
will be my "master" workbook where I'll be gathering all data. The "myfile"
(source files) are not in a columns and rows format, therefore I need to type
specific cell references. ( the "master" file will in in a row and column
for...
|
2 |
5/12/2007 4:23:56 PM |
|
|
Help - I trashed my menu bar
I was trying to add and then remove an item to the menu bar
The add went fine but something in my logic caused me to delete the "file"
menu item and fiddling around a bit I lost the next two items off the main
menu before I realised that each delete was removing the next item on the
menu.
No matter what I do I cannot find out how to get the menu bar items back ...
the customize toolb...
|
3 |
5/11/2007 5:31:04 PM |
|
|
Code modification help for moving
From a post on 9.13.2005 the below thread was discussed. I am trying to
modify the suggested code to work for me in Outlook 2003 (11.8118.8122) SP2,
Office Professional edition.
When I try to run the macro it has a Compile Error: Can't find project or
library for the strname portion of this line
strname = Item.Subject
I have looked in the object brower and can not locate where this migh...
|
2 |
5/11/2007 5:07:13 PM |
|
|
Task Limitations Needing Alternate Route
It is understood that a user in unable to assign a task from a public folder.
However, I would like to know what (if any) Microsoft applications, add-ins,
create ideas any may know about regarding the following scenario:
From a shared/centralized location, multiple users must have the ability to
create and assign a "task" to another person (in another department); the
assignee updates t...
|
6 |
5/11/2007 3:22:44 PM |
|
|
Emailing by VBA program using Outlook
A friend showed me how to build a program to send emails to people listed in
a database. We have a bunch of monthly reports, all with the same name, all
going to the same people in 21 counties, every month. The program works
fine, but when Access sends the message to Outlook, every message requires
about 10 seconds while the green line goes across the bottom and then I have
to hit the ...
|
2 |
5/10/2007 8:16:47 PM |
|
|
How to have Outlook create folder if folder is not present?
This macro is missing code to create the folder, if the folder
"Outlook embedded graphics" isn't present.
What does this need to check for this folder, pls, and to create it if
it isn't there?
************************************************************************************
Sub SaveAttachment()
Dim objCurrentItem As Outlook.MailItem
Dim colAttachments As Outlook.Attachments
Dim objA...
|
11 |
5/10/2007 7:31:13 PM |
|
|
IS this possible?
I have a form with option buttons, 1 combobox, 1 textbox and a few buttons.
What I am trying to do is to get a value and put it in the textbox based on
what is in the combobox and what is selected from the option button.
My problem is that when I select an option and input a value into the
combox, the text box is still empty. What am I doing wrong?
For Each optProject In fraProject.Cont...
|
2 |
5/10/2007 7:29:22 PM |
|
|
Open folder with vba code launches a new window
I have Outlook 2003. Basically I have an email in my inbox and when I run
this macro, I want the email to be moved to the folder "Problem
Report\Laptop" and then open this folder. My code works fine, but it's the
last line
(e.g. objFolder.Display) that I don't like. I want to open the folder, but
not launch a new window. If I manually open different folders, new windows
don't open ...
|
3 |
5/10/2007 1:56:00 PM |
|
|
Get the name of the users default signature
I have manganed to get the user name from WSHNetwork and have formatted and
inserted everything else I need for the custom message but I cannot find how
to get the name of the user's default signture for new messages. Don't want
to change it just get the name for insertion.
Tried to search fully before posting. Thanks in advance.
...
|
7 |
5/10/2007 12:17:53 PM |
|
|
How can I automatically save an attachment to a folder
I need to be able to save an attachment without having to physically open the
email and then save the attachment. Is there a macro or something I can use
to do this?...
|
2 |
5/9/2007 9:54:35 PM |
|
|
How to display Addressbook from VBA
Hi,
I'm creating a userform in VBA and have a button placed next to a textfield.
What i'm trying to acomplish is that when the user clicks the button the
addressbook (for contacts) shows up and select the contact they would like.
When the addressbook is closed I want the selected emailaddresses to be
placed in my textbox.
So it's not the contacts folder that I want to see but the add...
|
5 |
5/9/2007 7:10:01 PM |
|
|
Do I need to dl the library(??); how to fix error message?
The script involved is this one, a very slightly modified version of the one
kindly provided by Ken Slovak:
**************************************************************************************************************
Sub SaveEmbeddedGraphics()
'1. Make sure you have a reference set to IWshRuntimeLibrary,
' C:\WINDOWS\system32\wshom.ocx, in Tools, References of the VBE (Ken
Slovak)
...
|
4 |
5/9/2007 6:29:53 PM |
|
|
get To/Bcc/Cc of my mail in my inbox, when I have a lot of smtp ad
Hello, I have a user with a lot of smtp address : when this user receives a
new mail, I want to know who I am for the sender (both internet or
internal(exchange)) .
Field TO : Internet mail : I read it from header
Internal : outlook remap with internal name and I don't know the
real name
Field Cc : Internet mail : I read it from header
Internal : outlook remap with inter...
|
3 |
5/9/2007 3:33:02 PM |
|
|
Strange error numbers when running code
Good afternoon all.
After 20 years since I didn't wrote a single line of code I have
started to write some VB code for Outlook.
Installed on 10 Pc without any problem (both Windows 2000 and Windows
XP with Office 2003 Sp2, Outlook build 11.6568.6568), on a single
Windows XP client the code returns all those error messages all
together:
Error description: Outlook cannot do this action ...
|
9 |
5/9/2007 10:15:05 AM |
|
|
Shortcut to un-hide Outlook 2002 envelope in system tray?
I would like to have a macro to reduce 7 keystrokes down to two, in Outlook
2002.
I would like the macro to un-hide the envelope icon in the lower right
corner of the screen.
I (or anyone) can hide the icon by right-clicking it and selecting "hide
envelope†when we don’t want to be distracted by new email. So, one click!
But…to unhide it takes 8 clicks (tools, options, emai...
|
2 |
5/8/2007 7:04:25 PM |