Snapshot Question

[Guest]

Hey Everyone,

I have a question about snapshots. I have a report that I want to run
every month from my database and email out to our customers. Within this
report is data pertaining to mulitple customers. I can already make so that
each customer gets their own pages, so that no 2 customers info is on the
same page. What I need to do is split the snapshot into muliple pieces so
that I can email customers only thier own info. Im not sure if there is a way
that I can. I am pretty good with VBA now so I just need a little direction.
Is there a way to split up a snapshot by category. And maybe even setup a
savefile naming scheme so that when I split the file I dont have to type in a
save as name 50 times. As always thanks very very much for all your help.
Have a great day!


James O'Donnell

 

[Guest]

Hi James,

What I need to do is split the snapshot into muliple pieces so that I
can email customers only thier own info.

Not possible. You need to restrict the contents of each report, so that it
includes data for only that customer. Here is an example of how to do this,
using a command button on a form, where the customer's primary key and e-mail
address are included in the form's recordset:

How to print only one page of a multipage report
http://www.access.qbuilt.com/html/reports.html#PrintOnePgOfRpt

And maybe even setup a savefile naming scheme so that when I split
the file I dont have to type in a save as name 50 times.

You should not need to save the file separately. As long as your database
contains the e-mail addresses of your customers, you can use VBA code
(Docmd.SendObject) to create the snapshot report and attach it to an outgoing
e-mail message. The message can have the To:, CC:, BCC:, Subject and Body
automatically filled out. All you would need to do is press the send button
in either Outlook or Outlook Express to actually send the message. Here is an
example:

DoCmd.SendObject acReport, "ReportName", _
OutputFormat:=acFormatSNP, _
To:=strTo, CC:=strCC, BCC:=strBCC, _
Subject:=strSubject, EditMessage:=True

where "ReportName" is the name of your report, and strTo, strCC, strBCC, and
strSubject are strings that you supply. Use the Nz function to first convert
any nulls to zero length strings. For example:

Dim strCC as String
strCC = Nz(Me.txtCC,"")

where txtCC is the name of a textbox that includes the CC e-mail address.

If you have *lots* of individual messages to send out, each with their own
snapshot report attached, then having to click on the send button for each
message can get a bit tedious, to say the least. This is the price that we
have to pay for security, to thwart virus writers who have been able to
programmatically access an address book in the past. There are steps you can
take, such as using the Redemption Library (see tip # 113 here:
http://www.helenfeddema.com/access.htm) or using an alternate SMTP engine.
Examples include:

Fairlogic:
http://www.fairlogic.com/worldcast/

FMS:
http://www.fmsinc.com/products/Emailer/index.asp


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hey Everyone,

I have a question about snapshots. I have a report that I want to run
every month from my database and email out to our customers. Within this
report is data pertaining to mulitple customers. I can already make so that
each customer gets their own pages, so that no 2 customers info is on the
same page. What I need to do is split the snapshot into muliple pieces so
that I can email customers only thier own info. Im not sure if there is a way
that I can. I am pretty good with VBA now so I just need a little direction.
Is there a way to split up a snapshot by category. And maybe even setup a
savefile naming scheme so that when I split the file I dont have to type in a
save as name 50 times. As always thanks very very much for all your help.
Have a great day!


James O'Donnell

 

[Guest]

Thank you so much. You have made my day! Also... how do I flag somthing as
resolved? I afew afew posts that I need to do this to. Thanks!

 

[Guest]

Hi James,

You're welcome. I'm glad I could be of help.

Also... how do I flag something as resolved?

Since you are using the Microsoft web portal, I think you should see a
button in the lower right corner of your screen, where you can click on Yes
to a prompt. You won't see such a choice if you read this message with any
other newsreader, such as Outlook or Outlook Express.

Tom
_________________________________________

:

Thank you so much. You have made my day! Also... how do I flag somthing as
resolved? I afew afew posts that I need to do this to. Thanks!