Forum: Outlook and VBA
March 20th 10, 02:39 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 850
View emails sent by time range excl weekends
pmr wrote:
Want to create a query to view email by sent time range e.g. 9-5 excl weekends
Not an Outlook expert but you could set a filter.
Mon(1)-Fri(5) if vbMonday used.
?...
|
|
Forum: Outlook and VBA
March 9th 10, 03:49 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 990
Why can't I send email from Access?
Tim wrote:
I have written some VBA codes to email an Access form via Outlook,
i.e., DoCmd SendObject acSendForm, "frmInformation", etc. There is a do while
loop to send emails out depending...
|
|
Forum: Outlook and VBA
March 5th 10, 12:11 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 1,963
instr function
Joel Allen wrote:
Outlook 2003 SP3
Hi,
I'm trying to find * and ? in the string. Do I have to do two separate if
statements, or can I use some kind of OR statement? This isn't...
|
|
Forum: Outlook and VBA
February 28th 10, 07:33 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,164
Pickfolder, modOpenSaveFile, clsCommonDialog
wrote:
That you for the suggestion but as this is a newsgroup I would rather share
any dialog with the group
K. I doubt an Access app can be attached to a newsgroup message. Good...
|
|
Forum: Outlook and VBA
February 28th 10, 06:57 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,164
Pickfolder, modOpenSaveFile, clsCommonDialog
wrote:
Hi,all
I have a need to obtain a copy of a file that is contained in a folder (say
hold) in my personal folder structure of outlook. The file would then be
transferred to...
|
|
Forum: Outlook and VBA
February 25th 10, 10:16 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 1,851
|
|
Forum: Outlook and VBA
February 25th 10, 07:14 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 1,851
|
|
Forum: Outlook and VBA
February 25th 10, 10:22 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 648
Userproperty question
If I don't want to process certain emails is an Inbox folder, is one
method of doing so while scanning the folder's emails is to check the
value of a userproperty? For example, if the property...
|
|
Forum: Outlook and VBA
February 24th 10, 06:05 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 8
Views: 1,776
CreateObject(), GetObject() question
Michael Bauer [MVP - Outlook] wrote:
Years ago I've read that a so called script blocker could prevent you from
launching Outlook by code. I don't know any details. If that's not the case,
...
|
|
Forum: Outlook and VBA
February 24th 10, 04:52 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,583
Pickfolder question
Dmitry Streblechenko wrote:
So I am not sure what you are trying to accomplish: if you do not want to
see the Outlook Today web page, you can trun it off in the folder properties
(RMB on the...
|
|
Forum: Outlook and VBA
February 23rd 10, 07:17 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 8
Views: 1,776
CreateObject(), GetObject() question
Michael Bauer [MVP - Outlook] wrote:
Is anything highlighted when the error occurs?
Yes, if I enter Debug mode, the line
Set obj = New Outlook.Application
is highlighted in the code...
|
|
Forum: Outlook and VBA
February 23rd 10, 06:59 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,583
Pickfolder question
Dmitry Streblechenko wrote:
Is it because you have "Outlook Today" displayed for the top level folder?
I wish I knew what to reply. I dragged 5 old emails of various dates to
Personal Folders....
|
|
Forum: Outlook and VBA
February 23rd 10, 12:57 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,583
Pickfolder question
Michael Bauer [MVP - Outlook] wrote:
See the object browser (f2) for what properties are available for a
MapiFolder object. The one you're looking for is DefaultItemType.
Thank you. I came...
|
|
Forum: Outlook and VBA
February 23rd 10, 12:32 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,583
Pickfolder question
If I run
Set olfolder = olapp.GetNamespace("MAPI").PickFolder
and select a folder, the TypeName is always "MAPIFolder". Is there a
property or method to determine if it's an inbox item and not a...
|
|
Forum: Outlook and VBA
February 22nd 10, 10:35 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,607
MailItem Find Method question
Dmitry Streblechenko wrote:
Searching by subject is a bad idea, to put it mildly :-) What happens if you
have multiple messsages with the same subject?
Use the EntryID property and open the...
|
|
Forum: Outlook and VBA
February 22nd 10, 06:07 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,607
MailItem Find Method question
Dmitry Streblechenko wrote:
Under the hood, Outlook searches on the PR_NORMALIZED_SUBJECT (which does
not include the prefix), not PR_SUBJECT.
Where does the strSubject come from? Do you...
|
|
Forum: Outlook and VBA
February 22nd 10, 04:08 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 8
Views: 1,776
CreateObject(), GetObject() question
Michael Bauer [MVP - Outlook] wrote:
First, use GetObject to see whether Outlook runs already. You need to catch
the error for the case that Outlook doesn't run. If it doesn't try this
...
|
|
Forum: Outlook and VBA
February 21st 10, 11:28 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 6
Views: 1,607
MailItem Find Method question
Using the Find method to find a Subject, I have a couple of questions.
If the Subject is "Test", the following code finds the email. If the
subject is " Test", it does not. I have to remove...
|
|
Forum: Outlook and VBA
February 20th 10, 04:37 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 8
Views: 1,776
CreateObject(), GetObject() question
Michael Bauer [MVP - Outlook] wrote:
Does the code run in Outlook? Then don't use any of the methods; there's
already an Application object, which you should use.
Both methods are only...
|
|
Forum: Outlook and VBA
February 20th 10, 02:05 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 8
Views: 1,776
CreateObject(), GetObject() question
I have the following sub
Sub test()
'it doesn't matter which of these I use.
Dim olApp As Object
'Dim olApp As Outlook.Application
'always a (8007007e) error with following...
|
|
Forum: Outlook and VBA
January 28th 10, 08:27 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 5
Views: 596
Read/process in browser
DavidC wrote:
We have both situations. Most of the time Exchange is involved but sometimes
users go directly to the ISP mail server via pop3.
I would like to be able to copy the from email...
|
|
Forum: Outlook and VBA
January 28th 10, 04:53 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 561
Why are different email names displayed
JP wrote:
Someone correct me if I'm wrong, but I think it depends on the
sender's mail reader, whether Exchange server is involved, whether the
email is internal or sent from an external...
|
|
Forum: Outlook and VBA
January 26th 10, 12:28 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 0
Views: 376
Finding an inbox email question
I've spent awhile looking for a way to find an email on the web and
google groups. I'm not having very much luck, probably am not entering
the correct keywords.
I know the following...
|
|
Forum: Outlook and VBA
January 26th 10, 12:09 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 561
Why are different email names displayed
If I click on Inbox, I'll see my messages in the inbox pane. They might
look like
First Message
and if the email pane for viewing the message is visible I might see
First...
|
