Send an email to an individual based on Cell Value

[DanielleP]

Hi, I have no clue when it comes to macros and VBAs but I work with a few spreadsheets that require them and really could use some help.

I am creating a form which at the bottom has a macro button saying "Send form to XYZ" The user would complete the form, click this button which would then open a new email in Outlook addressed to XYZ with the form attached (NB I do not want an automatic email as there may be other documents that need to be attached.

What I want, is that when the button is clicked, as well as XYZ being the email recipient, if Cell K14 = "Yes" ABC will also become a recipient of the email.

Can anyone help?

[k1dr0ck]

as a start, since you have no attach sample file

Please Login or Register  to view this content.

[DanielleP]

Thanks - it won't allow me to post my existing macro in here

[DanielleP]

It's worked - thanks so much