Results 1 to 13 of 13

Email on sheet from a workbook through outlook

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    michigan
    MS-Off Ver
    Excel 2007
    Posts
    6

    Email on sheet from a workbook through outlook

    I have attached a dummy file that I am working with (it is not a macro enabled workbook but I know it will need to be when this is figured out). What I would like to do is take one sheet( the active sheet ) in a workbook that I have open and mail it through outlook. I would like the subject line to be whatever is in the cell next to P.O. Number. I would like the title of the attachment to also be whatever is in the cell next to P.O. Number. I do not need the body of the email in vba. Also, I would like to display the email so that I can choose who I send it to. If anyone can help with this I would greatly appreciate it. If you need any more information please let me know.

    Thank you in advance.
    Attached Files Attached Files
    Last edited by dhes5555; 08-29-2012 at 12:24 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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