Excel Macro to creat & send email

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Send Lotus Notes Mails With VBA Macro Excel 0
Macro to use information in a cell to locate and send files using outlook 0
Scripts / Macros in Word and Excel 11
Code to send a email via Macro in excel 1
Email Excel Cell Range using Macro 1
Code to send email to address within selection in Excel workbook 3
Clicking on cell with email address opens Outlook Express 2
macro to send email 2

Top