+ Reply to Thread
Results 1 to 3 of 3

Macro send worksheet as email attachment?

  1. #1
    Forum Contributor
    Join Date
    09-05-2008
    Location
    UK
    Posts
    103

    Macro send worksheet as email attachment?

    Hi,

    After some searching I can see its possible but my limited knowledge is preventing me from achieving my goal.

    I have a number of worksheets in my workbook and although its easy to do manually I am trying to make it easier for users even less knowledgeable than myself. I am trying to create a macro that that will send the worksheet as an email attachment but with filename located in cell A1.

    All computers use outlook as their email client but have different versions of office ranging from 2007-2013

    Any pointers\help be great.

  2. #2
    Forum Contributor
    Join Date
    09-05-2008
    Location
    UK
    Posts
    103

    Re: Macro send worksheet as email attachment?

    How can I adapt below code to do following

    Dont automatically send, just open email and allow user to select email address
    Use filename referenced in A1
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Macro send worksheet as email attachment?

    replace .send with .display in the outmail section

    Please Login or Register  to view this content.
    dont know how you want users to select email address....are you going to have a list or something from somewhere?
    if so where
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Macro to send email with attachment for each unique email Ids
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2014, 07:12 AM
  2. VBA Code: MACRO to send lotus notes email with excel attachment
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 10:23 AM
  3. Macro to Send whole Sheet via Email in text format not as attachment
    By mobi4u in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2012, 04:37 PM
  4. Macro to send email with multiple attachment
    By excelcheck123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2012, 05:00 PM
  5. How to send email with attachment
    By staciam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2011, 12:19 PM

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