Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013

    Unanswered: need help to generate excel file through ms-access vba

    Hello all,
    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,
    lastname: abc,
    id: 111111,
    email id:

    and the excel file also need to be hardcoded as follows

    name: xyz
    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..

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    make life easy for yourself
    send the files as a comma separated value files which is a pseudo native format for spreadsheets
    OR if you must persist in creating an excel file then consider looking at the excel automation providied int he code bank, provided , IIRC by Pootleflump and others
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts