Hi Reidar,
Thank you for post it in our community!
From your description, I understand that you'd like to send a report (whose data was
retrieved from a field in a table) as a fax with the recipients fax number. However, I'm not
sure whether you'd like to perform this in VBA or just in Access GUI.
If you'd like to fax the report by the method of VBA programming, I believe you can use a
macro with its Sendobject Action, and a VBA procedure to fax a report from MS Access.
Before that, please make sure that the MS Outlook, Fax/Fax Modem are installed and
functioning with no problem.
Please follow the detailed steps described in the KB299016 to create such a macro and
then use the VBA procedure (DAO method) to send your report as a fax:
299016 HOW TO: Fax from Microsoft Access by Using the SendObject Command in
http://support.microsoft.com/?id=299016
On the other hand, if you prefer sending the report in the Access GUI, you can only fax the
report as an Attachment. In this scenario, try to use the following method:
1. Select (Click on) the report you'd like to send as a fax
2. From the File menu, navigate to Send TO and select Mail Recipient(as Attachment)
3. In the Outlook dialog box, enter the fax number and the mail subject.
4. Send the report as a fax.
For detailed steps, please see the following KB170022:
170022 ACC97: Can't Fax E-mail Message Containing an Attached Snapshot
http://support.microsoft.com/?id=170022
If you fax the report as an Attached Snapshot, please also make sure that you have
downloaded and apply the Microsoft Snapshot Viewer:
175274 Microsoft Snapshot Viewer Available in Download Center
http://support.microsoft.com/?id=175274
Reidar, please apply my suggestions above and let me know if this helps resolve your
problem. If there is anything more I can do to assist you, please feel free to post it in the
group
Best regards,
Billy Yao
Microsoft Online Support
