Blank Report as Attachment

M

Melynda E.

I have a created a phone message database for my staff. We use a form to
gather information from callers. Once all data is collected, we use a
command button (set to run a macro) to pull the data into a report format and
e-mail it as an attachment (snp format). All of this works well, but
occasionally, the e-mail recipient will recieve an attachment that is blank.
I'm stumped and can not figure how this could happen.

Macro:
STEP 1 OpenReport -
Report name: Print Message Auto Email
View: Report
Filter name: blank
Where Condition: ="[Ticket Number]=" & [Ticket Number] (Ticket Number is
unique identifier for this table)
Window Mode: Normal

STEP 2 SendObject -
Object Type: Report
Object Name: Print Message Auto Email
Output Format: Snapshot Format (*.snp)
all e-mail fields blank for user entry
Edit Message: Yes
Template file: blank

STEP 3 Close -
Object Type: Report
Object Name: Print Message Auto Email
Save: No

Step 4 Close -
Object Type: Form
Object Name: Call Ticket
Save: No

Any help will be greatly appreciated!
 
F

Fred

I noticed that nobody answered.

You're probably way past this, but sometimes users say that they have a
blank report when they are just looking at one blank page of a report.
Several scenerios can add a blank page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top