+ Reply to Thread
Results 1 to 2 of 2

VBA - Dynamic emails with multiple cell references

  1. #1
    Registered User
    Join Date
    10-16-2024
    Location
    Portland, OR
    MS-Off Ver
    Office 365
    Posts
    5

    VBA - Dynamic emails with multiple cell references

    I'm a company trainer. Anytime a new hire class is starting with my company, we contain all their data in a spreadsheet, and we individually email them their usernames and passwords to the half-dozen systems we use.

    With class sizes up to 25 this can take forever, even with an outlook template. I'm looking for a way to have trainers click on the cell next to the new hire's name and have vba open outlook, generate an email in format shown in the example file, and fill in each of the bracketed items with the specific cell values from that person's row of the table.

    I can figure out the hyperlink stuff on my own if needed. Mostly I need help with the code that pulls the First name, email address, and usernames and passwords and formats the email in outlook. Ideally when the "send email" cell is selected.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    7,999

    Re: VBA - Dynamic emails with multiple cell references

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for Sheet1 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Double click any cell in column C to create the email for the person in that row.
    Please Login or Register  to view this content.
    Last edited by Mumps1; 11-06-2024 at 12:59 PM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ 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. dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 PM
  2. dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  5. dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. dynamic cell references
    By excel novice in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-12-2005, 10:05 AM

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