+ Reply to Thread
Results 1 to 3 of 3

Build a macro to email 1 tab of worksheet?

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    New York
    MS-Off Ver
    2010
    Posts
    4

    Build a macro to email 1 tab of worksheet?

    Hi. I've never built a macro before but an assistant of mine at a previous company built one for me that would allow me to email just one tab from any workbook to anyone in my email list. I would like to be able to have this functionality in EXCEL 2010 and was hoping that I might be able to get some instructions on how to build this here. Can anyone help?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Build a macro to email 1 tab of worksheet?

    Hello PCuddy,

    Welcome to the Forum!

    Where is your email list?

    Which program do you use to send your emails?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    05-06-2015
    Location
    New York
    MS-Off Ver
    2010
    Posts
    4

    Re: Build a macro to email 1 tab of worksheet?

    Hi Leith,
    My email list is the address book of outlook (2010), which is the same program that I use to send email.

+ 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. Trying to build macro to send a gmail with a single worksheet as an html body
    By collinreuther in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2015, 05:51 PM
  2. attach different worksheet and email them tdifferent email address through macro/vba/addin
    By arunverma004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2014, 08:20 AM
  3. [SOLVED] Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet
    By coa747400 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2014, 03:59 PM
  4. [SOLVED] Email Macro to attach a non active worksheet to outlook email
    By mickgibbons1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2013, 08:38 PM
  5. Automatically Unprotect Worksheet Before Email Macro Then Protect After Email is Sent
    By geepeeone in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-23-2011, 07:45 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