Export Single Record to Excel or Outlook

[Nosstech]

Is there a way I can export just a single record from Access to Excel or to an Outlook email?

I can export, but the table goes with it. Can a single record be exported?

Thanks in advance.

[CreganTur]

Are you wanting to export this single record from a Form?

[Nosstech]

Are you wanting to export this single record from a Form?
Yes.

[CreganTur]

Take a look at this thread (http://www.vbaexpress.com/forum/showthread.php?t=20769&highlight=Export+Current+Excel)- it deals with what you're looking to do.

HTH:thumb

[Slyboots]

Here's the easiest way:

Write a query that returns the single record.
With the query active, select File Export.
The Access dialog will be headed "Export Query 'xxxxx" To..." and let you select how you want to output it.

The resulting file will contain ONLY the results of this query.

S