Unanswered: need help to generate excel file from ms-access
Im new to this forum, need help on ms-access VBA code to generate excel file and the generated excel file should automatically go as attachment to a perticular person through outlook. details as follows
i will enter first name,last name,id,email id in access database and vba code should generate excel file as follows
first name: xyz,
email id: email@example.com
and the excel file also need to be hardcoded as follows
so totally i need 5 rows in excel and this file need to be sent a perticular person when ever i make new entry in the database.. as im new to VBA coding pls help me on above..