+ Reply to Thread
Results 1 to 3 of 3

Send e-mail with attachment

  1. #1
    Forum Contributor
    Join Date
    05-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    184

    Send e-mail with attachment

    Basically the code below rename the active workbook to "Denise" and save it under a folder, then send out that file as an attachment through e-mail. At least that is what I am trying to accomplish; however, the e-mail sent without an attachment. Can someone help me audit my codes?


    Thank you so much!


    HTML Code: 
    Last edited by alexduy; 03-03-2016 at 01:41 AM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Send e-mail with attachment

    Please Login or Register  to view this content.
    you dont need the first line

    then i think your missing an "s"
    Please Login or Register  to view this content.
    should be
    Please Login or Register  to view this content.
    ps shouldnt really use .send when testing....use .display to avoid sending out stuff that doesnt need to be
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Send e-mail with attachment

    Please Login or Register  to view this content.
    i would also suggest using SaveCopyAs to avoid those messagebox

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto send mail with attachment
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-13-2013, 09:38 AM
  2. Excel send e-mail with two attachment
    By rbbahia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 03:27 PM
  3. Code to send an e-mail. Don't send if attachment not found
    By thedon_1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 05:41 PM
  4. [SOLVED] Send E-Mail with Attachment
    By Vladamir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2012, 02:52 PM
  5. Excel Send to Mail Recipient (as Attachment)
    By Dave in forum Excel General
    Replies: 2
    Last Post: 02-23-2006, 05:15 PM
  6. Replies: 4
    Last Post: 02-12-2006, 05:10 AM
  7. [SOLVED] send to mail recipient as attachment - no worky...
    By Scott McDonald in forum Excel General
    Replies: 0
    Last Post: 04-22-2005, 09:08 PM
  8. [SOLVED] Send to Mail Recipient (as attachment) Lags
    By JGas in forum Excel General
    Replies: 0
    Last Post: 02-09-2005, 03:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1