LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 71
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to send a email via Macro in excel Sunil Somani[_2_] Excel Discussion (Misc queries) 1 September 30th 09 08:28 AM
macro to send email scheduler Excel Discussion (Misc queries) 2 October 18th 07 11:20 PM
use excel to send email without macro Aaron Excel Discussion (Misc queries) 4 July 3rd 07 04:19 PM
***** PLEASE HELP **** Send an email from Excel to outlook with an automatic macro SAM SEBAIHI Excel Discussion (Misc queries) 0 November 11th 06 08:17 AM
Can you send a Macro to someone else by email? Greenback Excel Discussion (Misc queries) 3 August 2nd 06 01:01 PM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"