Avatar of Rob4077
Rob4077Flag for Australia

asked on 

MS Outlook auto update conflicts

I have written a VBA function that that is launched whenever a new email arrives in any one of about 6 email accounts and it does some processing, including allocating it to a folder, marking it as read and updating some records in a MS Access database. We use MS Exchange email accounts on MS Outlook and many of us share multiple email addresses but the VBA is only loaded onto my computer.

The concern I have is that if my computer is turned off for any reason, say on a day that I am not there, the processing won't happen, If I load the same VBA on all the computers then they will all be working on the same email as it arrives on each of them. Is there any recommended approach to manage conflicts. I don't really want every computer, for example, to launch the function to update the MS Access database.
OutlookVBA

Avatar of undefined
Last Comment
Rob4077
ASKER CERTIFIED SOLUTION
Avatar of Alex
Alex
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Rob4077
Rob4077
Flag of Australia image

ASKER

You mean on the server? Where can I get the software?
Avatar of Alex
Alex
Flag of United Kingdom of Great Britain and Northern Ireland image

No, I mean on a windows 7 or whatever your clients use on a VM hosted on your server. Do you have any virtual infrastructure?
Avatar of Rob4077
Rob4077
Flag of Australia image

ASKER

Ah. One for the tech crew when I go back to work next week. In the meantime I need to spend some time this weekend figuring out what you mean. Thanks for the info.
Avatar of Rob4077
Rob4077
Flag of Australia image

ASKER

Got it Thanks. Pretty sure we can handle that.
Outlook
Outlook

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

105K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo