I finally figured out how to create a table from my inbox unread emails. I did it at home where I use Outlook 2010 (not the Hotmail Outlook version) Hotmail connector. It worked great! I only need a few fields: who is the email from, when was it sent, and the body of the email. From those fields I build a "trouble/issue ticket" for the main Access application. I took the code to work, changed the code so that it would read our Exchange server 2010 Outlook emails. I even brought the BE tables with me an refreshed them at work. The references in the program to the body (objectname.bod y) and the sender or sendername all gave me an error 438. I am able to get the objectname.size , objectname.subj ect, and one or 2 others but not the 2 fields I really need: the sender and the body of the email. I looked in the object browser in Outlook and I am spelling the names correctly but msgbox "Field = "& objectname.body or .sendername or ,senderemailadd ress all give me an error 287. Does anybody have an idea what I am doing wrong? Remember, some of the fields display just fine using Msgbox so the code for setting up the emails is fine. I think the field names may be incorrect. Please help.
-
-
You need to look at How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!. The information we require so that we can help you is mostly missing from your question. This is principally an Access forum, so you're unlikely to get much response to a half-expressed question on Outlook.
I suggest that you will need to include the relevant code (Before Posting (VBA or SQL) Code). You may be convinced it's all perfect, but from what I can understand of the question so far that seems unlikely. Certainly not something to assume sight unseen.
Comment