Picking up a cell value but putting a different cell value (x2) in the email body

AndreaSharkie 1 Reputation point
2022-02-22T16:35:41.127+00:00

HI All. I have written code that picks up all dates in 30 days time where I need to send an email to a specific person telling them that a particular certificate has expired for a particular employee. In the email I would like to pick it up so that it says in the email. " Hello" The SuperHero Accreditation expiry for Iron man is due on 22/03/2022 ( Hey even superheroes need reminding sometime). In this case from my example it would be picking up cells A4 (name), E4 (type of certification) and E4 (actual date) I would like to do this across multiple columns as well ie D to F in this case but in reality across a larger range . Is there an easy way to do this. ( VBA for picking up dates, picking up email and sending to relevant person all in place. Its just the content of the email I am concerned about although I have only written VBA for one column not multiple.) Many thanks in advance. extract of example code to show you what I mean. Thanks

176923-image.png

0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.