Results 1 to 7 of 7

Need to modify my code to allow user to input address(es) to email to

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-08-2009
    Location
    Missouri
    MS-Off Ver
    Excel 2003
    Posts
    183

    Need to modify my code to allow user to input address(es) to email to

    On one of my sheets I currently use this code to send an email to a know address. What I want to do is alter this code so that rather then simply sending a message, the user will have to enter the recipients of which to send to...

    Thanks for the help!



            
        With ActiveWorkbook
             .SendMail Recipients:="[email protected]", Subject:="Car # " & Sheets("EmPr").Range("CG2 ") & " is attached and awaiting your approval to be closed."
             .Close SaveChanges:=False
       
       End With
    Last edited by mrgillus; 08-27-2009 at 02:52 PM. Reason: added (es) to title- need to beable to specify more than one recipient

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