Consulting

Results 1 to 2 of 2

Thread: Send text in cell as email to address listed in sheet

  1. #1

    Send text in cell as email to address listed in sheet

    It's been years since I used VBA and I only have couple of days to do this so I decided to ask for help here.
    Let's say I have a sheet that has some notes/messages in one column (A) and name of a person who should receive the message in other column (B). Then, I have two more columns that list names (C) and their email addresses (D). I'm trying to copy the message, compare the names (B and C) and, if name is found, send the message to their address. I've seen similar solutions but couldn't find exactly what I'm looking for, I hope I've explained it well, every help is appreciated. Thanks.

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,812
    Location
    WorksheetFunction.VLookup(B,C:D,2)

    Put C:D into a dictionary to return Addresses by Name

    Put B and A in a Dictionary and C and D intro another to compare the two Name Keys and return Addresses and messages by Name

    Arrays AB and CD and loop thru both
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

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