I got the VBA script that I wrote to work completely well, with the help of Merle and George (THANK YOU!).
Now I have to try to figure out how to get rid of the extra field ("Transferred") in my database and add some error handling in the code. Because once it goes through it puts a check...
Thank you for the quick replies and all the help you've giving me. A lot of people here I noticed are newbies and don't know how to clearly state their problems. :-)
I got the VBA script that I wrote to work completely well. Now I have to try to figure out how to get rid of the extra row...
Neverminde, the name is .AssistantName (Without the s) does belong to the ContactsFolder.
Thanks for your help, George.
Is there anyway to add onto the Notes instead of overwriting them?
How do I find out what object it belongs with? With is for Outlook 2003, I found where the .Notes are they are olFolderNotes, I can't find where .AssistantsName. It's doing the same thing to
I just put in your code instead of mine, George. I received the same error message - 438: Object doesn't support this property or method. **Frowns**
That line is just to put the first name and last name in Outlook's Contact field named Assistant's Name. With a space in between the first and...
I'm trying to just concatinate the two fields, not calculate anything.
But let me try your code and see what happens, thanks.
Will let you know.......**Crosses fingers**
I just re-stepped through the program and now it's giving the error at
.AssistantsName = Nz(rst!ContactTwoFirstName & " " & ContactTwoLastName)
The AssistantsName is from Outlook 2003 it's one of the fields in the form but the name is Assistant's Name. But I can't get it to work with the "...
Received new error
Thank you, it is spelled "transferred" in the database field. but now I get another error: 438: Object doesn't support this property or method.
I'm getting an error in Access 2003 (Error: -2147217904: No value given for one or more required parameters)
I'm trying to get information from the access database and send it to Outlook 2003. But this error keeps coming up and I tried the stepping into. and Once it gets to the rst.Open line...
I'm getting an error in Access 2003 (Error: -2147217904: No value given for one or more required parameters)
I'm trying to get information from the access database and send it to Outlook 2003. But this error keeps coming up and I tried the stepping into. and Once it gets to the rst.Open line...