Printing_Angel_Tag_Notes

Document Sample
Printing_Angel_Tag_Notes Powered By Docstoc
					Printing Angel Tag Notes:

1. You need to download the program to your PC.
Click on Download Angel reporting software.

Download the file:
AngelwebRpt###.zip (If you have something to unzip it with on your computer)
AngelwebRpt###.mdb (if you do not have zip.unzip software)
(note ### above would be your site name)

Unzip somewhere onto your PC. Make sure MS Access 2000 or MS Access 2003 is
installed. Please don't use Access 2007 as the security updates embedded by Microsoft
will cause problems.

Next, download the Angel report from the website:

Download Angel Data(+/- 2 minutes)
Right-click and save the file.

NOTE: DO NOT PUT IT ON YOUR DESKTOP OR MY DOCUMENTS.
Many computers have a very long path to these locations. Since access is limited in how
big each field can be, this can cause a problem.
I suggest creating a new folder on the C: drive called C:\Angel and saving the
downloaded angels to this folder.

NEXT, we need to change the format of the file from an Excel Web document to an
Excel Workbook so that Access knows how to import the data.
This needs to be done once and after each download of a new angel data file.

Here is how.
You need to open the file with Excel. You can just double click on the file.
Typically the file is named something like this: EXP_angeldata_###-1092009.xls
 (Corps name and date included at the end of the file name).

Click on File :: SAVE AS

At the bottom of the save dialogue box, there are two selection boxes. One for the name
and one for the type of file.
In the lower Save as type box, change the type from Web Page (*html) to
Microsoft Office Excel Workbook (*xls)
Or
Excel 97-3003 Workbook
Now click on SAVE.
 It's ok to overwrite the same file name if you want.
Exit Excel.
Now run MS Access 2003 and open the unzipped reporting program.

It should be called: AngelwebRpt###.mdb

From the menu, click on Import Angel Spreadsheet.

Navigate to the folder where the updated spreadsheet is. For example: C:\Angel.

Select the latest Angel download and click on Import.

It should respond with a message: Done.

Now you can use the reports option to print.

You also have the ability to print reminder letters. This uses the HOH downloaded data
in the same way. Download, convert to XLS workbook, import. There is a setup page
that allows you to change what is printed on the letter. It is designed to print to window
envelopes.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:9/12/2012
language:English
pages:2