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!
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!