Platform:
Windows XP
Software:
MS Access 2003
CorelDraw 12
**Brief Description**
VBA Project (GMS) for batch automated creation of CDR-Files using input from an MS Access database table and a template.
**Description**
Corel Draw has the ability to run automated batch processes using data from databases and/or flat files. These batch processes can be created and maintained by using the integrated VBA editor.
The idea is to create CorelDraw files based on a template by connecting data from a MS Access table in order to allow a graphics designer complete the layout and design without having to manually input base data such as addresses and phone numbers etc.
**Requirements**
1. An MS Access Database with a table containing the base data is provided.
2. A Template is provided
Using <Visual Basic> <Play> in the CorelDraw interface menus the following can be selected:
1. The template file
2. The MS Access Database
3. The Table in the MS Access Database
4. The Folder for the output of Corel Draw Files
The following process should take place:
1. All the records present in the Table are processed.
2. For each record a new CDR-File using the template.
3. Each of the remaining fields (also Null) is placed sequentially inside the Corel document, from the top down.
4. The text of each field is to be placed as artistic text (as opposed to paragraph text) and resized to fit the document (field content may be too large to fit ??" horizontally in particular).
5. The resulting CorelDraw File is saved in the selected destination directory (folder) having the filename from one of the fields of the record.
These files are then presented to graphic designers for further editing.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows XP Professional, Corel Graphics Suite 12 (both German versions)