Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Sending an Excel spreadsheet using a MS Access Macro

Discussion in 'Information Technology' started by Send Object Command - Two attachments, Jul 28, 2006.

  1. Need to know how I can send an Excel spreadsheet via a Macro function in
    Access (withou using VB code if possible...)

    Thank You.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Why This Sikh Cartoonist Is Sending A Postcard To Trump Every Day Breaking News Mar 23, 2016
    Canada Canada sending dossier on fraud immigration agents to Punjab Breaking News Sep 27, 2010
    Canada Sukhdeep Kaur Chohan of Brampton Wins PM Award for Teaching Excellence Breaking News Mar 5, 2014
    India Sikh Regiment's Passion for Excellence Breaking News May 19, 2013
    Leisure Excellence -skills-Attitude Business, Lifestyle & Leisure Feb 14, 2010

  3. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    Do you mean you want to export data from an Access table to Excel using a
    macro? If yes, create a new macro and select the TransferSpreadsheet action.
    Set the transfer type to Export and enter yur Excel version and the table
    name. Finally enter the full path and file name of the Excel file. Save and
    run the macro to do the export.

    My apologies is this is not what you were after.

    Delordson Kallon
    www.instantsoftwaretraining.com

    "Send Object Command - Two attachments" wrote:

    > Need to know how I can send an Excel spreadsheet via a Macro function in
    > Access (withou using VB code if possible...)
    >
    > Thank You.
    >
    >
     
  4. Hi -
    I already have the spreadsheet generated (via the TransferSpreadsheet
    action). What I need to do now is to send (in Outlook) the spreadsheet via
    some kind of Access command. Is there a way to do this? Thansk.

    "Delordson Kallon" wrote:

    > Do you mean you want to export data from an Access table to Excel using a
    > macro? If yes, create a new macro and select the TransferSpreadsheet action.
    > Set the transfer type to Export and enter yur Excel version and the table
    > name. Finally enter the full path and file name of the Excel file. Save and
    > run the macro to do the export.
    >
    > My apologies is this is not what you were after.
    >
    > Delordson Kallon
    > www.instantsoftwaretraining.com
    >
    > "Send Object Command - Two attachments" wrote:
    >
    > > Need to know how I can send an Excel spreadsheet via a Macro function in
    > > Access (withou using VB code if possible...)
    > >
    > > Thank You.
    > >
    > >
     

Share This Page