• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Recent content by George Z

  1. G

    How to Copy Multi Select Listbox Data to Appointment

    Not sure how to apply this as you are stating. I am joining the array and displaying as message. I need the join to be included in the subject with data from other sources. Below is code for the Form. I bolded the lst reference also bolded line from macro code adding data to subject. How do I...
  2. G

    Copy Contact field to Appointment Custom Form Field

    So so long getting back to you. Could not get either working. I tried to figure it out today and Friday last week without luck. I have created the field "Customer Name" as a text field on my custom form. Was not 100% if I had to Dim the MyItem so I tried with and without the Dim. Below is my...
  3. G

    Copy Contact field to Appointment Custom Form Field

    This is proving to be more challenging than I expected. Via the help of this forum I have a custom appointment form and use a VBA macro to copy data from contact fields, to the default appointment fields. How do I copy the "Company" field (from contacts) to a text box field in my custom...
  4. G

    How to Copy Multi Select Listbox Data to Appointment

    With the help of various tutorials in this form I am trying to combine input data from several different input types into an outlook appointment item. With your assistance I have been able to include data from both message boxes and list boxes. How do you also include multiple selections from a...
  5. G

    Using Data From Combo Box in Appointment Body

    Sorry so log getting back to you. Had to back burner this for a minute. I did not have it at the top of the module. However I do now, and all is working as beautifully. Your the woman Diane. Thank you for your continued support and assistance. I am having a few issues now getting multiple...
  6. G

    Using Data From Combo Box in Appointment Body

    Just checking in, anyone have any additional feedback on this?
  7. G

    Using Data From Combo Box in Appointment Body

    I am still coming up short on this. I sure you are sifting through numerous posts. Just wanted to see if you had any time to look into it a bit further as of yet.
  8. G

    Using Data From Combo Box in Appointment Body

    Thanks Diane. Getting very close. As you stated, this method does seem to be working..... sort of. When run it is populating the aapt.body with both the data from the cobbo box plus the data from the text box. However, regarding the combo box it only pulls the Case 0 strbody which = "subject 1"...
  9. G

    Using Data From Combo Box in Appointment Body

    I am attempting to take a different spin on the tutorial below: Select from a List of Subjects before Sending a Message Select from a List of Subjects before Sending a Message I am attempting to utilize this form and macro for adding data to the body of an appointment item. Currently my macro...
  10. G

    Addition of 2 fields based on checkboc true or false

    Thank you Diane. Works Beautifully. Some of this VBA is beginning to make sense. I know..... Scary!
  11. G

    Addition of 2 fields based on checkboc true or false

    I have an outlook custom form where I would like to set a text box to add the sum of 2 fields based on a checkbox entry being true. Though not a valid formula here is what I am looking to do. "IF [Rate Or After Hours Checkbox]=True THEN [Total Travel Cost]+[Total Labor Cost Rate]"
  12. G

    Create an Appointment at the Contact's Address From Email

    Utilizing the following macro written by Diane Poremsky. It has been a great little macro for use in our service department. I have modified the macro a bit to also pull additional information from the contact as well as utilize a couple input boxes to collect data specific to service call...