Emailing Multiple reports from Access 97

[tatty]

I am here again!!!

I asked a similar question a couple of weeks ago, and someone kindly answered with some code, but being really dim where it comes to coding etc, I have not been able to make the code work......

I have a number of clients who, each month have between 9-10 separate reports. I need to be able to just click a button on the switchboard and it will email all 9-10 reports to that particular client.

Now I have tried creating a main report and entering the other reports as sub reports but that does not take the page headers or footers into the report, so I scraped that idea..... The reports I have for each client can NOT be changed in anyway, shape or form (boss will not let me!!).

Anyway, coding will probably help if someone was kind enough to write it down in simple blonde persons terms!!

Also, with the reports I need to email, it would be good to use Snapshot viewer (clients have that installed already).

Please help as this is driving me to drink!!!!

Any help would be greatly appreciated, either with coding or creating a form or help with creating this blinking sub reports etc!!!

Thanks in advance

Christy

X-)

 

[sloppyjoe]

I have done this using Access 95 and 2000 with Groupwise. I would think it should work for all systems.

a = Forms!Met_Main_Reports!mine
d = Format((a), "dd&quot
e = Format((a), "mm&quot
j = Format((a), "yy&quot
b = "R:\tech\Acc\" & j & e & d & "Mn" & ".rtf" 'Met_DayMain
c = "R:\tech\Acc\" & j & e & d & "Sk" & ".rtf" 'Screens

stDocName = "Met_Reagents_dtd"
DoCmd.OutputTo acReport, stDocName, acFormatRTF, b

stDocName = "Met_DayMain"
DoCmd.OutputTo acReport, stDocName, acFormatRTF, c

This coding is behind the "On Click" and will output the 2 reports to a .rtf file. The f2 and b are just a directory and date for a name of the file. I use a date for the file name as we output the files daily. They will be put in the directory on the "R" drive.
If this does not help let me know. I have also started Groupwise from Access and attached the files automaticcally.
breddick@agrium.com