Well, I don't think you're on right way..If you'll look at the code
which I'd posted earlier, you'll find it is very easy to do so...
Previous Code..
Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft",
DisplayAsIcon:=True, IconFileName:="packager.exe", IconIndex:=0,
IconLabel:="Sample").Select
You can just provide the application path of the Outlook in
IconFileName...Also you can change the IconIndex number, because this
exe file contains more than 1 icons...Look at the following code...
Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft",
DisplayAsIcon:=True, IconFileName:="C:\Program Files\Microsoft Office
\Office12\OUTLOOK.EXE", IconIndex:=0,
IconLabel:="Sample").Select
Regards
Deepak
On Nov 14, 5:06 pm, "sreejith k.s" <sreejith.ks1...@gmail.com> wrote:
> hi friend,
>
> i dont think that you can insert the outlook email icon while
> inserting it as an object, rather you can insert in the form of an
> object.
>
> for that follow these steps.
>
> Select Insert
> object
> Create from file .....
>
> Check the box ' Display as icon'
>
> hope you would get an better solution than this.
>
> regards
> Sreejit
>
> On 11/14/11, Prathap <prathap....@gmail.com> wrote:
>
>
>
> > HI All,
>
> > I`m trying to embed the Outlook mail into a cell in Microsoft excel (2010)
> > through Insert object. However after embedding, object is not showing the
> > outlook icon rather than dispalying as blank object. Attached is the
> > sample file.
>
> > Best Regards,
> > PRATHAP D
>
> > --
> > FORUM RULES (934+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> > not get quick attention or may not be answered.
>
> > 2) Don't post a question in the thread of another member.
>
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
>
> > 4) Acknowledge the responses you receive, good or bad.
>
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > ------------------------------------------------------------------------------------------------------
> > To post to this group, send email to excel-macros@googlegroups.com- Hide
> > quoted text -
>
> - Show quoted text -
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
