Hi Guy's is there a method of adding inbox items to a list box ?
If i can have a list box ie: lstInbox then populate it with a specific mail inbox would be great ?
Hi Guy's is there a method of adding inbox items to a list box ?
If i can have a list box ie: lstInbox then populate it with a specific mail inbox would be great ?
Can set a link to Outlook inbox and use that link table as source for a combobox or listbox. What purpose would this serve? What are you really trying to accomplish?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi Dave,
Have a look at my sample: http://forestbyte.com/ms-access-util...ook-companion/
I use Outlook automation to interact with Outlook (I have a local table to specify the mailbox and other variables that can be changed by the user).
Cheers,
Hi, thank you Jun7 and Gicu, i will try your link thank you
To answer June7, we have web enquiries where in my inbox and when new enquiries come through, these are always called from processor, what i am trying to achieve initially is have a list box with all of the emails within the subject of Form Processor so that you can see new emails from a list box, eventually, this will allow more users to respond as we are all working with Access anyway rather that us maybe not checking mails for a while and there maybe more enquiries to follow up.
So if we have them in a list box, i can then maybe add timer refresh and pop up Msgbox when new mails have arrived in the Form Processor subject of that email inbox
Hope this all makes sense
Kindest
Hi Guy's so if i can have the this picture in a list box then i can refresh on timer and see new emails then pop up a msgbox "there a new emails to follow up" then from thereon i am able to develop some code to add some of the mail contents maybe to a new table called tblInbox then can distribute data and generate reply mails, the better part of doing this for me is i can add modules with some responses to the emails, generally there are only 2 of us that can value the email query whereas i can add the modules to put in my knowledge of values and responses so that more users can respond
Hi Dave,
This is all easily achieved by automating Outlook. You could create an Outlook rule based on the sender ("form-processor") to move all these emails in a specific Outlook folder ("ToBeProcessed"). Then you setup the VBA code in Access to loop through that folder, bring them into your Access table then move the email into another (sub) folder ("Processed"). At this time you could also send the reply acknowledgements.
Cheers,
Hi Vlad, thank you so much for your reply, would you have a starting point for me step by step
Ie, what Dim's I would need then then what i need each one to do
So something like:
Loop through a specific inbox then add to me.lstInbox ?
Kindest
Hi Dave, download my sample file and have a look at the objects/ VBA , it should get you going. I am going camping for a few days and I'll probably be out of cell range I'll check back on my return.
Cheers
Hi Dave,
Just curious if you got this working or if you still need help with it.
Cheers,
Hi Vlad, thank you for your reply, no i didn't get it to work, although i haven't had much time to attempt, i did download your sample db, i am not sure which part of the sample db to take the idea from although yo did mention it.
Are you able to copy and paste the vb that would help ?
I have tried a couple of things but like mentioned not had much time at it
If i can have a button and a list box, the list box displays a specific inbox then fantastic then i may change the button to an on form timer or a different event where it is updated
Thanks Vlad
Hi Dave,
Open the tblEmailSettings and enter the mailbox folder you want to check (right now it is set to Personal Folders/Inbox). Also update the two date fields to include an interval where you have emails in that folder. Then open the frmReadMail and it should populate the list box with the emails you want.
The code you want is the frmReadEmail form.
Cheers,
Hi Vlad, thank you, yes it works a treat does that, It is checking mails 08/08/20 to 09/08/20, is it just a case of entering todays date for latest check ? or can the form open event auto add todays date ?
This is look great though
Hi Vlad, this works great, the only question is, i can't expand to see queries / tables etc ?
I am going to work out how i can integrate it to my current db
Hi Dave,
Glad to hear, all objects (queries, tables) should be visible, if not just go to Options/Current Database/Navigation and click the view hidden (and system) objects. It's been a long time but I think if you click the Check for Today's on startup box it should limit to today's messages. Also the Outlook entry id could be useful to you as it is (in most cases) unique and can be used to avoid processing duplicates.
Let me know how you make out, I also have code to move messages from the "inbox" or "to be processed" to a ""processed" folder to avoid duplication.
Cheers,