Maybe this isn't the correct board to post this on but I cannot express the gratitude I have for everyone that helped me with my project.
boblarson your patience is unending thank you for walking a noob thru the paces. Your guidence and breakdown of the vb syntax was amazing.
pbaldy I could...
THANK YOU THANK YOU THANK YOU!!! This is exactly what I was looking for! I finished my project this morning and it is working flawlessly! I cant thank this board enough.
Maybe I need to be more specific because I have been searching but still have not found an answer to my problem.
I am writing my code in the Visual Basic Editor that comes with Access. My code sends an email through a command button. The code is working. In the .Body line as I am writing the...
Is there a character limit for sending an rich text email through outlook using VB? If there is, is there another format that would allow me to add more characters?
Sorry for the lateness in reply. I was not getting the enable macro security warning so that was the issue. Enabled macros and everything worked fine, but it did boggle my mind completely for about a week. Thanks so much for all your ideas!
One more question, want to add more text to the email...
I have the following code working on my XP machine.
Private Sub Command25_Click()
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
Set appOutLook =...
Perfect perfect perfect! Thanks Scooterbug! I forgot to remove Format thats why it wasnt working. You all have been so great! I have been totally impressed with all of your knowledge.
Back again... I have managed to get my form working and formatted quite well. I am stuck on one part. The following is the code I am using...
Private Sub Command25_Click()
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook =...
Thanks to all of you! I'll start reading up asap but probably not soon enough to finish this project so Im sure you will see me around again. As for today my brain is wracked.
Kudos to all of you, your help is more than appreciated!
Duh Duh Duh.... I should have seen that comming. Could you recommend a good book for a beginner in VB. I'd love to be able to do more of this with out having to bug the heck out of you all.
Ok got rid of that nasty little guy and removed the extra .body but of course I am screwing this up tons and it doesnt work. I assume I need to put something inbetween the 2 calls but what?
Private Sub Command20_Click()
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem...