Need help with emailing a report in access

[pacotx]

Hi,
I have become a ebay seller and every time I sell something I put all of the info into a Access form. But what I want to do Is to be able to email a invoice. I want the report to be text in the body of the email and a field to be were the email address is sent. I have looked all though Microsoft help center and I didn't get anything I wanted.
Here is a example of what I would like to send:
___________________________________________________________
To: [email address]@[host].[web]
Title: Your invoice from Andrew

BODY:
[ebay ID],
Thank you for your purchase of a [item].
We hople the transaction goes well!

Invoice:
>>>>> Price: [price]
>>>Shipping: [shipping]
>>insurance: [insurance]
_________________________
>>>>>Total: [total]________
___________________________________________________________

Could someone help me?? If there is a way can you also teach me how to do news letters as well?
Thanx for your time,
Andrew
P.S. I know that there is a insert object that you can email, but I don't thing you can send it to different people, or have it show up as text and not a file.

 

[Remou]

Hello and welcome.
It is very useful to look through Tek-Tips. You can use Search to look for keywords and there are many useful articles in the FAQs. Here is one post that may help:
Email from continuous form
thread702-1263983

You will find that it is useful to post in the proper forum:
Microsoft: Access Forms Forum: forum702
Microsoft: Access Modules (VBA Coding) Forum: forum705
Microsoft: Access Queries and JET SQL Forum: forum701
Microsoft: Access Reports Forum: forum703
Microsoft: Access Tables and Relationships Forum: forum700
Microsoft: Access Other topics Forum: forum181

Please read:
How can I maximize my chances of getting an answer?
faq181-2886
If you have not already done so.