Welcome to SPN

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

Sign Up Now!

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

Share This Page