Cannot create rtf attachment from Access report

[arkres]

Hi,

I am using an Access 2007 database. I have several reports created in Access, in that are all sent out through Outlook as rtf attachments using the SendObject method:

DoCmd.SendObject acSendReport, "My Report Title", acFormatRTF, RecipientEMail, , , , Email Message, True, False

I send all messages from the same form and in the same way. It’s been working fine for over a year. Yesterday, one user received this message when trying to send one particular attachment.
Microsoft Office Outlook message that says:

Cannot Create File: MyFileName.rtf.
The message then says to check permissions for the folder I want to save the file in.
Only the one user has the problem. Her front end db is on her hard drive (back end on network). All of her other attachments are sent with no problem. I checked the code on her copy of the db and nothing has been changed. She is able to create the rtf herself, attach it and send it. The only difference between this attachment and all the others is that it is somewhat larger.
I don’t actually save the files that are sent as attachments, and I don’t know enough about Access and Outlook to know if there is a temporary file created to hold these attachments until they are sent.
Has anyone seen this before? I would greatly appreciate any help you can offer.
Thanks so much.

Pat

 

[DCrake]

If the user who is experiencing the problem logs onto another machine and replicates the send command though Access are they successful or not? If not then you can be sure it is the machine. Can another user create the same rtf on another machine of the same type and size and send it ok? It's a case of process by elimination to deduce the nature of the error.

David

 

[arkres]

Hi,

All other users can perform the same SendObject from similar machines, and the original user can log on to other machines with her own ID and send the object. So it's definitely the machine. Thanks.

Pat

 

[darbid]

I have no idea what it could be. But the next thing I would test is if this "machine" can make an rtf from the report. In other words remove the send part.

 

[arkres]

Yes, we can create the rtf, but we can't send it. I am completely stumped!

 

[darbid]

Check outlooks settings for the email format. Can you use Word as the editor?

Can you manually add an rtf or doc as attachment to an email?

 

[boblarson]

Is the Outlook profile on the machine that it doesn't work on set to send email as text only and not as RTF or HTML?

 

[arkres]

Hi,

Yes, I can use Word. I will check the Outlook settings on Monday morning. Thanks to both of you for answering my post. I appreciate it.

Pat