sdawson
Registered User.
- Local time
- Today, 19:48
- Joined
- Apr 22, 2003
- Messages
- 165
My db uses a command buttom to send e-mail by Outlook.
The following code selects the record to preview then e-mail.
I'd like to be able to select multiple records as attachments on the one e-mail.
I suppose I'd need additional field(s) on the form to select the records but I'm not sure how to write this.
Code or threads appreciated.
DoCmd.OpenReport "email report", acViewPreview, , "[ID]=" & Forms![data]![ID]
DoCmd.SendObject acReport, stDocName, acFormatRTF, , "to.you@company.co.uk","copytome@business.co.uk , "E-mail subject", "There are some attachments (hopefully) with this e-mail", True
Thanks
The following code selects the record to preview then e-mail.
I'd like to be able to select multiple records as attachments on the one e-mail.
I suppose I'd need additional field(s) on the form to select the records but I'm not sure how to write this.
Code or threads appreciated.
DoCmd.OpenReport "email report", acViewPreview, , "[ID]=" & Forms![data]![ID]
DoCmd.SendObject acReport, stDocName, acFormatRTF, , "to.you@company.co.uk","copytome@business.co.uk , "E-mail subject", "There are some attachments (hopefully) with this e-mail", True
Thanks
Last edited: