Discussion Locked

Outlook & Access in Office XP Pro Ver

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Trying to send a file via Access to Outlook from Office XP Pro version (File|Send To|Mail Recipient (As attachment...)), i can't send it out via my Outlook to my client. Why? Please assist me any expert there...Thanks.

3 replies

by lmberg2005

I Send data from an Access table through Outlook Express by creating a macro in Access and using the Send Object Action. Here's how: go to and open the Access Database, and select the report, table or other object you want to send. Then select the Macro command under Objects. Then click on NEW (macro) above the objects box. This will open the Macro Dialog screen. Click on the down arrow and select 'SendObject'. Press f6 to open the Action Arguments box. Fill in the information and mostimportantly, put the email address of the person you want to receive the information in the TO line. Close/Save the Macro window. When you ready to send just double click on the macro you created. Warning, a dialog box will appear asking you to verify if you really want to send this document. The kicker is that the email address is hidden, but it is there when you press the send button. To verify, go to you outlook SentTo folder and check if your email is there.

Good luck

by virgoan

Tried out but it's not working fine! I think the problem is caused by MS Outlook where the sending button is not working and unable to send out the file!!! Had reinstalled Outlook but then the same thing occurred. Any other solution for this?

This discussion is closed to new replies.