+ Reply to Thread
Results 1 to 3 of 3

Sending an Email to the Name Selected from the List Created in Excel

  1. #1
    Registered User
    Join Date
    04-19-2024
    Location
    İstanbul
    MS-Off Ver
    Office 2016
    Posts
    2

    Sending an Email to the Name Selected from the List Created in Excel

    Hello,
    I uploaded an image as visual support. If I were to explain it through this picture;
    A project will be created in Excel. There will be job descriptions A, B, C, D and E in the project. Each of the job description statuses will be turned on by the administrator from the data verification list, the target date will be entered, clarification will be entered if necessary, and finally, if this job description is selected from the data verification list among the Responsibles, Kemal;
    Project Name: Project A Status: Open
    Job Description: Job A Status: Open
    Target Date:
    Responsible:
    Description and Attachments:

    An e-mail will be sent in the following format.

    In addition, I would like our responsible friend Kemal to enter the excel file and send an e-mail to the manager after saving the excel file of the information added to the Status Working, Target Date Change and Explanation and attachments sections.
    I hope that has been revealing, thank you.

    Image:hizliresim.com/qnchw6u

  2. #2
    Registered User
    Join Date
    04-19-2024
    Location
    İstanbul
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Sending an Email to the Name Selected from the List Created in Excel

    Current. Can you help me ?
    Last edited by AliGW; 04-26-2024 at 07:58 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,255

    Re: Sending an Email to the Name Selected from the List Created in Excel

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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. sending an email in outlook from a list of email address in excel
    By lydiat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2021, 03:33 AM
  2. Email sending to the selected list
    By Yuvaraaj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2016, 11:27 PM
  3. Sending Email to a List of Recipients Using Excel and Outlook
    By Rajesh shishodia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2015, 04:33 AM
  4. Sending Email to a List of Recipients Using Excel and Outlook
    By Rajesh shishodia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2015, 09:02 AM
  5. [SOLVED] Sending an email of a newly created PDF file through VBA
    By Johnnyv015 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-12-2015, 07:15 PM
  6. [SOLVED] Excel vba sending email validation list
    By E5254730 in forum Excel General
    Replies: 9
    Last Post: 03-10-2015, 04:46 AM
  7. Sending Email to multiple Addresses based on distribution list created
    By sonny.thind in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2011, 10:44 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