Need Help - Willing to pay

Status
Not open for further replies.

Bob C

Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
Greetings all. About 15 years ago, I believe it was in Office 2000, I wrote some custom code for some Outlook forms to manage our customers in a small business. It continued to work well through 2003, but then we started having issues with 2007. It would simply truncate random lines in the code, different each time, causing the code (buttons and such) to not work. Now with 2016, it just crashes Outlook if we click on any buttons. I am seeking someone with Outlook Custom Forms skills/knowledge to update and make work as I just do not have the time to get my brain back up to speed.(I originally wrote with help from here) Happy to compensate for your time. We moved to a hosted exchange server some time back.
 
Ok...I am uploading screenshots of the four form pages I created, along with the code. TIA
 

Attachments

  • Code.txt
    8.9 KB · Views: 503
  • Capture.PNG
    Capture.PNG
    129.6 KB · Views: 477
  • Capture2.PNG
    Capture2.PNG
    52.9 KB · Views: 478
  • Capture3.PNG
    Capture3.PNG
    63.1 KB · Views: 477
  • Capture4.PNG
    Capture4.PNG
    47.4 KB · Views: 484
in a quick look at the code between meetings, the code looks like basic code that should work. The only issue i see is a path to a word template - it's the old windows path, not the new one.

In Outlook, File, Options, Trust Center, Email Security, is scripted allowed in shared folders? This may not apply if the mailbox is opened as an account, but it's worth checking.

Is the form published to personal forms or to a folder (or org library)?
 
I have created the path/folder on each of the computers wanting to open this and saved the proper sheet.
The scripted was not checked, is now, no change
Forms published to personal forms

I have two behaviors that are happening. The first is, and this has been happening since at least outlook 2010, I am getting a "Script Error, Expected end of statement, Line No 185" I check Line 185 to find it has been truncated. I fix line 185, and then some other random line will get truncated. This is not all the time, just some times.

The bigger issue is now with Office 2016, Outlook just crashes.

I have saved as fdm (had to rename to txt, just change extension back to .fdm) and uploaded here...
 

Attachments

  • customer.txt
    285 KB · Views: 416
Well, it worked here until i hit the schedule service call button and schedule training. Mail new battery brought up a 'can't find file' error - i assume its looking for the word template which doesn't exist here.

Not sure it matters, but I'm, using 32-bit Outlook.
 
I think the problem is somewhere in the appointment code - it didn't crash when i removed the block from the scripts and tested. Also, i think the link code will fail - they removed some of that capability.

Code:
  .RequiredAttendees = "address@com"

  .Subject = Item.FullName & " Installation"

  .Location = Item.BusinessAddressStreet & "  " & Item.BusinessAddressCity & " " & Item.BusinessAddressState & " " & Item.BusinessAddressPostalCode

  .Start = Item.UserProperties("Installation Date")

  .Duration = 240

  .Body = Item.UserProperties("DirectionsText") & vbCr & vbLf & Item.HomeTelephoneNumber & vbCr & vbLf & Item.MobileTelephoneNumber & vbCr & vbLf & Item.UserProperties("Consult Notes") & vbCr & vbLf & vbCr & vbLf & Item.UserProperties("Breed") & vbCr & vbLf & Item.UserProperties("Pet Name")
 
Hmmm...yes, I am now consistently getting it to open and perform the Battery thing as I have the form. So are you saying all of the scheduling portion needs to be redone? Not sure I understand your point about "link code"
 
I'm thinking the problem is with the body or start date. Test it by removing all fields and add one at a time and test. See if it crashes.

This is the link code:
.Links.Add Item
it's deprecated and is not intended to be used in code but I'm not sure it would cause it to crash.
 
I'm pretty sure its one (or more) of the custom fields.

This works
Code:
    With objAppt
      .RequiredAttendees = "address@.com"
        .Subject = "In Home Consultation with "
        .Location = "here"
      .Start = now + 5
      .Duration = 90
        .Body = "This is the body"
    End With

i put these back in, and it works.
.Subject = Item.FullName & " Installation"
.Location = Item.BusinessAddressStreet & " " & Item.BusinessAddressCity & " " & Item.BusinessAddressState & " " & Item.BusinessAddressPostalCode
this crashed it
.Start = Item.UserProperties("Installation Date")
 
Wow...you rock. Ok, so that line of code is what I used to create an appointment in my outlook calendar. Perhaps there is new code for that now?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
S Custom Contact card - need help creating one Outlook VBA and Custom Forms 1
D Need help with MS Authenticator Using Outlook 4
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
S.Champ Please help? I've imported a random workcalendar I dont even know who's. Can I undo it? and then I need to re-sync the google one again. Its a mess:( Using Outlook 2
L Need help modifying a VBA script for emails stuck in Outbox Outlook VBA and Custom Forms 6
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
C need help setting up outlook first time Using Outlook 1
N Need help syncing contacts to iPhone X Using Outlook 8
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
E Outlook 2010 need help with rules Using Outlook 0
J Need Help with Contacts VBA Outlook VBA and Custom Forms 1
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
T Need help with finding/updating task Outlook VBA and Custom Forms 1
Denis Hi everyone!!! Need some help with Excel to Exchange Calendar??PLEASE>>> Using Outlook 1
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
G Need help configuring a PRF for Outlook 2010 and 2013 Using Outlook 0
K Excel Import Option: Need Help Updating Existing Records BCM (Business Contact Manager) 0
K Need help concerning emails linking to BCM. BCM (Business Contact Manager) 0
J Need help with installation of BCM in Outlook2013 BCM (Business Contact Manager) 5
F Outlook 2010 - Need help with a custom field. Using Outlook 3
D Need Help with Script. Keep getting Runtime Error 438 BCM (Business Contact Manager) 4
R Need help getting BCM to work with my Outlook 2014 Using Outlook 4
L Need help getting calendar/contacts/tasks/notes back! Using Outlook 3
R [VBA] complicated(?) outlook events - need help with code Using Outlook 15
P Need help/Gmail accounts show separately/Outlook 2013 Using Outlook 0
J Need Help Extracting Email Content into Excel Specifically the Attachment Name Using Outlook 3
A Need Help with BCM2010 Sharing on outlook 2013 Scenario! BCM (Business Contact Manager) 1
C Need Help with Simple Code Correction Using Outlook 11
W I Need help with vb.net and outlook 2010 Using Outlook 2
A My move to MS is not going too well: Need Help !!! Using Outlook 14
M Need help with combo boxes in messages! Using Outlook 10
D Need help understanding which pst-file to use! Using Outlook 0
U Need a help please Outlook 2007 crashing Using Outlook 2
Z Need Help Outlook 2007 inbox and address book view Using Outlook 2
B Need help adding a background color to the compact list items in Month view. Using Outlook 1
B Need help adding an image next to the Month Name in the header. Using Outlook 1
B Ok - a complicated one - but really need help (auto formatting) Using Outlook 9
P To Use BCM or not...I need help BCM (Business Contact Manager) 1
T Need help making RULE to prepend email SUBJECT Using Outlook 3
V Need help on configuring Outook 2003 Rules and Alerts... Using Outlook 2
X business owner in dire need of help outlook is not syncin my contacts! Using Outlook.com accounts in Outlook 2
D Need email verification for international emails, help? BCM (Business Contact Manager) 2
S MAcro - Need help in getting the recipients in to filed / cc field toput in an array Outlook VBA and Custom Forms 4
K Need help Publishing a new Task form! Outlook VBA and Custom Forms 1
A Need help in creating a mass emailing plugin Outlook VBA and Custom Forms 1
T need help w/ sending an e-mail -- outlook 2007 addin Outlook VBA and Custom Forms 2
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 10
P OT: Need website like this one, but for Excel Using Outlook 0

Similar threads

Back
Top