Creating Form Letters in Access

Discussion in 'Access General' started by Jim Lonergan, Sep 11, 2003.

  1. Jim Lonergan

    Jim Lonergan Guest

    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, Sep 11, 2003
    #1
    1. Advertising

  2. Albert D. Kallal, Sep 11, 2003
    #2
    1. Advertising

  3. Jim Lonergan

    Mike Painter Guest

    "Jim Lonergan" <> wrote in message
    news:072801c37866$a6534c20$...
    > 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.
     
    Mike Painter, Sep 11, 2003
    #3
  4. Jim Lonergan

    Judy Rudek Guest

    "Jim Lonergan" <> wrote in message news:<072801c37866$a6534c20$>...
    > 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
     
    Judy Rudek, Sep 11, 2003
    #4
  5. 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)


    --
    Albert D. Kallal (MVP)
    Edmonton, Alberta Canada

    http://www.attcanada.net/~kallal.msn
     
    Albert D. Kallal, Sep 11, 2003
    #5
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tom

    change lower case letters to uppercase letters

    tom, Dec 9, 2005, in forum: Infopath Newsgroup
    Replies:
    2
    Views:
    645
  2. Vinayaka B
    Replies:
    1
    Views:
    118
    Tom Wickerath
    Oct 3, 2004
  3. Blinda
    Replies:
    4
    Views:
    259
    Blinda
    May 15, 2006
  4. Edward

    VBA - find japanese letters among english letters

    Edward, May 13, 2009, in forum: PowerPoint Newsgroup
    Replies:
    1
    Views:
    140
    Shyam Pillai
    May 13, 2009
  5. Mani
    Replies:
    6
    Views:
    63
    Douglas J. Steele
    Nov 20, 2005
Loading...

Share This Page