CODEWITHSUNDEEP
vbaexcel
Punith Gubbi
Punith Gubbi

Reputation: 692

How to add email address through prompt in Excel VBA?

I am trying to send a chart created through Excel VBA, But how to add the recepients dynamically through prompt.

wkbk.SendMail Recipients:="[email protected]" . here how to add the email address(More than 1 email address) through prompt, instead of defining it in code.

Upvotes: 0

Views: 1196

Answers (1)

Huy Pham
Huy Pham

Reputation: 493

wk.SendMail Recipients:=Application.InputBox("Please enter email address:", "Email Address", , , , , 2)

Upvotes: 3

Related Questions