Connect excel 2007 with OUTLOOK 2007.

**Shradharani** · 08-20-2012, 07:34 AM

Hi ,

I am working on 2007 excel …
I want to connect excel with OUTLOOK 2007.
I will have data such as TO email id and CC email id in two different cells.
Then in one cell subject line … I am thinking if I click on subject line then it should go to the OUTLOOK (New mail message)and capture TO (email id ) CC (email ID) and subject line … if possible then some message which is steady for the email.
Is it possible ??
Please advice

Thanks and regards,
Shradha

**stojko89** · 08-21-2012, 02:57 AM

Here is what I came up with:
Try the attachemnt and click C2... If it works like this for you just change the text you want to add and change the email.
And enter other e-mails under the test subject

**Shradharani** · 08-21-2012, 12:03 PM

Hi ,

Thank you very much ... and yes it is woking fine
But can u tell me how you did that other than macro which u have added ....
I would like to explore myself..

Thanks and regards Shradha

**stojko89** · 08-22-2012, 12:11 AM

Everything I did you can check under the Developer Tab. Or right click Sheet1 and click View Code. There is a code there, which calls a macro when you click on a cell. The called macro is in module1.

**Shradharani** · 08-22-2012, 05:17 AM

ok thank you ....

**Cutter** · 08-22-2012, 10:58 AM

@ Shradharani

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.