Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Automating My Application - Overall Design Problem & Need Help

Discussion in 'Information Technology' started by Curtis Stevens, Jul 28, 2006.

  1. Curtis Stevens

    Curtis Stevens
    Expand Collapse

    I'll explain how I have it setup now and what I was told I should do, can you
    please tell me if this is the best approach and how to fix the one bug that
    comes up with their method.


    I have an application customers fill out (5 pages for example). I have an
    online app that some people fill out, it comes to me tabbed delimited by
    email. I copy the data and paste it into a particular table. I open up my
    word doc, use the mail wizard feature and then print that word doc into a
    PDF, which has all their info input into the app now. I then email the PDF
    to the customer.


    Take the word file I created, drag the file into a report, which creates an
    image basically, use the field commands for all the boxes, etc. The fields
    will all reference to the table fields. Then she gave me the coding so when
    I have the customer's record open, I push a button in my form and it takes
    that current record and prints the report, which has been setup to default to
    a PDF printer I setup & configured just for this. So when the report prints,
    it turns into a PDF. The PDF printer has been setup (the port section) to
    print to a designated folder using *.pdf, etc. It then creates an email
    using their email address & attaches the newly created PDF file to it. It
    then also sends the email or can have it save it in my drafts folder. So one
    click of a button & it is all done for me.


    Reports can not be more than 22" long, so my 5 pages for example will not
    fit. I do not know what to do. I read that maybe I could create a separate
    report for each page, then use a macro to combine them all? If so, which

    ANY assistance you can provider, is greatly appreciated!!!!

    Thank you,

    Curtis Stevens
  2. Loading...

    Similar Threads Forum Date
    Haryana Invites Applications from Minority Students for Scholarship Community Out-Reach Aug 12, 2010
    UK UK lifts temporary suspension on visa applications in N India Breaking News Jul 25, 2010
    Leisure Easter Egg - Bota Singh's Job Application Business, Lifestyle & Leisure Apr 2, 2010
    Legal NRIs will soon be able to file RTI applications online Breaking News Feb 16, 2010
    SALDEF Accepting Applications for 2009 Summer Internship Program Sikh Youth Jan 31, 2009

Share This Page