dcleaver
asked on
Send to option Greyed in Access 2003.
When my client attempts to send a report to email using Access 2003, the option is greyed out and they therefore are unable to complete the action. I feel the fault lies with compatibility, as we use Office 2010 for the rest of daily use, such as Outlook for email. Access 2003 is used just for their database. But I have two other servers with identical images installed, and they both allow send to email.
I am at a loss as to what could be preventing send to email. I look forward to hearing your thoughts that could help me find what is causing the issue.
I am at a loss as to what could be preventing send to email. I look forward to hearing your thoughts that could help me find what is causing the issue.
Change:
At some point you will start to see too many comparability issues.to:
At some point you will start to see too many compatibility issues.
I have seen something like this before and for us and it turned out to be permissions for the access 2003 to be allowed to send via outlook 2010, usually you get a popup asking if you would like to allow the application...
This Link may open your outlook client a little too much Outlook Settings
This Link may open your outlook client a little too much Outlook Settings
Or try using a code based solution
DoCmd.SendObject acSendReport, "YourReportName", acFormatPDF, "DestinataionEmailAddress" , , , "YourSubject"
(If you have the PDF add in installed)
or
DoCmd.SendObject acSendReport, "YourReportName", acFormatRTF, "DestinataionEmailAddress" , , , "YourSubject"
(Can be read by MS Word)
or
DoCmd.SendObject acSendReport, "YourReportName", acFormatHTML, "DestinataionEmailAddress" , , , "YourSubject"
(Can be viewed in any web browser)
There are other export formats available as well, ...depending on your needs
DoCmd.SendObject acSendReport, "YourReportName", acFormatPDF, "DestinataionEmailAddress"
(If you have the PDF add in installed)
or
DoCmd.SendObject acSendReport, "YourReportName", acFormatRTF, "DestinataionEmailAddress"
(Can be read by MS Word)
or
DoCmd.SendObject acSendReport, "YourReportName", acFormatHTML, "DestinataionEmailAddress"
(Can be viewed in any web browser)
There are other export formats available as well, ...depending on your needs
ASKER
Hi Jeffrey,
Believe me, we have been trying to get this updated, but the consultant that creates and manages the database just refuses to update it, so sadly got work with whats available. I expect its compatibility causing the issue, but as I said the other two servers work correctly, and they are pretty much identical in every way. I will try and have a look at your other suggestion though, as I haven't tried that and could help.
LBTech, doesn't look the reg keys are there, so may add them and see if that does anything, Many thanks.
Believe me, we have been trying to get this updated, but the consultant that creates and manages the database just refuses to update it, so sadly got work with whats available. I expect its compatibility causing the issue, but as I said the other two servers work correctly, and they are pretty much identical in every way. I will try and have a look at your other suggestion though, as I haven't tried that and could help.
LBTech, doesn't look the reg keys are there, so may add them and see if that does anything, Many thanks.
Believe me, we have been trying to get this updated, but the consultant that creates and manages the database just refuses to update it, so sadly got work with whats available....I hear you...
What's odd is that usually this situation is reversed, ...
Typically the consultant will have the latest/greatest version of Access, ...and it will be the client not wanting to upgrade...
;-)
What is doubly odd is that the consultant should be the one researching this issue, ...not you.
:-O
In any event, ...keep us posted...
JeffCoachman
ASKER
Yeah I know right, this one definitely switches the stereotype :-)
And believe me, I've already has this conversation with him, just yesterday being one of the times! Gonna boot a backup of the server in VM so I can test without affecting users. Will update with my findings.
And believe me, I've already has this conversation with him, just yesterday being one of the times! Gonna boot a backup of the server in VM so I can test without affecting users. Will update with my findings.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Troubleshooting performed found the issue
https://www.experts-exchange.com/questions/28172411/Can't-export-to-email-from-Access-2010.html
Remember that Access 2003 is 14 year old technology.
At some point you will start to see too many comparability issues.
Suggest upgrading to at least Access 2007, where the .accdb format was introduced.