Thread: Using a macro to work from Excel to Outlook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Using a macro to work from Excel to Outlook
Try this

http://www.rondebruin.nl/mail/folder3/smallmessage.htm

You can use a range reference in the body line

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andrew" wrote in message ...
Hi,

I want to be able to run a macro from Excel that will copy the current Excel
cell (a user), swap to Outlook which will be an open email, simulate pressing
'forward', populate the 'To' field with the user(from Excel) and send the
email.


--
Andrew B


Reply With QuoteReply With Quote