export 1 record selection in Access database to Excel spreadsheet

[Guest]

I have a macro to export Mail Merge data in a form of selected records in an
Access database to an Excel spreadsheet.
With multiple records it works fine, but if there is just a single record to
transfer, it generates a null entry spreadsheet.

 

[John Nurick]

Without seeing the macro one can only guess, and life is too short for
that.