Hi Subu
I haven't tried the entire code, I just helped you figure out how to link
outlook to excel using the concept of early late binding with vba. Internet
search engines tell plenty of things about that.
>From resources I can access, tried to run
Sub CheckBindingLB()
Dim olApp As Object
Set olApp = CreateObject("Outlook.Application")
MsgBox olApp.Name
End Sub
from this code and see what the sub returns. It should return something.
About adding manually the library, called early binding, I meant Microsoft
Outlook 11 Object Library
I have just copied paste from an older internet site.
Using either method, I'm not then sure if your error is related to the
outlook object variable declared in excel. I'm not fully aware of outlook
objects. To me it seems the line with Outlook.Folder should be changed to
something else.
Maybe this should help (again i'm not a professional of outlook objects)
Dim olFolder As Outlook.MAPIFolder
Set olFolder = olNamespace.GetDefaultFolder(olFolderInbox)
HTH
Pascal
On Thursday, December 27, 2012 8:09:42 PM UTC, .. wrote:
>
> Dear Pascal
>
> Thanks.
>
>
> ////you said////////change the yellow line to
> Dim olApp As Object
> Set olApp = CreateObject("Outlook.Application")*
> or add a reference to Microsoft Outlook 9.0 Object Library from Tools -
> Reference
> //////////////////
>
> First I add(ed) a reference to Microsoft Outlook 11 Object Library from
> Tools - Reference within VBA
> Microsoft Outlook 11 Object Library is what I can see I do NOT see Outlook
> 9 object library on my machine
>
> This is what I have done http://bit.ly/V83tIm
> Screen shot file name Screenshot - 12_27_2012 , 11_35_33 PM.png enclosed
>
> When I try your piece of code, after the above setting, I get this error
> http://bit.ly/UoOKL8
> Screen shot file name Screenshot - 12_28_2012 , 12_00_08 AM.png enclosed
>
> The same errors appear even IF I do NOT add reference (or remove the
> reference) to MS Outlook 11 object library in VBA Editor -> tools ->
> References
>
> Thanks in advance for your help
>
> --
>
> Regards
> Subu
>
>
> mail_t...@yahoo.com <javascript:>
> ------------------------------
> *From:* bpascal123 <bpasc...@gmail.com <javascript:>>
> *To:* excel-...@googlegroups.com <javascript:>
> *Cc:* "aks.sh...@gmail.com <javascript:>" <aks.sh...@gmail.com<javascript:>>;
> Subu S <mail_t...@yahoo.com <javascript:>>
> *Sent:* Wednesday, 26 December 2012, 23:56
> *Subject:* Re: $$Excel-Macros$$ Mail merge and E mail : Reminder email to
> customers using VBA
>
> change the yellow line to
> Dim olApp As Object
> Set olApp = CreateObject("Outlook.Application")*
> or add a reference to Microsoft Outlook 9.0 Object Library from Tools -
> Reference
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-...@googlegroups.com<javascript:>
> .
> To unsubscribe from this group, send email to
> excel-macros...@googlegroups.com <javascript:>.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
