Creating Form Letters in Access

  • Thread starter Thread starter Jim Lonergan
  • Start date Start date
J

Jim Lonergan

Hi Folks, ..

I am at my wits end, ... what do I use in Microsoft Access
to create a form letter. I have created a resume database
and I want to be able to send letters responding to all
resumes recieved.

Thanks for any and all help.
 
Jim Lonergan said:
Hi Folks, ..

I am at my wits end, ... what do I use in Microsoft Access
to create a form letter. I have created a resume database
and I want to be able to send letters responding to all
resumes recieved.

Thanks for any and all help.
Click to expand...

if it is simple then I just create a report with the information I want on
it and then use text boxes for the rest of the written material.
Since I'm lazy I usually start with a label because it does the
concatenation needed in most cases. John Smith becomes John
Smith etc
You are limited to one type style per text box.
If you need to include a field in a line of text you have to build the whole
thing.
"I worked from " & trim(StartDate) & " to " & trim([EndDate]) & " at " &
trim([StoreName]) & " and left when they caught me spitting in the soup"
Oops, but you get the idea.

That's how you would do it in Access without buying a third party control.
Word will probably be better for a resume.
 
Jim Lonergan said:
Hi Folks, ..

I am at my wits end, ... what do I use in Microsoft Access
to create a form letter. I have created a resume database
and I want to be able to send letters responding to all
resumes recieved.

Thanks for any and all help.
Click to expand...

If it's fairly simple, you could also use an Access Report to do this.
I have done this in the past. That way, too, you could easily use
the same report to run letters for all resumes received in a given
timeframe, using a parameter query.

I'd be happy to provide more detailed info on this if you need help.

-- Judy
 
You can always build the query in code. I usually present my users with some
nice prompt forms. If you look at the following screen shots, you will see
that some of the forms has the word merge button.

Take look at the following screen shots:

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html


So, build a nice un-bound form. You can place some text boxes, or even a
combo box for the city onto this form. (you can even use the wizard to build
the city combo box).

You could also make a combo box for what type of position also.

Now, assuming that both city and position are text fields. Then the button
code could be:

dim strSql as string

If isnull(me!txtCity) = false
strSql = "City = '" & me!txtCity & "'"
endif

if isnull(me!txtPostion) = false then
if strSql <> "" then
strSql = strSql & " and "
endif

strSql = StrSql & "Postion = '" & me!txtPostion & "'"
endif

strSql = "select * from tblCustmors where " & strSql

MergeAllWord (strSql)
 
Back
Top