@arnelgp in another thread of mine gave me a function that would open a form filtered to show only the specific ID information for the row I clicked on my form.
My database became corrupted and I had to re-create it and now it is not working. In the double click event of the field on my form I...
I had to set pop up property to Yes
When the form loads the text is highlighted. Is there a way that the text is not all highlighted when the form loads?
I have a form set to continuous view. I was wondering if there is a way that a user can double click a specific row in the form and on the double click launch a separate form that shows all of the user_notes for the clicked record?
Hi - post 28 - is functioning for me, I just have one mishap I am having with he code.
When I open the email, I want to ADD new text to the email chain. When I use the code in this post it ONLY adds the 'new' text that I code in.
With olReply
.BodyFormat = olFormatHTML
.HTMLBody =...
Hi - I tried testing your code (no alterations) but I am getting an error of
Run-time error ‘438’:
Object doesn’t support this property or method
And this is the trouble line
If olMail.To = searchEmail Then
I am needing to reply all and keep the previous correspondence showing in the email thread.
Are you suggesting that every time an email is sent to manually add date/time email body, email subject etc to a local table?
Saving the data in access would only give me the email address and the date of last email sent...I'd still need to access the Outlook object to "Reply All" to the last email tho...
The site swapped out the quotes. I have stepped through the code and the issue I found is the .To is giving (forgive my ignorance and lack of terminology here) the name and not email.
For example, if I sent an email to Tom.jones@test123.com what the code shows is ‘Tom Jones’ not the actual...
Knowing when it was sent isn’t as big of a deal. What my end game here is finding the last sent email and “reply all” and add text to that message from access vba. Now manually inputting this into an access table could help narrow down the specific date to scan sent mail for.
I feel like I’m close, but I keep getting not found even tho I sent an email to this address today. What’s up?
Dim olFldr As Outlook.Folder
Dim olNs As Outlook.NameSpace
Set olNs = olApp.GetBamespace(“MAPI”)
Set olFldr = olNs.Folders(validemailtosearch).Folders(“Sent Items”)
For Each...