Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

Re: send xls file as attachment from access vba

Discussion in 'Information Technology' started by Neil Sunderland, Nov 10, 2005.

  1. Neil Sunderland

    Neil Sunderland
    Expand Collapse
    Guest

    On Sat, 19 Mar 2005, jimtotem wrote:
    >I followed the sample in the KB article (209948), loaded the "Mirosoft
    >Outlook 10 Object Library (Office XP), and attempted to run the code (VBA).
    >In Northwind, I received the "Run-time error '48'; Error in loading DLL."
    >
    >I installed and ran the code described in Article ID : 161088 and also
    >received the
    >"Error loading DLL" message at the " Set objOutlook =
    >CreateObject("Outlook.Application")" also noted in the code sample below.
    >
    >I do not know what to do now. I need some "hand-holding."
    >
    >Jim
    >
    >Private Sub cmd_SendMail_Click()
    >On Error GoTo Err_cmd_SendMail_Click
    >
    > Dim objOutlook As Outlook.Application
    > Dim objOutlookMsg As Outlook.MailItem
    > Dim objOutlookRecip As Outlook.Recipient
    > Dim objOutlookAttach As Outlook.Attachment
    > ' Create the Outlook session.
    > Set objOutlook = CreateObject("Outlook.Application")
    >
    > ' Create the message.


    We've had this problem recently, and I think we've fixed it - just
    declare your Outlook.Application object without a data type:

    Dim objOutlook
    Dim objOutlookMsg As Outlook.MailItem
    Dim objOutlookRecip As Outlook.Recipient
    Dim objOutlookAttach As Outlook.Attachment
    ' Create the Outlook session.
    Set objOutlook = CreateObject("Outlook.Application")

    I don't know /why/ this fixes it, it just does!

    --
    Neil Sunderland
    Braunton, Devon

    Please observe the Reply-To address
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Why This Sikh Cartoonist Is Sending A Postcard To Trump Every Day Breaking News Mar 23, 2016
    UK Statue of turbaned Sikh fighter pilot unveiled in Gravesend Breaking News Nov 29, 2014
    Leisure Appropriate to send flowers to a friend's ill Mother in India? Business, Lifestyle & Leisure Jun 6, 2013
    USA Preet Bharara Sends a Message to Wall Street about Insider Trading Breaking News May 18, 2011
    USA U.S. Sends Warning to People Named in Cable Leaks Breaking News Jan 7, 2011

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page