Posted by Gary on August 31, 2001 3:51 AM
From reading previuos messages you seem to be the guy to consult.
I have this code for emailing the contents of a listbox but all get is a blank email. Where am i going wrong?
Private Sub CommandButton8_Click()
Dim OLook As Object
Dim Mitem As Object
Dim SendAnEmail As Boolean
Set OLook = CreateObject("Outlook.Application")
Set Mitem = OLook.createitem(0)
Mitem.to = "MMouse@Disneyland..."
Mitem.Subject = "Stock level warning!"
Mitem.body = "Bla bla bla..." & ListBox1.Text
Set OLook = Nothing
Set Mitem = Nothing
I get a message if use a textbox...?
I could also do with placing comments into textboxes if you could cast some light onto this too..
i can see the comments in MsgBox thanks to a previous message placed on the board but can't manipulate it.
Thanks for any help,