C
Curtis Stevens
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.
CURRENT SETUP:
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.
PROPOSED SOLUTION:
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.
PROBLEM:
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
macro?
ANY assistance you can provider, is greatly appreciated!!!!
Thank you,
Curtis Stevens
please tell me if this is the best approach and how to fix the one bug that
comes up with their method.
CURRENT SETUP:
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.
PROPOSED SOLUTION:
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.
PROBLEM:
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
macro?
ANY assistance you can provider, is greatly appreciated!!!!
Thank you,
Curtis Stevens