A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Search Forums
Reload this Page Search Results
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Showing results 1 to 16 of 16
Search took 0.03 seconds. Search: Posts made by: Nigel RS
Forum: Outlook and VBA November 25th 08, 04:58 PM Posted to microsoft.public.outlook.program_vba
Replies: 8
Views: 1,207
Posted By Nigel RS
Deleting Mail Items - Code

Hi Ken
I modified my code as suggested by using a count down structure, however it
still does not delete the last item that meets the criteria !! Stepping
through the code the test is applied and...
Forum: Outlook and VBA November 25th 08, 04:30 PM Posted to microsoft.public.outlook.program_vba
Replies: 8
Views: 1,207
Posted By Nigel RS
Deleting Mail Items - Code

Thanks Ken, I guess it is similar to deleting rows in Excel. I will change
it to a down counter.

Cheers

"Ken Slovak - [MVP - Outlook]" wrote:

Don't use For Each loops or up counting For loops...
Forum: Outlook and VBA November 25th 08, 02:26 PM Posted to microsoft.public.outlook.program_vba
Replies: 8
Views: 1,207
Posted By Nigel RS
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...
Forum: Outlook and VBA November 25th 08, 09:30 AM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 656
Posted By Nigel RS
Accessing Attached MailBoxes

Hi Dmitry
How would I use that?

I do not see this event in the ThisOutlookSession class.

Thanks
Nigel


"Dmitry Streblechenko" wrote:
Forum: Outlook and VBA November 19th 08, 03:17 PM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 1,483
Posted By Nigel RS
Move item between folders

Hi Ken
Thank you very much, but I am not sure I follow everything you said....

In Class1 module I have added the following.....

Private WithEvents colItems As Outlook.Items
Private oFolder As...
Forum: Outlook and VBA November 19th 08, 12:19 PM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 1,483
Posted By Nigel RS
Move item between folders

I currently have some VBA code that runs when an mail item arrives in my
inBox, this is triggered by Inbox Rule. That works fine.

I now need to be able to run some code when a user manually moves...
Forum: Outlook and VBA October 21st 08, 04:07 PM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 2,978
Posted By Nigel RS
Saving email attachments

Sorted - there are non-printable characters in the MailItem.Body, I have put
in a function to strip these out and everything works as expected.

Cheers

"Nigel RS" wrote:

Hi Ken
I have changed...
Forum: Outlook and VBA October 21st 08, 03:22 PM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 2,978
Posted By Nigel RS
Saving email attachments

Hi Ken
I have changed the path by setting it directly

SaveFolder = "D:\"

not from itm.Body and it works OK!!

Very strange, as in debug mode the text string looks identical.

"Ken Slovak - [MVP -...
Forum: Outlook and VBA October 21st 08, 03:03 PM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 2,978
Posted By Nigel RS
Saving email attachments

Hi Ken
I get the path D:\myfile.xls (for example) which is a valid path, yet the
message from Outlook says...

Runtime error - 1525219205
Cannot save the attachment. Filename or directory name is...
Forum: Outlook and VBA October 21st 08, 12:48 PM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 2,978
Posted By Nigel RS
Saving email attachments

I am using the following code, that runs from an outlook rule, to save
attachments
to a path defined by the contents of the email body. For example in my
email body I have the text string
D:\

I...
Forum: Outlook and VBA August 21st 08, 05:01 PM Posted to microsoft.public.outlook.program_vba
Replies: 3
Views: 695
Posted By Nigel RS
Selectively permanently from deleted folder

Any help to create the code to run from Excel VBA that will selectively
delete emails from the 'deleted items' folder in Outlook.

I send emails from Excel via Outlook and set DeleteAfterSubmit =...
Forum: Outlook and VBA August 15th 06, 03:20 PM Posted to microsoft.public.outlook.program_vba
Replies: 7
Views: 947
Posted By Nigel RS
Off-Line access to email via VBA

Thanks - what a pity! I always try to avoid un-neccessary user interaction
but it seems I am stuck with this one.

Cheers
Nigel

"Sue Mosher [MVP-Outlook]" wrote:

You can't really know until...
Forum: Outlook and VBA August 15th 06, 02:18 PM Posted to microsoft.public.outlook.program_vba
Replies: 7
Views: 947
Posted By Nigel RS
Off-Line access to email via VBA

Thanks Sue, I have through my current error-handler detecting this
situation. My real question should have been how can I detect if the user is
on-line or off-line before I attempt to create an...
Forum: Outlook and VBA August 15th 06, 01:26 PM Posted to microsoft.public.outlook.program_vba
Replies: 7
Views: 947
Posted By Nigel RS
Off-Line access to email via VBA

Hi Sue
That fixed it. I also added a error handler that detects if the attempt to
create an email fails which works great.

Another question: when I attempt to create the email in an off-line...
Forum: Outlook and VBA August 14th 06, 05:50 PM Posted to microsoft.public.outlook.program_vba
Replies: 7
Views: 947
Posted By Nigel RS
Off-Line access to email via VBA

Hi Sue
Since I created the thread I discovered that I cannot open outlook manually
when off-line, but other PC uses of the network can. I will try it on one
that can open outlook and get my pc...
Forum: Outlook and VBA August 14th 06, 05:19 PM Posted to microsoft.public.outlook.program_vba
Replies: 7
Views: 947
Posted By Nigel RS
Off-Line access to email via VBA

I have a laptop PC that connects to a microsoft exchange server via a VPN.
When connected I can attach files from the laptop pc to an email using VBA in
Excel. All works OK.
If I operate the PC...
Showing results 1 to 16 of 16

 
Forum Jump

All times are GMT +1. The time now is 12:45 PM.

Feed Icon - Contact Us - OutlookBanter Home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.