Microsoft Office Forums


Reply
Thread Tools Display Modes

Creating Form Letters in Access

 
 
Jim Lonergan
Guest
Posts: n/a
 
      09-11-2003, 01:14 PM
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.
 
Reply With Quote
 
 
 
 
Albert D. Kallal
Guest
Posts: n/a
 
      09-11-2003, 03:30 PM
I have a nice word merge example. It has some nice working code that shows
you how to use word templates with ms-access.

I even have a working sample. Give it try....

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

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn


 
Reply With Quote
 
 
 
 
Mike Painter
Guest
Posts: n/a
 
      09-11-2003, 05:23 PM

"Jim Lonergan" <(E-Mail Removed)> wrote in message
news:072801c37866$a6534c20$(E-Mail Removed)...
> 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.


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.



 
Reply With Quote
 
Judy Rudek
Guest
Posts: n/a
 
      09-11-2003, 07:56 PM
"Jim Lonergan" <(E-Mail Removed)> wrote in message news:<072801c37866$a6534c20$(E-Mail Removed)>...
> 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.


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
 
Reply With Quote
 
Albert D. Kallal
Guest
Posts: n/a
 
      09-11-2003, 09:10 PM
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.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)


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn


 
Reply With Quote
 
 
 
Reply

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA - find japanese letters among english letters Edward PowerPoint Newsgroup 1 05-13-2009 08:24 PM
How to change small letters into capital letters? Blinda Access General 4 05-15-2006 05:49 PM
change lower case letters to uppercase letters tom Infopath Newsgroup 2 12-12-2005 06:36 PM
converting all letters in field to small letters? Mani Access Beginners 6 11-20-2005 04:03 PM
How do I change lower case letters to upper case letters in excel. Vinayaka B Access General 1 10-03-2004 10:03 AM


All times are GMT. The time now is 11:16 PM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.


Welcome!
Welcome to the Microsoft Office Forums
 


Latest Threads
Mail Merging Content With High Quality
oleander (Yesterday, 11:59 PM)

Aargh. What is this?
PeteJ (Yesterday, 12:10 PM)

Word 2013 Insert Symbol (Not Responding)
tpthrshr (Yesterday, 02:49 AM)

Can't save a large Word document
Josh (Yesterday, 01:03 AM)

Remote help?
newman200 (04-13-2014, 12:54 PM)