Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sending a worksheet in an email body (MS Office 2k)

    Hi , I have recently inherited some code that successfully creates an email and loads attachments directly from an excel macro - which is great. But I would also like to send individual excel sheets in the body of an email itself (not as an attachement as such) I've been going through the Outlook library in VBA but nothing appears to work. Any suggestions?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sending a worksheet in an email body (MS Offic

    Hi & welcome to the Lounge

    Check out Ron de Bruin's free SendMail Add-In for Outlook and Outlook Express. It includes options to send the selection or active sheet in the body of the mail

  3. #3
    New Lounger
    Join Date
    Jul 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sending a worksheet in an email body (MS Offic

    Cheers Tony , I have been a very irregular visitor to the lounge over the years but without a doubt its my favourite resource for office hints and tips.

    The link was a great help...much appreciated!

Posting Permissions

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