|
scrolling Mouse over a TextBox
I Need and appreciate help on this:
I can't scroll with the mouse over a textbox, or list box. I have configured
the roller button as the middle button so that it can be recognized by VBA on
events. And it does recognized it as the "Button 4", whenever you pushed it,
but not when rolling it.
The functionality i need is the same we have on this text box, when rolling
the mouse the vertic...
|
1 |
5/8/2007 6:04:01 PM |
|
|
copy attachments for mail that arrives on a specific date
Hello,
I am able to write code (with the help of Martin Green's website) that can
copy attachments from the inbox or pst folder and put a copy of the
attachments on my network drive. However I would like to take it one step
further and have the VBA code look at the items in the folder and only copy
those attachments for mail that arrived on a specific date. For example copy
attachment...
|
8 |
5/8/2007 5:26:02 PM |
|
|
Outlook 2003 image copy
Hi all
When you right click an attachment in OL2003 there is a copy option.
What sort of data does it put in the clipboard as when it is a jpg etc I
can't seem to paste it direct into a photo editing application which would
be nice
The Copy option from the preview pane in Outlook express does work on the
displayed image and I can paste this successfully
Thanks in advance
Andrew
...
|
1 |
5/8/2007 4:17:51 PM |
|
|
Automatic action upon reception of a message
Hi
I need to execute a script when a message is received by a specific
sender and/or a specific subject and/or it contains some string in the
message text
Can I do that with vba?
Otherwise (even better) can I automatically create a txt
subject_sender.txt in a specific directory with the content of the e-
mail ?
thanks and regards
Nicola Attico
...
|
2 |
5/8/2007 3:27:40 PM |
|
|
how do I create an import spec in Outlook to import Access calend.
how do I create an import spec in Outlook to import Access calendar data.
I need to be able to easily if not automatically update public outlook
calendar
with updated schedule data from MS Access.
...
|
2 |
5/8/2007 3:25:15 PM |
|
|
Navigating to an email outside of Outlook
Is it possible to navigate to an email located at c:\sampleEmail.msg
using vb6 or vb.net to read the contents of the Subject and Body for
the purpose of searching?
Thanks,
Elliot Semmelman
...
|
7 |
5/8/2007 3:24:25 PM |
|
|
Message Prompts with Auto Reply
I have a script that runs when a message arrives that sends a reply message
back to the sender. I have two issues that I need to resolve.
1. The mailbox that the rule is setup on is an office mailbox that does not
get logged into. All the office personnel has the mailbox listed as an
additional mailbox. How can I get the rule to run a script without actually
logging into the mailbox...
|
6 |
5/8/2007 3:23:41 PM |
|
|
++++ Backup Macro Project1
A macro project called Project1 currently set up by default in Outlook 2002.
How do I back it up before deleting it and then create a new one from scratch
so I can restore it after finishing the test?...
|
3 |
5/8/2007 11:20:51 AM |
|
|
change of attachment file extn while composing mail from outlook
I have cognos that sends a .mht file from outlook. Do we have any macro that
can automatically change all mails sent with .mht file to .xls while
composing any mails from my mail box?
Thanks,
Chitra...
|
1 |
5/8/2007 4:51:00 AM |
|
|
++++ Can I use macro to monitor incoming messages ?
I created some macro in Outlook 2002 and run them manually. Can I use macro
to monitor incoming messages automatically? i.e. check each incoming message
in Inbox and re-direct them into different folders in real time. Similar to
Rules but VBA is more flexible. Thanks....
|
6 |
5/8/2007 2:54:02 AM |
|
|
+++ Macro Security
There is Trend Micro Anti-virus system installed on Domain including on
Exchange server and on PCs. I created a macro in Outlook 2002. Is it OK if I
set Macro Security to Low in order to run it automatically whenever Outlook
starts? Thanks....
|
4 |
5/8/2007 2:54:01 AM |
|
|
Help! trying to send emails through excel
Hello! So I have a problem.......its almost painful to explain b/c
i'm
just confused!
I've had this macro that worked for a few months. I came into today
and it doesn't work.....
When I use this code:
Set itm = doc.MailEnvelope.Item
I get this e0rror:
Run-Time error '-2147467259. Method 'Mailenvelope' of object_document
failed
So I tried to change the code to:
Set OutA...
|
1 |
5/7/2007 10:06:40 PM |
|
|
to open a file with good columns of the day to the screen
Hello,
Here my problem I have a calendar on Excel with quatres fixed columns of
various names then the other columns are dates. I manage well to put the
x-ray one on the good date at the opening of the file but not with the aprés
columns of continuation the names. The good columns are always in the middle
of the screen, i.e. with j-10, j-9, j-8, j-7, j-6, j-5, j-4, j-3, j-2, j-1,
J wi...
|
2 |
5/7/2007 7:58:19 PM |
|
|
Set itm = doc.MailEnvelope.Item
Hello Everyone,
I'm getting a runtime error that says: Run-Time error '-2147467259.
Method 'Mailenveloe' of object_document failed
I have read every posting about this and still can't seem to figure it
out. Whats wierd is that i've been using this macro for months and
all of a sudden this week it doesn't work! Any ideas on whats wrong?
The following is the code I'm using. Any help woul...
|
4 |
5/7/2007 6:33:36 PM |
|
|
Cached Mode on Outlook 2003 using VB script
I have 2000 users using outlook 2003, now I need then change their cached
mode on outlook 2003, so I create a little chi chi for them to do themself,
here is the step
1). from outlook, click on tools--> E-Mail Accounts.
2). Make suer the View or change existing e-mail accounts is checked--> next.
3). Under E-mail acccounts, high light Microsoft Exchange Server-->Change.
4)...
|
4 |
5/7/2007 5:50:02 PM |
|
|
design new mail from code in access
hi,
i have this code:
Dim objOutlook As Outlook.Application
Dim objMail As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim db As Database
Dim msg As String
Set db = CurrentDb()
Set objOutlook = New Outlook.Application
Set objMail = objOutlook.CreateItem(olMailItem)
msg = "hello," & vbcrlf & "good morning""
With objMail...
|
2 |
5/7/2007 5:03:38 PM |
|
|
Can I avoid the warning when I send mail from Excel
I have set up a Macro to send different views of a Pivot Table to different
people.
as follows:
"
ActiveWorkbook.SendMail Recipients:="A.N.Other", Subject:="TEXT FOR
RECEIVER"
ReturnWhenDone = True
"
When the Macro accesses Outlook it throws up a warning on screen Saying
"
A program is rying to automatically send Email on your behalf.
Do you want to allow this?
Y / N
"
...
|
2 |
5/7/2007 4:37:09 PM |
|
|
Mailbox Counter
Good Afternoon all,
I'm trying to acquire a VBA script for use in a macro that would be able to
tell me how many emails my account is recieving each day. I work in a busy
sales office, whereby 5/6 people all have access to this account. I've found
a code that could be useful through an affliated Microsoft site which i have
pasted underneath:
"Sub MailCounter()
Const olFolderIn...
|
2 |
5/7/2007 8:45:01 AM |
|
|
outlook web access tracking
If someone is using outlook web access to see my e-mail, can my IT Department
find out who is doing it....
|
1 |
5/4/2007 10:05:01 PM |
|
|
Email Selected or Not Macro Script
I have written a small application using ActiveExplorer, the thing is
if an email is not selected I still want to run the script, how do I
say if an email is not selected then still run the script. I guess I
am looking at an if statement, but when do I check it? I am guessing
it is at the ActiveExplorer set up, because if the is not one when
this runs it closes it with an error message. The s...
|
5 |
5/4/2007 9:00:29 PM |
|
|
changing the contact folder to something other than the default
I have 4 or 5 different folder with contacts in Outlook 2003 and use vba code
different times to access the contacts. I always have to temperarily move my
contacts out of the main contact folder, then move the contacts from another
folder into the main contact folder because that's where my code gets it's
data. Is there a way to tell the code to use another folder that I've made
in my ...
|
2 |
5/4/2007 8:59:22 PM |
|
|
please help with syntax
I'm writing a form in Outlook 2003. The code on the form is as follows:
Sub Item_CustomPropertyChange(ByVal Name)
Set myinspector = Item.GetInspector
Set myPage1 = myInspector.ModifiedFormPages("Message")
Set Textbox1= myPage1.Controls("Textbox1")'type is Date/Time'
Set Textbox2= myPage1.Controls("Textbox2")'type is Date/Time'
Set Textbox6= myPage1.Controls("Textbox6")'t...
|
2 |
5/4/2007 8:58:56 PM |
|
|
Need Help Adding Body Part
I want to add an Access generated .snp file to the body of a email message. I
thought I could do it with AddBodyPart in CDO, but I am unable to figure out
what
kind of content-type it is and now I am not so sure that is the way to do it
either. I see it can be done in the Outlook GUI by adding it as an Object
,however
I want to use CDO programatically. Could someone tell me if AddBodyP...
|
1 |
5/4/2007 5:46:00 PM |
|
|
Deleting sent items from outlook 2003
Hi
We have some business analysis software running that sends data out to our
salespeople by e mail attatchment, the largest being 7mb. I need to be able
to delete these e mails automatically once they have been sent, firstly from
sent items and then from deleted items.
I have tried using rules but with no success.
Any help would be greatly appreciated.
Many thanks ...
|
3 |
5/4/2007 3:49:01 PM |
|
|
Enable/Disable Macros when walking public folders in loop
I'm extracting data from Outlook to put into another program. I wrote a
program in VB6 to do it because we use a custom form for public contact data
and it has over 600+ custom fields in it. On 2 contacts, I'm getting an
Enable/Disable macros dialog but I can't determine why? Where are all of the
possible places I can look? The form itself does have some code behind it
but this only happ...
|
4 |
5/4/2007 2:28:08 PM |