473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How Can I Fax An Existing PDF File Via MS Fax From MS Access Using VBA?

NEWBIE QUESTION

How Can I Fax An Existing PDF File Via MS Fax From MS Access Using VBA?

Using MS Access As A User Interface to enable users to search for various electronic records stored as PDF files.

Once a desired record is located, the user can email or fax one or more corresponding PDF files to contacts stored in the database.

The sending of existing PDF files as email attachments via MS Outlook works great.

I am also able to send existing PDF files as faxes via MS Outlook to MS Fax, however I have several problems that prompted this post.

First, MS Outlook creates a fax cover page consisting of the email subject and email body even when these fields are left blank. I do not want to sent a cover page but can not find away to eliminate.

Second, MS Outlook and/or MS Fax uses Adobe Reader (version 9.3) to render the PDF files into the outbound TIF fax format. In so doing, Adobe Reader is opened and given the focus to process a temporary file. Once the temporary file is processed, Adobe Reader remains open. I would like to elimante this nuisance or at least have Adobe Reader run minimized or hidden in the background without receiving the focus. Please understand that we are faxing up to 100 documents at one time which makes this "nuisance" unbearable. The user can not continue to work because Adobe Reader "pops up" once per fax (every 30-40 seconds or so).

Third, the faxes clog up the MS Outlook sent folder and must be deleted manually.

Please advise your recommendations to solve these issues. Again, I would prefer to bypass MS Outlook for faxes and send direct via MS Fax. Eliminating the cover page is a must and allowing the user to continue their work while the faxes are being rendered is also a must.

Please advise what additional information may be required to respond to my inquiry.

Thank you MS Access Experts!
Jul 1 '10 #1
2 3407
FishVal
2,653 Expert 2GB
@Blue Stone Post
  • I'm not sure what you mean by "fax cover page", but guess it is all about MS Fax interaction with MS Outlook which I think could not be controlled with Access application.
  • To close Acrobat windows I would propose the following:
    • Enumerate all top level windows via WinAPI EnumWindows() function.
    • Check each hWnd returned by EnumWinwdows() to point to an Acrobat window using one of the following methods:
      • Check the window title with GetWindowText() WinAPI function for a corresponding substring.
      • Get a process - owner of the window and check path to an executable which has created the process. This method is more robust then the previous one but at the same time much more sophisticated since its implementation depends on Windows version.
    • Send WM_CLOSE message to all positively identified windows.
    If you consider this approach to be feasible, then I could elaborate on writing some sample code.
  • MS Outlook "Sent Items" folder could be cleaned via application automation.

Regards,

Fish
Jul 2 '10 #2
maxamis4
295 Expert 100+
@Blue Stone Post
Before I can give you the answer to this question I will need to ask the skill level you have in programming. To do this you will need to have knowledge in the following areas:

1. Outlook reference library
2. MsOffice reference library (version of ms office matters here)
3. hardware library for drivers and any software it may have.
Jul 3 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Dan Kelley | last post by:
We have a multithreaded app that responds to events, and writes these events to a text file. This text file is used by an external system for further processing. We want to be able to write...
1
by: Chance Lerro | last post by:
Here's another way to PREVENT the install program for run-time Access from overwriting existing file associations: 1. Edit the Runtime MSI file with Orca, InstallShield, etc.. 2. Go to the...
2
by: Harry | last post by:
Hi, I've got an ASP application running and want to have it write to a text file. I am running VS.NET on WinXP. I was able to set the file permissions to allow ASPNET access under Win2000 but...
4
by: Josh Behl | last post by:
When I try to programmatically open an existing Excel document using a custom windows form, it works perfectly. I instanciate a new instance of the Excel.ApplicationClass and then set the Visible...
0
by: Andrew Corley, MCSD, MCDBA | last post by:
Good day, I have researched on MSDN and the newsgroups and I have not yet found an answer. Hopefully, one of you will have solved this type of issue already. I am writing a VB.NET 2003 console...
7
by: Hercule POIROT | last post by:
Hello ! Could you please write for me the simplest portable c program that handles 64 bit file access. I want to use only high-level functions (of section 3 : libraries) from glibc/libc6. ...
6
by: shalakasan | last post by:
Hi, I want to open a binary file and write to a specific location in File. Here is how my code looks like: int main() { long lbuf = 0; int lreadBytes = 0;
1
by: Jovinee | last post by:
I am a very newbie and need help with this question. What other types of file access exist besides sequential file access?
0
by: astersathya | last post by:
Date Format in MS Access using a query Hi I want to alter the existing column's format using the alter query. The issue I am facing is I want to set the default date format of an existing...
0
by: Albert-jan Roskam | last post by:
Hi John, Thanks! Using a higher xlrd version did the trick! Regarding your other remarks: -yep, input files with multiple sheets don't work yet. I kinda repressed that ;-) Spss outputs only...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.