Search results

That looks promising... going to try that tomorrow. That was a great find... I am surprised I never turned that up during my searches. Maybe I didn't know what I was looking at. :)

Looking forward to seeing this code.

Well if anyone is interested... The solution to that issue was to have the .Display AND the .Send active so it briefly opens an email giving Outlook time to include the signature and then sends and closes it. Just a flicker is all you see.

I was thinking along the same lines last night... since we aren't actually opening an email before sending it.... Outlook doesn't insert the signature. I remember seeing some posts somewhere about someone mentioning they would see a brief mail open and close like a flicker. I don't remember...

Well... not only did it not show the signature... but no body as well When I use .Display and it shows it to me and I click the send button in Outlook everything shows fine. Sup wit dat?

FYI... here is the final code: Option Compare Database Option Explicit Public Function EmailNotice() Dim Outapp As Object, OutMail As Object, OutAccount As Object Dim rst As DAO.Recordset, rst2 As DAO.Recordset, rst3 As DAO.Recordset, rst4 As DAO.Recordset Dim varUSMParts As...

I read it real good and it still didn't make sense so I decided to copy it in as-is and start from there and after declaring all of your variables so the code would run... VIOLA! the signature displayed correctly! After that I was able to mix back in my code to display what I wanted in the body...

I was looking at that but I do not understand it. Seems there is a macro that has something to do with the addresses and subject matter? I think there is a some missing information to explain the pStrToNames and pStrSubject etc. (among others) I am too novice to understand it.

I also noticed it was set to olFormatRichText and tried changing that to olFormatHTML which didn't change anything. Interestingly enough... if I select a new email from Outlook the signature is added correctly but when access starts a new email it doesn't. Seems like there is a lot of code...

I was a little surprised at the simple output from all that coding but it did help me understand it. There was a function missing from the code that dealt with the GetBoiler but I was able to find it online and add it to make the signature code work. On that subject... my signature displays all...

Gasman... would it be okay with you to post a screenshot of the output of that code? (with all sensitive data blacked out of course) so I can follow what is being done with the HTML code?

I see... that works as well so I changed it to your code Option Compare Database Option Explicit Public Function EmailNotice() Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Dim strPath As String Dim strFileName As String Dim rst As DAO.Recordset Dim rst2...

ahhh! I see what you mean. This works! Dim strFileName As String Dim rst As DAO.Recordset Dim rst2 As DAO.Recordset Dim strEMailTo As String Dim strEMailCC As String Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem) Set rst =...

Correct... I have 2 tables Table 1 - tbl_users (with AccessLvl 2, 3, 4) Table 2 - tbl_receivers (with Active = true) I wanted to have the users in the .To and the receivers in the .CC

If you have identified what I am not doing in the code... can you help with the code additions to accomplish those things? Obviously I only minimally grasp what is going on in there

Yea... definately in over my head with this one... I was trying to add a CC to the email that gets generated so I added another table with a different set of people and their addresses and I tried adding in another recordset to the code and I got no errors but it added the first email address...

Replace was the trick Here is the final code that implements the replacing anything with uppercase and replacing an O with a zero: Private Sub PONumber_AfterUpdate() If Len(Me!PONumber) > 0 Then Me!PONumber = UCase(Me!PONumber) Me!PONumber = Replace(Me!PONumber, "O", "0")...

I have to let go of starting the new records in my database and my OCD alarm is ringing like crazy. On my record input form there is a field for putting in a PO number (tbl_auditdata - PONumber) and typically the PO number looks like this: P0FG456. At this time there is always a P for the first...

I remember once upon a time I felt the same way on another site which subsequently drove me to this site. There were respondents that just posted links to similar questions (some no so similar) and due to the specific nature of my questions, they didn't seem relevant or helpful. Upon further...

I like this one