Search results

Okay, I jumped the gun with my above post. I have the below which works but my issue is how do I resolve an internal email to an actual email address? Currently the internal emails show /o=Company Name/ou=NA/cn=Recipients/can=Windows username

I have tried the below VBA code, but am getting an error of ----- Run-time error '91': Object Variable or With block variable not set Did I mis-understand what you said? Dim olReply As Outlook.MailItem For Each Recipient In olReply.recipients Debug.Print Recipient.Address Next Recipient...

We are using Exchange. Is there a way to use VBA to query this Master Exvhange list you reference so You would know if you need to search by an email address or a name?

If I look at the Recipients Object (Outlook) the only properties I see are: Application Class Count Parent Session (Looking at MSDN link)

But I am the sender - I’m wanting to look at the To and CC properties. But pull the SMTP email address

That definately explains it, thank you for that insight! Any idea how I would access those elements from VBA? If I try the below, Intellisense does not provide Contact Name or Display Name as an option. Dim olMail As Outlook.MailItem olMail.

In working on some VBA code I have become curious as to how Outlook resolves an email address For example, internal contacts within my company show as LastName, FirstName But what is throwing me is that I have yet to see a consistency with external emails. These emails are not saved in my...

Now that I've solved my issue, I'll post as to why I was asking :banghead: I originally thought you were telling me to build my date string in the DateDiff function like this: Select * from teamroster where DateDiff(‘m’, CDate(Mid([action date],InStrRev([action date], ‘ ‘) + 1) & "/01/" &...

The year is stored in a separate field, called year. Lol Yeah...the dev of this SharePoint site didn’t set it up all to well imho

In case I’m going about this the wrong way. I want to return all records where the month is current month or prior

No. Action date is short text that contains for example: Need forms Jul The one factor that is always the same is the last 3 characters is always the date.

I have a short text field that I am parsing out the month from. I then want to use it as part of my where clause I have this syntax but am getting data type mismatch...but am a i not converting it to date format so the DateDiff function should work? Select * from teamroster where...

I may have thrown in the towel a little early here... If you run this syntax you should get MailItem for any email message and (using the Skype meeting request example above) get MeetingItem for any Skype Meeting For Each msg In Fldr.Items Debug.Print TypeName(msg) Next msg In knowing...

Love it!!! I never thought of concatenation this to a one liner!!

We are above my skill set at this point. Maybe a more advanced Access VBA user can step in here

Hmmm....peculiar...Inside your For Each block add these Debug Statements (Thanks @June7 for reminding me to always Debug!) Debug.Print olMail.To Debug.Print olMail.SentOn Then in manually scan your Sent Email for the last email that is Printed in Access. Once you find that what is...

The error is telling you (and someone please correct me if I speak incorrectly) that An object is a class instance. A class instance has properties that are defined in the class type definition. I’m thinking access doesn’t like us declaring olMail as object do let’s change that line to Dim...

I'm still learning VBA but I frankenstiened some code together a few months back to do a similar task. Maybe this will point you in the right direction. What this does is it scans the sent mail folder of the email account and opens the message. You will have to modify to fit your criteria...

In my testing, I just realized I left out a where clause for the update statement! This is why I always test with garbage data initially �� The column [Account Name] is a number data type And I get this error: Run-time error ‘3464’: Data type mismatch in criteria expression And...