Results 1 to 3 of 3

VBA save and email

Threaded View

  1. #1
    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

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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1