+ Reply to Thread
Results 1 to 3 of 3

VBA save and email

  1. 09-21-2016, 12:18 PM #1
    Sovereignty9
    Sovereignty9 is offline
    Registered User
    Join Date
    09-21-2016
    Location
    Measham
    MS-Off Ver
    2010
    Posts
    1

    VBA save and email

    Can anyone help me??

    Please look at the attached pictures of some vba coding I have used on a work spreadsheet. Picture 4 Is the main coding I want rectified however I'm struggling with the automated save bit, and I do not want it too be a temporary copy that is deleted. I want the code to ensure that when the assigned button is clicked to automatically save it to a certain location as "Rosti Sills Delivery Check DDMMYYY". You can see from picture 3 that I have got this to happen but unable to make it work when send an email at the same time.

    Can anyone please help and suggest some changes to get this working as required.

    Much appreciated

    JoeJoe
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 09-21-2016, 12:20 PM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167
    Hello Sovereignty9,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 09-21-2016, 12:28 PM #3
    Doc.AElstein
    Doc.AElstein is offline
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: VBA save and email

    Hi Sovereignty9 (JoeJoe )
    Welcome to Excel Forum

    This is just the Sub Forum to say hello

    You must start a new Thread here if you need help:

    http://www.excelforum.com/excel-general/
    or here:
    http://www.excelforum.com/excel-formulas-and-functions/
    or for help with a macro solution then here:
    http://www.excelforum.com/excel-programming-vba-macros/

    _............................................

    Please, if you get time, take some time before posting to read the Forum Rules here
    http://www.excelforum.com/forum-rule...rum-rules.html
    http://www.excelforum.com/forums-rules/
    It is usually worth it in the long run.

    Thanks

    _..............................................

    P.s.
    Please do not use images as we cannot copy them to a worksheet.
    ( and BTW I only see 2 , not 3 )

    Please
    Either:
    Post screenshots COPYABLE to a Spreadsheet: – See my signature below,
    or here:
    http://www.excelforum.com/excel-prog...ml#post4399581
    Practice here:
    http://www.excelforum.com/development-testing-forum/

    OR:
    Upload a Workbook    : See here:
    http://www.excelforum.com/the-water-...his-forum.html ( Method 2 and Method 3 )
    http://www.excelforum.com/suggestion...ml#post4335120
    OR:
    There is also the file share site option such as this free thing:
    https://app.box.com/signup/personal
    (_ .Remember to select Share after uploading and give us the link they provide if you use that )
    But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
    For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags # )

    OR:
    Select the table Icon above, select an appropriate size table and fill it in (If replying to a Thread you may need to select the Go Advanced Button, ( bottom right of reply Window ) to get the Table Icon to show )


    Practice Posting techniques here:
    http://www.excelforum.com/development-testing-forum/

    Thanks,
    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
    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. Save sent email
    By plans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2015, 04:10 PM
  2. Macro - Save Word as PDF with Unique Name and Email PDF to specified email address.
    By newbie1234 in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2014, 11:54 PM
  3. Email message sent on save
    By Matt_Excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2013, 12:17 PM
  4. [SOLVED] save and email macro
    By fishnic in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 12-28-2012, 05:53 PM
  5. Macro to save sheet as values, save the document using the values in cell b14 and email
    By LAWLOK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2012, 08:42 AM
  6. How could I save as pdf and send email
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2011, 05:13 AM
  7. edit, save as new and email to multiple email addresses
    By murphyx232 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2007, 02:37 PM

Tags for this Thread

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