Re: Sending Report to a Fax Server

Thanks!

I think this will work; however, I would like to export the files to a
directory on the server rather than sending them in an e-mail. The fax
server will check the folder and automatically fax anything in it. How
would I modify your code to do that?

Thanks.


"Jeff C" <JeffC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:62484C9E-8F23-491D-92FE-DE784E3DFA69@xxxxxxxxxxxxxxxx
Sorry about the delay, work crisis yesterday

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset

rs.Open "NameOfYourTable", CurrentProject.Connection, adOpenStatic

Do Until rs.EOF

[Forms]![yourform].[txtbox].Value = rs![Name]
[Forms]![yourform].[txtbox].Value = rs![E_Mail]

On Error Resume Next
DoCmd.SendObject acSendReport, "rpt_yourreport", acFormatSNP,
[Forms]![frm_EMail].[txtEmail], , , "subject", , True

On Error Resume Next
rs.MoveNext

The above will loop through the records placing the customer references
correctly and generate an individual email with your report attached.

I do not know how to move from this place to a fax, but maybe another does
and will offer a solution.

Hope this helps you in some way.
--
Jeff C
Live Well .. Be Happy In All You Do


"Suthee" wrote:

Thanks for the reply. I've been able to do that. What to do next?


"Jeff C" <JeffC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5CE4297F-F34A-4742-9DC1-E318208B05BE@xxxxxxxxxxxxxxxx
Begin by building a form with a combo box that allows you to select the
customer you want a report for, in the query you use as the record
source
for
your customer reports, place that combo box as the criteria for the
customer.
Finally place a command button on your form that opens the report for
the
customer you choose with the combo box. Get that much working first.
--
Jeff C
Live Well .. Be Happy In All You Do


"Suthee" wrote:

Hi everyone. A quick question if I may.

My company finally purchased RightFax. I built a database a couple of
years
ago that imports a CSV file containing a list of several hundred
different
clients. Each of these clients is already setup in the database they
are
being imported into.

Specifically, each client is in a table that has their NAME, CUSTID,
FAX,
and LETTER. The letter is an OLE object in the form of a BMP or Word
Document. The letter is unique to each client, and sometimes the
client
may
have up to 3 letters. That being said, the client could have several
different records for each unique letter.

A query matches the client from the imported CSV file to their
respective
record(s) in the database. This is done so I can match the fax and
letter(s)
to each client.

Finally, a report is built from the aforementioned query. This report
is
a
text document for each customer that says a bunch of junk on the first
page
(with the fax number) and the preceding pages would be each unique
letter--usually one, but it could be up to 3. So basically it is one
GIANT
report that is then printed an manually faxed--yes we literally print
and
fax this puppy by hand!

So finally my question: I need to have each individual client report
export
to an Access SNP (snapshot) file from my query with the FAX number as
the
file name. Then I can feed it to the fax server.

I have no idea how to tell Access how to (1)loop through each record,
(2)
create a unique report for each record, (3) export it to snapshot, and
(4)
name it the fax number.

If anyone could help me with this, I would be your biggest fan as it
would
literally save us HOURS each day.

Thanks in advance to anyone that could share their expertise with me.








.

Quantcast