Search results

This is what the code looks like now Private Sub Command29_Click() Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Dim Sttext As String Dim sSQL As String Dim BSN As String Dim db As...

Hey thanks fro the repy. So i changed my Recordset loop but it still only shows the first value of the record cant figure out how to get the rest of the data showing.

Hey again thanks for all the help so far you guys have been great. Im using recordset to place data in the body of an email problem im facing i cant get each record on a new line in the email body, The code i have done is Private Sub Command29_Click() Dim mess_body As String Dim...

Thanks helped lot and cheers for the learning resource think ill just go for plain txt for now and have a go at playin around and get a understanding of html to format the txt at later date thanks again

Im using the following code Option Compare Database Private Sub Command27_Click() Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Dim StMailBody As String Set appOutLook =...

Hey all im im using a button in a form to automaticallly send an email to the email address in the form and use the Name in the subject. Im using outlook and the.BodyFormat = olFormatHTML the problem ive having is referencing the Booking number and Date from the Form in the HTML body. Any help...

Thanks alot helped a lot

Hi all first time poster and complete novice at access i have got some code from the internet to send email automatically using access and outlook, after the user inputs email add, subject and main body of message three txt attachments (ski, Directions and Partymenu) are added when they hit send...