Excel Macro to creat & send email
 

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.

Excel Macro to creat & send email
 

Yes that is possible

See
http://www.rondebruin.nl/mail/folder3/message.htm

The are a lot of other examples on my site
http://www.rondebruin.nl/sendmail.htm

(read also the info on the tip page, link on each example page)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ashley" wrote in message ...
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.

Excel Macro to creat & send email
 

hi
see this site....
http://www.rondebruin.nl/sendmail.htm

regards
FSt1

"Ashley" wrote:

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.

Excel Macro to creat & send email
 

Perfect, thanks heaps.

"Ron de Bruin" wrote:

Yes that is possible

See
http://www.rondebruin.nl/mail/folder3/message.htm

The are a lot of other examples on my site
http://www.rondebruin.nl/sendmail.htm

(read also the info on the tip page, link on each example page)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ashley" wrote in message ...
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.


.