| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to send a email via Macro in excel | Excel Discussion (Misc queries) | |||
| macro to send email | Excel Discussion (Misc queries) | |||
| use excel to send email without macro | Excel Discussion (Misc queries) | |||
| ***** PLEASE HELP **** Send an email from Excel to outlook with an automatic macro | Excel Discussion (Misc queries) | |||
| Can you send a Macro to someone else by email? | Excel Discussion (Misc queries) | |||
Hybrid Mode
