Problem automating outlook

[John]

Hi

We have a piece of code that sends emails with attachments (office
newsletter etc.) to our staff via outlook automation. This code has been
running fine for years and this problem has only recently come up. The
problem is that the mail shot starts and emails begin to be sent to the
staff (one per staff) but after around 100 emails have ended up in Outlook
Sent Items, the code in Access stops on the code line

objOutlookMsg.Attachments.Add "F:\Folder 1\8 Mailshots\2008\Feb 08 (2).doc"

with the below error;

Automation error (Error 440)

err.Number: -36683771

err.Description: Can't create file: Feb 08 (2).doc. Right-click the folder
you want to create the file in, and then click Properties on the shortcut
menu to check your permissions for the folder.

err.Source: Microsoft Office Outlook

If I click on Debug and then click on Play button to continue then another
20-50 emails are sent before this comes up and this process goes on. The
outlook version is 2003 and Exchange is 2003. Any help in resolving this
problem would be appreciated.

Thanks

Regards

 

[John Blessing]

There are specific newsgroups which deal with Outlok automation.

I suspect two things:

1. Poor support for filenames that don't fit the old-style dos naming 8.3
formats. There is an awful lot of legacy code in Windows.

2. The outlook security guard, which is precisely designed to prevent other
programs automating Outlook. Not sure what you are doing to work around it.



--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters
http://www.repeatmail.com - Send individual emails, scheduled or one-off,
plain or html