Search results

I get a Func! error on 1 992522 OP and a #Num! error on 1 12507016300. It works with the original code.

I am still getting errors on some of the fields that should come back with the month value.

Is there a way to make it do nothing if there is no number to pull the month from instead of it showing an error? Thanks

Great, that works! Thanks!

I still get the same error when I concatenate the empty column to an empty string.

I have another question for this thread. How do I allow for Null values if one of the columns have no data. The information shows in the list box with no value but when I try to send the e-mail based on the list box selection and one of the columns are blank and the other columns have data...

Thanks for your help!

I want to add a new column to my query called order month that pulls the month out of a text string from another column in my table. For example in column PO# I have 12 ABCCHAMP and in the new column order_month I want it to pull December from the the numbers in front of the text. So if it is...

yes, the access version I have is 2010. I removed the references that I was not using. Are there any that I am missing?

Thanks for the help. I have changed the code so much that is why it is probably a mess. I tried to run it again and the signature still flashes. Weird that it works on your end and not on mine.

Attached is a stripped down version of my database. I am using Outlook 2010.

That is the code that I originally used and it just flashes the signature and opens the email with no signature.

I updated the code to below and it gives me the warning to select an order and when I click ok it still opens an email with the strBodyText in it. How do I prevent that from happening? If strList <> "" Then strList = Left(strList, Len(strList) - 1) strList = "(" & strList & ")" strSQL =...

I am using the below code and it gives me runtime error 287 on the line signature = OutMail.HTMLBody. Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) With OutMail ' This creates a blank email and captures the...

Hi Just a follow-up on the code that you provided. When I don't select anything from the list it throws the runtime 3078 on the rest of my code and highlights the code in red. It works perfectly when I select items. Any suggestions? Thanks, Set rst = CurrentDb.OpenRecordset(strSQL)...

I changed the code to strBodyText and it does the same thing. It's like it opens a blank email with the signature and then the body opens over it. I have tried a few different things and it doesn't seem to want to work.

I have taken the parts out referring to the form and it still does not bring in the signature. When I comment out the below line it works but there is no body to the email. Not sure how to get them working together. .HTMLBody = strFntNormal & BodyText & strTableBody & signature

When I add the other code back. It flashes my signature then opens the email with the body but no signature.

The below code works and brings back the signature when I comment out the rest of the code. Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail ' This creates a blank email and captures...

Option explicit does not recognize the code from my other forms.