+ Reply to Thread
Results 1 to 1 of 1

save sheets as new file and Attach to e mail.

  1. 02-10-2016, 08:44 AM #1
    tekken
    tekken is offline
    Registered User
    Join Date
    05-22-2013
    Location
    stavanger
    MS-Off Ver
    Excel 2010
    Posts
    13

    save sheets as new file and Attach to e mail.

    Hi

    I have this code to save active sheets as a new file and add it to mail
    have tried too change this so that it stores as xlsx file and not PDF but can not quite figure it out, can anyone help me?


    Please Login or Register  to view this content.
    Last edited by tekken; 02-10-2016 at 02:59 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. add a longer text in VBA and if no file to attach display E-Mail and don't stopp.
    By torti111 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-05-2015, 09:20 AM
  2. Mail from Lotus Notes- Attach File
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2014, 02:56 AM
  3. [SOLVED] How to prompt user to select file to attach to an E-Mail (Excel to Outlook)
    By TheLittlePrince in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2013, 05:33 AM
  4. [SOLVED] How to attach file and send mail automatically
    By thuydo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2013, 03:50 AM
  5. [SOLVED] attach file from folder on c:\ to outlook mail and send
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2013, 11:33 AM
  6. Export to PDF, Save and attach to Mail
    By Patnaik in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-11-2012, 12:46 AM
  7. Attach HTM file to Lotus Notes Mail
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2009, 10:31 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1