Sending an email from Access using data contained within queries/ tables

[cartera]

I am trying to set up a database which on the click of a button can open outlook and have in it data from the database. So far i have managed to get it to open the e-mail with the data in but i am struggling to add more data. Here is my VB script below;

Private Sub Command13_Click()

DoCmd.SendObject _
, _
, _
, _
"e-mail address goes here!", _
, _
, _
Me.Summary, _
Me.Description, _
True

End Sub

After the 'Me.Description' field i would like to add more fields but when trying to do this using separators that i know i get a syntax error.
Any help would be greatly appreciated and please forgive me but my knowledge of VB is fairly basic. The separator i have tried are '&', semi colons, commas and also below it on a different line.
Many thanks,

Alastair

 

[DelJo63]

research the Outlook API, which has access to Outlook contents including
Contacts, Calendar, and user Folders