A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I print form data in a standard letter



 
 
Thread Tools Display Modes
  #1  
Old March 29th, 2010, 05:47 PM posted to microsoft.public.access.forms
Roger[_22_]
external usenet poster
 
Posts: 9
Default 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  
Old March 29th, 2010, 09:25 PM posted to microsoft.public.access.forms
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default 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  
Old March 30th, 2010, 02:39 PM posted to microsoft.public.access.forms
Roger[_22_]
external usenet poster
 
Posts: 9
Default 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  
Old March 30th, 2010, 04:48 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old March 30th, 2010, 10:05 PM posted to microsoft.public.access.forms
Roger[_22_]
external usenet poster
 
Posts: 9
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.