+ Reply to Thread
Results 1 to 4 of 4

Macro to Rename a sheet/Export to pdf/Mail it (on a Mac), help needed

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    Italy
    MS-Off Ver
    Microsoft Office 2011 Mac
    Posts
    3

    Macro to Rename a sheet/Export to pdf/Mail it (on a Mac), help needed

    Hi guys,

    I need a macro that does 3 things:

    1) rename 2 sheets based respectively on 2 cells (let's pretend they are cell "A1" for each sheet);
    2) save them as PDFs and Mail the 2 PDFs through Mail (the Mac app);
    3) send this mail to 3 different addresses, 2 of which are fixed while one should change according to the value of another cell (let's pretend it's "A2").

    Is this even possible? I'm very new to excel and have no programming skill whatsoever, but I really need this workbook to work properly and this macro is way beyond my skills. Moreover, the only ones I've found online that are even vaguely similar to what I need use Outlook instead of Mail.

    Thanks in advance for any help.

  2. #2
    Registered User
    Join Date
    06-18-2015
    Location
    Italy
    MS-Off Ver
    Microsoft Office 2011 Mac
    Posts
    3

    Re: Macro to Rename a sheet/Export to pdf/Mail it (on a Mac), help needed

    Anyone guys?

    I'm really stuck on this.

    Thanks

  3. #3
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Macro to Rename a sheet/Export to pdf/Mail it (on a Mac), help needed

    Cross-post;http://www.mrexcel.com/forum/excel-q...lp-needed.html
    Read this;http://www.excelguru.ca/content.php?184
    Please click the * Add Reputation if this helps
    If solved remember to mark Thread as solved

    "I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."

  4. #4
    Registered User
    Join Date
    06-18-2015
    Location
    Italy
    MS-Off Ver
    Microsoft Office 2011 Mac
    Posts
    3

    Re: Macro to Rename a sheet/Export to pdf/Mail it (on a Mac), help needed

    My bad,

    I didn't even know "cross-posting" was a thing or that it was frowned upon.

    Thanks for the info, I'll be more careful in the future.

+ 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] Copy a sheet, rename it by value in range then export product to new workbook and rename
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2015, 07:24 PM
  2. Export outlook mail body to excel sheet
    By amphinomos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 09:33 AM
  3. [SOLVED] Help with Chart to PNG export macro needed.
    By mileater in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 02:42 PM
  4. [SOLVED] VBA/Macro help needed for Mail Merge in Excel and export each record as PDF format
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-28-2013, 06:33 AM
  5. Replies: 4
    Last Post: 07-08-2008, 11:14 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1