Results 1 to 3 of 3

Thread: Sending a single worksheet as an outlook body [RESOLVED]

Threaded View

  1. Aug 29th, 2003, 07:38 AM #1
    jrpfinch
    jrpfinch is offline

    Thread Starter
    Member
    Join Date
    Jul 2003
    Posts
    35

    Sending a single worksheet as an outlook body [RESOLVED]

    I would like to be able to send a single sheet (not whole workbook) as the body (not attachment) of an Outlook mail. This is the best I can do but it only attaches the sheet to the mail:

    Code:
    Worksheets("Redemptions").Select
ActiveSheet.Copy
Application.Dialogs(xlDialogSendMail).Show "[email protected]", "My Subject"
    I would be grateful for any ideas
    Last edited by jrpfinch; Aug 29th, 2003 at 08:46 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width