+ Reply to Thread
Results 1 to 1 of 1

Sending active workbook as email

  1. #1
    Registered User
    Join Date
    02-08-2005
    Posts
    6

    Question Sending active workbook as email

    Hi,

    I am trying to develop an application that will set up an email to send the active workbook. I am using the following code but it sends the email straight away, whereas I want to review the email and possible add to it before it is sent. Is there a way for me to set the email up but not send it?

    My current code is:

    Dim emailaddress As String
    Range("B1").Select
    emailaddress = Selection
    ActiveWorkbook.SendMail Recipients:=emailaddress


    End Sub

    Cheers
    Alan
    Last edited by bigalmcintyre; 03-15-2005 at 08:58 AM. Reason: spelling mistake

+ Reply to Thread

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