Search results for query: *

Well, I don't know what happened, but those have gone away. And this really is my whole code. I have this tied to a command button on a form to execute on click. The "description" is a field on the form. Really appreciate all of your help!

Sure. I'm pretty much using what you sent, but replaced the .Body, .Subject,and .To portions. Private Sub SendEmail_Click() Dim oApp As New Outlook.Application Dim oMail As MailItem Set oMail = oApp.CreateItem(olMailItem) With oMail .Body = IIf(IsNull(Description), "", Description)...

IT WORKED!!! Thank you, thank you, thank you! Ok, one last question... I want the body of the email to reference a specific field. However, when it does, I get this: <div>XXX</div> If I don't want the "<div>" and the "</div>", how do I refer the field in the code to only get the text...

I'm trying to create an email in outlook and show it to the user without sending it to the recipient.

Hi Andy, First, thanks for your help. Second, is there a reason why, when I click the command button on my form, nothing happens? Shouldn't an Outlook mail form pop up? Thanks! Aubrey

I've seen several discussions on this topic that I've tried to utilize, but whenever I attempt to initiate the "click" nothing happens. Can someone give me some direction on what I might be doing wrong? Sub Sendmail() Dim StrEmail, StrBody As String Dim objOutlook As Object Dim objEmail As...