Find Jobs
Hire Freelancers

visual basic script for outook

$30-250 USD

I përfunduar
Postuar over 5 years ago

$30-250 USD

Paguhet në dorëzim
I have a VB script for outlook calendar that will automatically change the color to one of 4 colors based on the status ie Accepted , declined , tentatively accepted and no response. However I cannot seem to get it working . I want someone who can look at the script and help me with the correct instructions to get it working on my version of outlook . Right now it just turns everything yellow. Here is the script Sub SetAppointmentColor() Dim olApp As [login to view URL] Dim olFolder As [login to view URL] Dim olItems As [login to view URL] Dim olItem As [login to view URL] Dim strText As String Dim bStarted As Boolean Dim i As Long On Error Resume Next Set olApp = GetObject(, "[login to view URL]") If Err <> 0 Then Set olApp = CreateObject("[login to view URL]") bStarted = True End If Set olFolder = [login to view URL](olFolderCalendar) Set olItems = [login to view URL] For i = [login to view URL] To 1 Step -1 Set olItem = olItems(i) Dim acceptedCount As Integer, notResponedCount As Integer, tentativelyAcceptedCount As Integer, declineCount As Integer, responseStatus As Integer acceptedCount = 0 notResponedCount = 0 tentativelyAcceptedCount = 0 declineCount = 0 responseStatus = 0 If [login to view URL] = "test1" Then For j = 0 To [login to view URL] If [login to view URL](j).name <> [login to view URL] Then Select Case [login to view URL](j).MeetingResponseStatus Case olResponseAccepted acceptedCount = acceptedCount + 1 Case olResponseNone notResponedCount = notResponedCount + 1 Case olResponseNotResponded notResponedCount = notResponedCount + 1 Case olResponseTentative 'tentativelyAcceptedCount = tentativelyAcceptedCount + 1 acceptedCount = acceptedCount + 1 Case olResponseDeclined declineCount = declineCount + 1 End Select End If Next j End If ' set default responseStatus = 10000 If acceptedCount + 1 = [login to view URL] Then responseStatus = olResponseAccepted End If If declineCount + 1 = [login to view URL] Then responseStatus = olResponseDeclined End If If acceptedCount + declineCount = 0 Then responseStatus = olResponseNotResponded End If 'if you rename the catagory before, you need change to the corresponding name Select Case responseStatus Case olResponseAccepted [login to view URL] = "Green Category" Case olResponseNotResponded [login to view URL] = "Yellow Category" Case olResponseDeclined [login to view URL] = "Red Category" Case Else [login to view URL] = "Orange Category" End Select [login to view URL] Next i Set olApp = Nothing Set olFolder = Nothing Set olItems = Nothing Set olItem = Nothing End Sub Private Sub Application_Startup() SetAppointmentColor End Sub
ID e Projektit: 18261493

Rreth projektit

4 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Hello! I've reviewed your script, and although I don't have much experience with Outlook specifically, I've noticed a glaring issue. Once fixing that issue, your problem should be resolved. If fixing that issue doesn't fully resolve your problem, then I'll need to further investigate, which will require installing Outlook and then running tests with the script, which I can't provide an exact time estimate on. Let's discuss further. Thank you for your time!
$50 USD në 0 ditë
5,0 (25 përshtypje)
5,0
5,0
4 freelancers are bidding on average $155 USD for this job
Avatari i Përdoruesit
Hello Sir, I am an expert in VBA and Scripting and I would like to work with you on this project. I am sure we can resolve this issue very quickly. Thanks Aanvik
$164 USD në 3 ditë
5,0 (53 përshtypje)
6,8
6,8
Avatari i Përdoruesit
Greetings, I hereby offer my services to help you color outlook calendar according to statuses. I am expert .Net developer with hands on experience on multiple platforms. I have seen your script but its better if I can get my hands on the code and can debug. Do you mind sharing your code in order to debug and fix the problem? Looking forward to discuss more. Best Regards
$250 USD në 2 ditë
5,0 (26 përshtypje)
6,5
6,5

Rreth klientit

Flamuri i UNITED STATES
Medford, United States
0,0
0
Mënyra e pagesës u verifikua
Anëtar që nga nën 29, 2018

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.