Excel Macro to creat & send email

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

Is it possible to create a Macro in excel that will create & send an email
(via Outlook) given a particular cell value?
i.e.
If Cell 1 = "Send" then Activate Outlook, Copy cell 2, past into 'To:'
field, Copy Cell 3, Paste into ‘Subject:' Field & send email.

If there might be other ways of stream lining this process please advise.
 
Back
Top