Recent content by Andy Mc

  1. A

    recurring calendar events

    It is a very complicated statement. It occurred to me that it might have been because there was no end date (= infinite count). However, I've just ran a test with a new recurring event with an end date but it still only picks up the first occurrence (ie today's date).
  2. A

    recurring calendar events

    Thanks MajP, I'll take a look. I hadn't found that link in my searches.
  3. A

    recurring calendar events

    Hi I want to extract some details from my Outlook calendar (subject and start and end dates). I have this code: Public Function GetEvents() Dim oOutlook As Outlook.Application Set oOutlook = CreateObject("Outlook.Application") Dim oNS As...
  4. A

    Find text within email template

    Thanks for all that, and for the encouragment. I will stick with it, but perhaps I'll lower my ambitions for now. It just seemed a simple thing to try to inspect an email to find if a particular text exists. Peaceful is the new norm these days - well , at least for sensible people. Our pubs are...
  5. A

    Find text within email template

    I got the idea for searching for text from https://docs.microsoft.com/en-us/office/vba/word/concepts/customizing-word/finding-and-replacing-text-or-formatting. I know that this was a Word article, but I had hoped it could be modified for Access. Sorry about the On Error thing; it was in some...
  6. A

    Find text within email template

    Code Tags Added by UG Please use Code Tags when posting VBA Code Please feel free to Remove this Comment https://www.access-programmers.co.uk/forums/threads/please-use-code-tags-when-posting-vba-code.240420/ Option Compare Database Option Explicit Public Function SendEMail() Dim db As...
  7. A

    Find text within email template

    Hi. Sorry had to be out for a few hours. I've pasted the whole code below (this might clarify a few things). I got the .Content.Find procedure from a MS website (which I attempted to modify for my needs). Code Tags Added by UG Please use Code Tags when posting VBA Code Please feel free to...
  8. A

    Find text within email template

    Hi Thanks for the suggestions. I tried changing the statement to FALSE, but it still doesn't run correct. I guess that could indicate that the problem is with the .find property. Also, it does compile.
  9. A

    Find text within email template

    Hi, I have a db that creates an email from templates (the template changes depending on a selection). Each template contains key words that are replaced by data input by a user through the db using an InputBox. It generally works fine but I want to avoid using specific InputBoxes where not...
  10. A

    trying to delete outlook contact

    Perfect. Genius thanks :)
  11. A

    trying to delete outlook contact

    Thanks for teh swift reply. Tried this but get a fail at the if statement (property doesn't support this property or method). Any suggestions?
  12. A

    trying to delete outlook contact

    Hi I'm trying to use this code that I found online: Dim myOutlook As Outlook.Application Dim myInformation As Namespace Dim myContacts As Items Dim myItems As ContactItem Set myOutlook = CreateObject("Outlook.Application") Set myInformation = myOutlook.GetNamespace("MAPI")...
  13. A

    Are you an atheist?

    Hi all Interesting reading your views. The only point I'd like to make is that it's great to see a debate on this and a general theme away from the 'god delusion'. By the way, I found it to be a fantastic read - when read with some of his other books it really opens up the mind.
  14. A

    problem getting file size

    Hi Thanks to you both for your suggestions. I tried each but still had a problem. After a bit of head banging I checked out what MyFile was returning and it turns out that it was the path that was missing.However, your suggestions got me on the path to success. Here's what I ended up with...
  15. A

    Trying to email separate reports to separate addresses

    Hi As a newbie I can't yet post a weblink, but type 'jephens' into google (it pops up as the first entry). I know you wanted to avoid VBA but this was easy for me to follow (and modify) for my own uses.
Top Bottom