Results 1 to 7 of 7

Thread: How to put an excel submittal form on the internet to email?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    How to put an excel submittal form on the internet to email?

    I have an Excel form used for employees to enter their bonuses. I want this form to be online so they can enter their information and hit “submit” and it will be delivered to me via email. I have domain that is hosted by a company. Can anyone give me step-by-step instructions?

    The Form is attached
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,450
    Articles
    44
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    What email program do you use? And what version?
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Outlook 2010

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,450
    Articles
    44
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Okay, so here's how it works... (VBA code courtesy of Ron deBruin's site at http://www.rondebruin.nl/mail/folder2/mail1.htm)

    When you're in Excel:
    • Press Alt+F11 to enter the VBA editor
    • If you don't see a tree browser at left press CTRL+R to display it
    • Drill down into your workbook
    • Right click "Microsoft Excel Objects" (or something else within your workbook)
    • Choose Insert-->Module
    • In the pane that opens, paste in the following code:
    Code:
    Sub Mail_Workbook_Outlook()
    'Sends the last saved version of the Activeworkbook
        Dim OutApp As Object
        Dim OutMail As Object
    
        Set OutApp = CreateObject("Outlook.Application")
        Set OutMail = OutApp.CreateItem(0)
    
        On Error Resume Next
        With OutMail
            .To = "youremail@yourdomain.com"
            .CC = ""
            .BCC = ""
            .Subject = "Put your subject here between the quotes"
            .Body = "If you'd like to send a message, type that between the quotes here"
            .Attachments.Add ActiveWorkbook.FullName
            .Send   'or use .Display if you'd to test it without sending
        End With
        On Error GoTo 0
    
        Set OutMail = Nothing
        Set OutApp = Nothing
    End Sub
    • Close the VBA Editor
    • On the Developer Tab, choose Insert-->Form Control-->Button
    • Drag a button onto the worksheet
    • When it pops up and asks you to assign a macro, choose "Mail_Workbook_Outlook"
    At that point, you should be good to go.

    If you need any further help, let me know.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    That works really good. Thank You

  6. #6
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,450
    Articles
    44
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Glad to help!
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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