Results 1 to 3 of 3
  1. #1
    Authomas is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2022
    Posts
    7

    Question Export to excel and format excel using macro

    I am stuck on how make a macro to export a query to excel and how to format that file (remove column, wrap text, etc.), and then save that excel file to a specific folder. I can then later in the code attach the excel file into a outlook email. Just wondering if this is possible and if so how?



    Thanks,

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    10,502
    perfectly possible - a common question. See similar threads at the bottom of this one

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,521
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Export to Excel and format
    By aytee111 in forum Programming
    Replies: 7
    Last Post: 01-27-2014, 05:40 PM
  2. Export to Excel in Transpose Format
    By abdulnaseer in forum Import/Export Data
    Replies: 1
    Last Post: 01-30-2013, 02:18 PM
  3. EXPORT to Excel via Macro
    By ruggierm1 in forum Import/Export Data
    Replies: 15
    Last Post: 09-25-2012, 09:33 AM
  4. Export to Excel, format and e-mail
    By NISMOJim in forum Programming
    Replies: 16
    Last Post: 08-18-2012, 12:13 AM
  5. Report export to Excel with format
    By mrswarrick in forum Access
    Replies: 3
    Last Post: 02-29-2012, 03:10 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums