This is a repeat of a question I had asked earlier. I'm still uncertain how to do this. I have increased the points.
I created an Access database to invoice deliveries. I want to be able to send the delivery details contained in a form via email. I want the data to be read into the message body of the email. I don't want to send the form as an attachment. Is this possible? What is the VBA code to perform this task?
The message body of the email must look like the following example:
C1 seafood $10
C2 steak $12
Subtotal = $22
Taxes = $2
Total = $24
Currently a report with data read from a form is sent as an attachment automatically on a click of a button. I want the data to be sent in the message body of the email so I can apply a rules wizrd to print the email automatically upon arrival at the destination location. This is the reason why I require the data be in the message body of the text.
Thanks in advance.