+ Reply to Thread
Results 1 to 4 of 4

Multiple worksheets convert to pdf and email to different email address

  1. #1
    Registered User
    Join Date
    06-25-2015
    Location
    Christchurch, New Zealand
    MS-Off Ver
    2010
    Posts
    2

    Unhappy Multiple worksheets convert to pdf and email to different email address

    I have an excel spreadsheet which has 25 worksheets in it. Each worksheet is designed for a specific person. what I want to do is take each individual worksheet and convert to individual pdfs and then email to different people.

    Sheet 1 convert to pdf and email to bob
    sheet 2 convert to pdf and email to jane
    sheet 3 convert to pdf and email to sam
    etc
    etc

    the vba code i have at the moment is

    Please Login or Register  to view this content.

    The mail worksheet is as follows
    Column A - name of the worksheet
    Column B - the email address
    Column C - the subject of email

    I am totally new to all this and really need help to get it going
    Last edited by daakerry; 06-25-2015 at 05:14 AM.

  2. #2
    Registered User
    Join Date
    06-25-2015
    Location
    Christchurch, New Zealand
    MS-Off Ver
    2010
    Posts
    2

    Re: Multiple worksheets convert to pdf and email to different email address

    Apologies, this is all new to me. now changed

  3. #3
    Registered User
    Join Date
    05-03-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Multiple worksheets convert to pdf and email to different email address

    Hi, daakerry.
    I wonder how to used these codes? Do I need a
    PDF converter as well?



    Best regards,
    Arron

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Multiple worksheets convert to pdf and email to different email address

    Arron

    Do you want to send the PDFs as attachments?
    If posting code please use code tags, see here.

+ 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] Convert Email address in cell into a link
    By tiesto643 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2014, 09:07 AM
  2. Convert names to email address
    By Meger5 in forum Excel General
    Replies: 4
    Last Post: 03-28-2014, 11:55 AM
  3. automation/macro for sending email to multiple email address
    By saurabhlotankar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2013, 12:13 PM
  4. Replies: 1
    Last Post: 03-08-2012, 01:57 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