Access report in rtf format arrives in e-mail as xls file

[KC Classic]

I have a single report (with subreports embedded) that is e-mailed every day.
I have been able to successfully send this report for a couple of months as
an rtf file with no problems.

For some reason unbenownst to me, the report formatting now shows in the
e-mail as an xls file. I do not know why this has changed and have not been
able to arrive at the solution as of yet.

I wondered if anyone has any ideas as to why this might be happening? Your
thoughts are appreciated.

 

[Jerry Whittle]

How exactly do you send the report? Do you do it manually or by some code? If
manually, describe the steps. If code, what does it say?

 

[KC Classic]

Jerry,

Thanks for your response.

The report is sent via a switchboard button that has a basic macro attached
that essentally used the SendObject function to accomplish the task. I am
not a complete novice with respect to Access databases however, I am not sure
in VB where to find the code for the macro used. In the Visual Basic Editor,
I only see the code for "Forms" - no other objects. I will be glad to post
the code for the macro if you can possibly direct me as to where I might
locate the information.

After my post, I have figured out how to manually export the report to a
folder and then attach to the e-mail manually. I am sure we will need to
have the e-mail automatically generate in the near future.

Thanks in advance for your help!

 

[Jerry Whittle]

In that case the code is interpeted within the macro itself. Post all the
sets and arguments for that macro.

 

[KC Classic]

Jerry,

Under the SendObject action:

Object Type Report
Object Name rptCumulativeHartfordReport
Output Format Rich Text Format
To Hartford State Withholding
Cc
Bcc
Subject Cumulative Hartford State Withholding
Message Text The attachment below contains your prior day supersheet
information for the Hartford Funds state tax
withholding.
Please let us know if you have questions or require
assistance. Thank you.
Edit Message Yes
Template File

This action is then followed by a StopMacro action. I hope I have provided
the information necessary. Thank you.

 

[Jerry Whittle]

It looks like your are doing everything correctly. Have you tried saving the
attachment file and changing its suffix from .xls to .rtf. Then see if it
opens correctly?

It's possible that your install of Access is bad. You may need to uninstall
Office Pro then have it reinstalled. Actually if you are due a new computer,
it might be easier to do that.

I doubt if it's a corrupt database problem. You could try importing
everything into a new .mdb file, but I really doubt if that's the problem.

One other off-the-wall thing to try: Open up Windows Explorer. Go to Tools,
Folder Options and select the File Types tab. Give it a few minutes to finish
then see what program is set to open RTF files it should be Word. If Excel,
that might, just might, be the problem.

 

[KC Classic]

Jerry,

Thanks for your help. I have validated that Word is the program currently
used to open .rtf files. I will check out your other suggestions. I believe
I may have to reinstall Access or Office Pro as you stated. I will reply to
this post if I find the fix.

Merry Xmas!