Exporting info via email

[jwr]

I am in need of creating forms and reports and need to send them via email.
Recipient will enter info onto form/report and retransmit back to me.

Can this be done? Will the information be retained in the original format?

Thank you

 

[Arvin Meyer]

There are several ways you can do it, including using the built in
SendObject method and attaching a query, table, form, or report to the email
in one of several formats. You can also concatenate the data with carriage
returns and put it in the body of the email using the message text argument.
The entire SendObject method is in a helpfile article, complete with some
sample code.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer]

There are several ways you can do it, including using the built in
SendObject method and attaching a query, table, form, or report to the email
in one of several formats. You can also concatenate the data with carriage
returns and put it in the body of the email using the message text argument.
The entire SendObject method is in a helpfile article, complete with some
sample code.

I'm sorry, I assumed that there was some sample code in the help files.
Older versions of Access did have it. Here's some of the help file from
Access 97:

Syntax

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]

The following example includes the Employees table in a mail message in
Microsoft Excel format and specifies To, Cc, and Subject lines in the mail
message. The mail message is sent immediately, without editing.

DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _
"Nancy Davolio; Andrew Fuller", "Joan Weber", , _
"Current Spreadsheet of Employees", , False
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access