This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a MS ACCESS database the searches then displays several fields on the screen. Although not
necessary, I would like to be able to copy all these fields and attached them in an e-mail. Currently,
MS Access only allows me to copy one field at a time, which is a pain. For example:
Ref # Description Price
1 Yellow Toy 300
A Table 650
5 Relay 1890
So, each line / Field comes from a select query and displays this information. As a
result, I cannot copy all this information at once and paste it in an e-mail. Any clues
on how to perform this are appreciated!
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
The best way would be to do a report, export the report to PDF and attach to your e-mail. Alternatively you can export the Recordsource of the form to Excel and either copy and paste from Excel or attach it.
You can create a simple report based on a query and then attach the report to an email as a PDF document. For an example of how to do this take a look at InvoicePDF.zip in my public databases folder at:
https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169
This little demo file includes an options to email a single or multiple invoices (the report) as PDF files using the SendObject method of the DoCmd method.