+ Reply to Thread
Results 1 to 1 of 1

Userform to automate email

  1. #1
    Registered User
    Join Date
    11-08-2022
    Location
    singapore
    MS-Off Ver
    365
    Posts
    12

    Userform to automate email

    Hi, I am still very new to VBA and therefore would like to pool in the help from all of the experts here.
    I have attached my report and there is a userform.
    My idea is that when user enters their name and leave days. The necessary info will be shown in the controls on the userform.
    I want to send an email to the approver listed in my control label - Label11.
    I don't know how to code to pull the data from the label field to dynamically send the outlook email to the appropriate approver listed on my form.
    Also , I want a standard email body to be sent capturing the leave applicant's name, days of leave applied etc. All these are capture on my userform as they apply. How can I code them
    so that i automate the sending of emails.Thanks for the help!

    Individual Leave Report Test.xlsm
    Last edited by jaysbp; 11-10-2022 at 06:07 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Automate email send thru ms access 2010
    By waka in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2015, 08:53 PM
  2. automate email to folder
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2014, 06:58 PM
  3. Automate multiple email report.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2009, 09:24 PM
  4. automate email
    By shaunburke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2009, 09:41 AM
  5. Automate Email based on Criteria
    By shaunburke in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-04-2008, 10:43 AM
  6. Automate email
    By shaunburke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2008, 08:16 AM

Tags for this Thread

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