Access 2007 error when sending email through Outlook 2007

I send email using this module:
Sub sbSendMessage(argRecipient, argFrom, argSubject, argBody, argUserKey, 
   Dim objOutlook As Outlook.Application
   Dim objOutlookMsg As Outlook.MailItem
   Dim objOutlookRecip As Outlook.Recipient
   Dim objOutlookAttach As Outlook.Attachment
   Dim tmpRecipient As String
   Dim tmpSubject As String
   Dim tmpBody As String
   Dim tmpFrom As String
   Dim tmpUserKey As Long
   Dim tmpNbrEmail As Integer
   tmpRecipient = argRecipient
   tmpSubject = argSubject
   tmpBody = argBody
   tmpFrom = argFrom
   tmpUserKey = argUserKey
   tmpNbrEmail = argNbrEmail
   On Error GoTo ErrorMsgs
   ' Create the Outlook session.
   Set objOutlook = CreateObject("Outlook.Application")
   ' Create the message.
   Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
   With objOutlookMsg
      ' Add the To recipient(s) to the message. Substitute
      ' your names here.
     Set objOutlookRecip = .Recipients.Add(tmpRecipient)
      objOutlookRecip.Type = olTo
      ' Add the CC recipient(s) to the message.
  '    Set objOutlookRecip = .Recipients.Add("Andrew Fuller")

      objOutlookRecip.Type = olCC
      ' Set the Subject, Body, and Importance of the message.
      .Subject = tmpSubject
      '.Body = tmpBody & vbCrLf & vbCrLf
      .Importance = olImportanceHigh  'High importance
      .BodyFormat = olFormatHTML
      .HTMLBody = tmpBody
    '  .SenderEmailAddress = tmpFrom
      .ReadReceiptRequested = False
      ' Add attachments to the message.
     ' If Not IsMissing(AttachmentPath) Then
      '   Set objOutlookAttach = .Attachments.Add(AttachmentPath)
      'End If
      ' Resolve each Recipient's name.
      For Each objOutlookRecip In .Recipients
         If Not objOutlookRecip.Resolve Then
         End If
   End With
   Call UpdateTracking(tmpUserKey, tmpNbrEmail)
   Set objOutlookMsg = Nothing
   Set objOutlook = Nothing
   Set objOutlookRecip = Nothing
   Set objOutlookAttach = Nothing
   Exit Sub
   If Err.Number = "287" Then
      MsgBox "You clicked No to the Outlook security warning. " & _
      "Rerun the procedure and click Yes to access e-mail " & _
      "addresses to send your message. For more information, " & _
      "see the document at" & _
      "/previous/outlook/downloads/security.asp. "
      MsgBox Err.Number & " " & Err.Description
   End If
End Sub

It worked until I installed FrontPage 2003.  Now I get an 429 ActiveX can't 
create object error.  Help?????? 
2/28/2007 3:29:34 PM
access.formscoding 7493 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 27


Similar Artilces:

2 Outlook .pst folders
Hi, When I go to the data file management, I am getting 2 PST folders listed. Both pointing to the same file, but one is marked in the Comment Column saying "mail delivery location". Any idea why? I'm seeing 3 Personal Folders listed in my listing. I'm using Outlook 2003. Thanks! Only you would have an idea why. Most likely it had to do with migrating your Outlook data incorrectly when you installed Outlook 2003. You now have a corrupt profile and need to create a new one. -- Russ Valentine [MVP-Outlook] "Paul" <>...

Outlook 2003 attempting to send messages....
To Anyone: Here is a weird one. OS XP Pro SP2 / Office System Pro 2003. POP mail only. No SMTP authentication required. Everything working fine until recently when Outlook 2003 stopped sending messages and is attempting to send 1 of 2 messages when there are non in the Outbox.... Some posts say re-install Office System. Looking for alternatives. Any takers? ...

outlook over RPC new auth behaviour introduced?
I've been trying to isolate a strange issue with OORPC. Prior to some recent patching, a user would be able to log on to outlook over RPC without a workstation being a member of the domain by installing the relevant certificates and configure and setting up outlook as usual. Additionally your local cached login ID (say for example, a domain laptop was offsite and you logged in with cached info) did not seem related to whether you could log into an outlook over RPC account for a different user so long as you were using different outlook profiles. Now it seems that OORPC is only work...

Controlling Access to Contact's History
Is there a way to set a security role up so a user can't delete items from a Contact's History? The user would still need rights to read/ write to the contact record. Go to Settings-->business unit settings-->security roles Choose a role to edit (other than system administrator, you can't change that one). Select the Core Records tab. History, in terms of tasks and appointments, is controlled by the Activity row. History, in terms of notes, is controlled by the Note row. You can set the read and write "pies" seperately from the Delete "pie". Clear th...

How do you set up a submit button to attach worksheet in email?
I am doing a form and I want to have a submit or send link on the bottom of the page. I know how to make hyperlinks but I dont know how to get it where when the user hits the send button it automatically saves that info and sends that form to the intended email address. Basically so you dont have to attach it yourself through email. Is there a way to do this? Have a look here for code to send mail -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on a...

Error 1305
I have Office 2000 on my pc, but not Publisher. When I try to add Publisher from disk 2 of Office, I get the 1305 error Error 1305. Error Reading from file. D:\PFiles\MSOffice\Office\SBT\BFM\Whaitif.xla. Verify that the file exists and that you can access it. Can anyone tell me how to complete this installation? I do have Publisher also installed on my other home pc and both are connected by a wireless network. Would that be the reason it doesn't work? TIA Larry This article also addresses error 1305 OFF: "Error 1304: Error Writing to the File" When You Instal...

Incoming Emails 01-15-10
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Email Client: pop Why am I suddenly getting the same emails sent to me over and over again whenever I log on? Every time I log on, I now get emails from last week that I've already received and even deleted. On 1/14/10 5:47 PM, in article 59bb0f88.-1@webcrossing.JaKIaxP2ac0, "" <> wrote: > Why am I suddenly getting the same emails sent to me over and over again > whenever I log on? Every time I log on, I now get emails from last week that > I've al...

Cannot read Base64 encoded emails (OL98)
Hello folks, I have a problem with one of my Outlook 98 machines. One user (Ironically the boss!) cannot read base64 encoded emails, they come up as garbage, which I then have to run through a Base64 decoder. Other users also use Outlook 98, but can read the emails fine. the problem affects the message text and encoded objects. Mail is coming from the same local server (602 ProLan Suite). The machine with the error is running build 8.5.7806.0. The other machines (Which read messages fine) are both running build 8.5.5104.6. This leads me to thinking that the problem is a result of a ...

there was an error reading the rules from the server
I'm getting this error when i try to run the "oiut of the office assistent". any idia? I run Outlook 2000 with Exchange server. Thanks Ronnie ...

Sending email but outbox is empty
Hi NG, When I press send/receive Outlook shows in its status bar that it works on sending emails (Sending messages 1 of 4) but there is not mail in outbox. As a result I currently cannot send any other mails since Outlook keeps working on the 4 emails I don't see. Any ideas, I am clueless? - Thanks a lot for any help!!!! Dirk ...

set up email 07-14-10
hello.i am trying to set up an email account on my laptop and my modem is my Blackberry phone.everytime i try to set it up it comes back with all kinds of email on the phone works great,but i would rather have an account on my phone is T-Mobile Blackberry Bold.i would be very thankful for any help. "Looster59" <> wrote in message > hello.i am trying to set up an email account on my laptop and my modem is > my > Blackberry phone.everytime...

Money 2005 Communication Error
I recently linked a Passport account with my Money file and now I can't import my OFX files from my bank anymore. I saw some other posts related to MSN Billpay which I've never used. It looks like this is a known problem. Does anyone know of a fix? I thought the problem was my bank so I went a couple of weeks before investigating this issue; now my backup file is also corrupted. I tried the Money repair function but to no avail. In, keanton wrote: >I recently linked a Passport account with my Money file and now I can't >import my OFX files from ...

Office 2007 and Windows 7 Multilingual Issue
Hi All, Need some help setting up multilingual for Office 2007. Here's what I have: OS: Windowns 2007 Enterprise Office: Office 2007 Pro w/ SP2 Language Pack: Install several language packs thru the Windows 7 Update process So, here's the thing. I can't get the UI in the office apps (WOrd, Excel, etc) to display the language I want. For example, I want the ribbon to display in Chinese. Reading thru the documentations from Microsoft, it saids I need to select the laugage in the "Display Language" tab on All Programs -> Microsoft Office -> M...

Sharing tasks in OL 2007
We have a staff Atty office which keeps task lists for Civil (CV) and Criminal (CR) cases by year. There are like 2 - 3 for every year such as CV09 and CR09, however they track for more than just the current year. The person that creates these lists uses some user defined fields so when new users get these shared, they have to create the same fields. My question relates to the inconsistent behavior of the field when adding it to a new task list. Sometimes, the user enters a new field and it is available for subsequent task lists and other times the user has to add teh same new...

adds staff to access list to ALL PROJECTS if same as their departm
A procedure was written to update all projects, adds staff to access list to ALL PROJECTS if they are the same as their home department. It would be useful to know if there were a feature to define default projects by a given criteria - i.e. By department. [d]elete accesslest insert accesslest (PACONTNUMBER, PAPROJNUMBER, EMPLOYID, ContractEntry, ContractInquire, ContractReport, ContractReview, ProjectEntry, ProjectInquire, ProjectReport, ProjectReview, ALEntry, ALInquire, ALReport, ALReview, EEEntry, EEInquire, EEReport, EEReview, ELEntry, ELInquire, ELReport, ELReview, FFEnt...

new email notification doesn't work?
In Outlook 2003, I have the option set for the semi-transparent notification window to pop up when I get new email, but it never does. Is there something I'm not doing right? Does it only come up in certain situations? Btw, I'm using the regular Inbox with a POP3 account. -- John Salerno Do you have rules moving your email to folders after receipt? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searchi...

Compile error in hidden module?
Hi everone, In a workbook I am using, everytime I try to open the file I am getting a "Microsoft Visual Basic" window saying: "Compile error in hidden module: This workbook" What does that mean and how can trace it? Regards, Mike;en-us;307410 I suggest the latest version of reader. FAST . -- Don Guillett SalesAid Software "Mike" <> wrote in message > Hi everone, > > In a workbook I am using, e...

DSRestore Error <ID:997>
I'm getting the DSRestore error event in the logs of my PDC Emulator. I found the steps to reset the dsrestore password here: My question is, if I follow those instructions and reset the dsrestore password, will it also reset the administrator account password to match the dsrestore password? Hello Andrew, The DSRM restore mode password has nothing to do with the previous local administrator, when the DC was workgroup server nor with the domain administrator account. Best regards Meinolf Weber Disclaimer: This posting is...

Error "Money is not properly installed..."
"Please try setup again". I am getting the error above after changeing the non-system drives letters on my system (after adding a new drive). The info I found (to run money.exe with -s or to run the salvage tool) didn't help. The "-s" option runs into the same issue, salvage is reporting a badly damaged file. After hitting "ok", I get a new window with options to open, create, restore or repair a file. Restore, open and repair are all failing. Create new reports "The new file c:\t.mny" can not be created ...". I was using Money 2000. ...

"Object not found" error and Archive Folders
I am battling hard to find who on this planet knows this one I have a rogue 'Archive Folder' living next to my Personal Folders tha I am unable to remove - when I select 'Close "Archive Folders"' th following error dialog is displayed "The operation failed. An object could not be found I've got Outlook 2003 (Office Pro Edition) running on XP Pro - with al and latest updates. I've verified I can add and remove other datafile with no issue - this is also my default archive folder. To explain further, the archive folder in question is the same one a spe...

Report Error
Hi all, any ideas on this.... We have created a number of Quotation Reports that work fine for all users except one ! When she runs the report she gets an error saying the sub report can be found. I have checked that she is in the same CRM groups as other users and checked that she is in the Reporting group in Windows/SQL - all looks fine. Any help would be appreciated Thanks Ian Hi Ian, Does she have problem with this report only or this happens to her other reports as well? Darren Liu, Microsoft CRM MVP On Nov 7, 5:29 am, "Ian Kelsall" <...

windows xp frontpage error
Just got a call from my child at college, is getting a message saying to "put in windows xp cd with frontpage", it was installed at the factory and the cd says nothing about frontpage, was installed in coputer in2004 windows xp professional, autoupdatw won't do it. any clue to what is going on? Is freezing computer and won't open excell. Hi Diana, Though this is the newsgroup for Microsoft Dynamics GP and not Windows XP or Ofice, I will try to help you out. In future, please post to the appropriate newsgroup. I believe the error message being received is infact askin...

Synchronise Outlook 2003
I am using outlook 2003 on a laptop. I would like to sync my changes with my assistant outlook 2003 when I get back to the office. Is it possible to sync contacts ? I do not want to use a central data base but really sync 2 different data bases. thanks phil <> wrote: > I am using outlook 2003 on a laptop. I would like to sync my changes > with my assistant outlook 2003 when I get back to the office. Is it > possible to sync contacts ? > I do not want to use a central data base but really sync 2 different > data bases.

Can't access comcast newsgroups in outlook express 6 or Outlook 2003
Hi, I had the comcast news server working in both aps, but trying to make it work with outlook 2003 as the default program to access the newsgroup reader, by removing the newsgroup account in outlook express 6, I now can't get it to connect in either ap. duh... It's completely gone from Outlook 2003, ie, where before, under the go button there was a link to news, now there is not. Outlook express 6 still has the newsgroup reader, that's how I'm sending this, but when i try to go to the comcast news server it repeatedly asks for my username and password. I deleted the a...

Sharing Outlook #2
I want to set up three account on my outlook. I have already set up two of them. Is there any way of switching from profile to profile while in outlook? nope...afaik... "PaulaDawn" <> wrote in message news:OHC8VWbSEHA.3692@TK2MSFTNGP10.phx.gbl... > I want to set up three account on my outlook. > I have already set up two of them. Is there any way of switching from > profile to profile while in outlook? > > Only by shutting down and restarting - switching MAPI profiles is not as easy as switching identities in Outlook Express. --� Milly Stap...