+ Reply to Thread
Results 1 to 2 of 2

Setting up an Excel sheet that has buttons to email a sheet

  1. #1
    Registered User
    Join Date
    02-28-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    1

    Setting up an Excel sheet that has buttons to email a sheet

    Hi All

    First time poster - please go easy.

    I know what I want and I have got somewhere to it on my own but Im stuck.

    My goal is to have one page that I can email the information to via buttons on said sheet. The email also has to come from a group account and not my personal one.
    This has to email within the body of the email and not an attachment.

    I have got one button working and it emails a page but its from my personal account,
    The code I have is :


    Please Login or Register  to view this content.
    Can anyone help?

    Thank you in advance

    G
    Last edited by Leith Ross; 03-01-2015 at 05:57 PM. Reason: Added Code Tags

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Setting up an Excel sheet that has buttons to email a sheet

    Try adding a From line like this
    Please Login or Register  to view this content.
    After the .BBC line and before the .Subject line
    Put the group account email in place of the "xxx@xxx"
    Last edited by gmr4evr1; 03-02-2015 at 12:34 PM.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

+ 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. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  2. Replies: 11
    Last Post: 10-14-2012, 01:03 PM
  3. Unwanted buttons showing up in new sheet created with a Macro and Template sheet
    By fsurf02 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2011, 06:20 PM
  4. Replies: 1
    Last Post: 06-01-2010, 07:44 PM
  5. send excel sheet to email recipients contained on the sheet
    By ghynes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2007, 11:20 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