Search results

Re:Outlook2016 Hi All, In my last post I ended up with code that has been the base for my email import routine. https://www.access-programmers.co.uk/forums/threads/outlook-vba-cant-figure-out-what-im-doing-wrong.313848/ When I started on phase 2 I have now realized that the outlooks MailItem.To...

Hi All, I had been playing about with some code in Outlook to export emails details to Access. For testing I had changed the code to export from a sub folder with a small sample set of emails that worked no problems. But when I changed it to work on the Inbox it fails after exporting about a...

Hi All, I have a tblImportedEmail field [Emailbody] that contains text with a BookingRef also I have a tblbookings that holds [BookingRef] I wanted access to go through the Emailbody and match it to the [BookingRef] in the tblbookings As all the BookingRef are in different formats and rarely...

Hi All, I was using an old PC with a spare Softphone licence to capture the incoming TelephoneNo in Access. The Softphone has a function (on the first ring) that pushes out the incoming TelephoneNo via a command line switch which opens a standalone local version of Access which I use to...

Hi All I have been trying to improve an import routine in our office DB. The issue I am having is calling / triggering a macro in the “already running” office DB from Word. All the examples I have found are all based on opening a new instance of Access. The already open db is = "C:\Tracker...

Hi In Outlook I would like to trigger the Attach file window (Paperclip) to a set folder location based on the value in the templates .oft UserDefinedField called JID (JobID) Each JID (JobID ) has a folder for documents in the server e.g for JID12345 = path Y:\JobFolders\JID12345 I have...

Hi I wanted to replicate google Screencapture app that you can get for the Chrome browser Idea was to have 3 buttons on the webbrowsers frm 1. Copy & Save Visible area in Webbrowser 2. Copy & Save Highlighted area in Webbrowser 3. Copy & Save Full page in Webbrowser Unfortunately practical...

Hi I have got to the Grrrrr:banghead: stage. I have been constructing an import routine for emails. I have worked through all the code to get the email to table etc. But I am trying to get my DB to “Read & Match ” two DB fields that will appear in the imported email Subject & or Body...

Hi After finding r.Harrison amazing postcode lookup example in the Sample databases section i imported the frm into my db. On my frm_NewClient added a button to open the postcode lookup frm. I am now stuck with the code for splitting up the address into my fields and adding them to my...

Hi We have a special reduced rate that a client must prepay 12weeks before or sooner if a date is put in the [OverRideDate] field I have been trying to construct a Query / If statement or should I use case statement to work out the actual payment date. Taking in to consideration all our funny...

Hi First timer question After searching for Nemours combinations I am now asking for some help I have tried combinations to get a expression to give me a list of bookings staying tonight The fields in the table I use to store the Start & End date of the booking are below [CheckInDate]...