If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I print form data in a standard letter
I have a Access2002sp3 database. Data is input via a form into a table and
sometimes (at the time of input) we need to print the data out in a standard letter format (basically like a mail merge with a standard letter template and data coming from the single record in the table). So far we've been doing it by exporting the whole table to Excel and then doing a mail merge selecting only the records that we want printed. Very tedious !!! Is there some way I can put the standard letter into an Access report and then just click on a control button on the input form to print the particular record's data in the standard letter ? thanks Roger |
#2
|
|||
|
|||
How can I print form data in a standard letter
Roger wrote:
I have a Access2002sp3 database. Data is input via a form into a table and sometimes (at the time of input) we need to print the data out in a standard letter format (basically like a mail merge with a standard letter template and data coming from the single record in the table). So far we've been doing it by exporting the whole table to Excel and then doing a mail merge selecting only the records that we want printed. Very tedious !!! Is there some way I can put the standard letter into an Access report and then just click on a control button on the input form to print the particular record's data in the standard letter ? thanks Roger I would use Albert Kallal's "Super Easy Word Merge" http://www.members.shaw.ca/AlbertKal.../msaccess.html -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
How can I print form data in a standard letter
I have looked at Kallal's Super Easy Word Merge and it still seems to me
that there must be an easier way of doing it. If I basically copied my standard letter into an Access Report using the input form fields as the standard letter fields that vary with each record, can't I simply go via a control button to the "report" and fill it in with the last record data, then print it ? ... Roger "PieterLinden via AccessMonster.com" u49887@uwe wrote in message news:a5bf831bcd8fb@uwe... Roger wrote: I have a Access2002sp3 database. Data is input via a form into a table and sometimes (at the time of input) we need to print the data out in a standard letter format (basically like a mail merge with a standard letter template and data coming from the single record in the table). So far we've been doing it by exporting the whole table to Excel and then doing a mail merge selecting only the records that we want printed. Very tedious !!! Is there some way I can put the standard letter into an Access report and then just click on a control button on the input form to print the particular record's data in the standard letter ? thanks Roger I would use Albert Kallal's "Super Easy Word Merge" http://www.members.shaw.ca/AlbertKal.../msaccess.html -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
How can I print form data in a standard letter
On Tue, 30 Mar 2010 15:39:44 +0200, "Roger" wrote:
I have looked at Kallal's Super Easy Word Merge and it still seems to me that there must be an easier way of doing it. If I basically copied my standard letter into an Access Report using the input form fields as the standard letter fields that vary with each record, can't I simply go via a control button to the "report" and fill it in with the last record data, then print it ? ... Roger That will work, but it's either limited or difficult. It works fine if the table field data can be put in a fixed textbox on the report; the report need not have a box around it, and its CanGrow and CanShrink properties will let it expand or contract vertically, but if you're trying to fit a variable length name into a paragraph of running text, it's a bit of work. That is, you can get a paragraph like Thank you, Pieter , for your help. by using "Thank you, " in one Label control and ", for your help." in another, with a textbox bound to VolunteerName in between; but to get a more natural looking output, you must construct a concatenation of constant and variable text in a calculated field in the query. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
How can I print form data in a standard letter
There's no running text involved, so I will try that. Thanks for your help
... Roger "John W. Vinson" wrote in message ... On Tue, 30 Mar 2010 15:39:44 +0200, "Roger" wrote: I have looked at Kallal's Super Easy Word Merge and it still seems to me that there must be an easier way of doing it. If I basically copied my standard letter into an Access Report using the input form fields as the standard letter fields that vary with each record, can't I simply go via a control button to the "report" and fill it in with the last record data, then print it ? ... Roger That will work, but it's either limited or difficult. It works fine if the table field data can be put in a fixed textbox on the report; the report need not have a box around it, and its CanGrow and CanShrink properties will let it expand or contract vertically, but if you're trying to fit a variable length name into a paragraph of running text, it's a bit of work. That is, you can get a paragraph like Thank you, Pieter , for your help. by using "Thank you, " in one Label control and ", for your help." in another, with a textbox bound to VolunteerName in between; but to get a more natural looking output, you must construct a concatenation of constant and variable text in a calculated field in the query. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|