Results 1 to 39 of 39

Fill in recipient of email in Outlook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2010
    Location
    Youngstown, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    182

    Fill in recipient of email in Outlook

    Is there a way to add code to the existing code that will populate the "To" area in an Outlook email directly from source information located within the worksheet being sent?

    Sub MailSheet()
        Dim shtName As String
        shtName = ActiveSheet.Name
        ActiveSheet.Copy
        ActiveWorkbook.SaveAs Filename:=Application.GetSaveAsFilename("Request for Quote " & shtName, "Microsoft Excel File, *.xls")
        Application.DisplayAlerts = False
        Application.Dialogs(xlDialogSendMail).Show
        With ActiveWorkbook
            .ChangeFileAccess xlReadOnly
            Kill .FullName
            .Close False
        End With
         
        Application.DisplayAlerts = True
    End Sub
    Attached Files Attached Files
    Last edited by cheddarthief; 04-15-2010 at 01:52 PM. Reason: Solved.

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