Results 1 to 3 of 3
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    text table

    All, using 2010. Inherited a database that has a table to store text for a form
    letter in a report. For example:

    Code:
    txt1    txt2    txt3    txt4    txt5
    I am please to inform you    that you have been     selected to attend    the conference in Atlanta    Please assign you work
    The
    report is designed as a letter using =txt1… and so on to create a form letter.


    Is there another way to do this without storing the data in these fields in a
    table? I thought able mail merge but don’t know how to set this up or is it even
    worth it over doing this the current way. Thanks in advance

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Normally, the report (letter) has data in the table (or query). This is how it works. It's an internal mail merge.
    Did you want something different?

  3. #3
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    Just thought it was odd. I had never seen anything like this before with a text table as the source.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 05-03-2014, 11:50 AM
  2. Pull text from another table
    By nigelbloomy in forum Forms
    Replies: 4
    Last Post: 07-24-2012, 09:48 AM
  3. Add text from different table
    By hithere in forum Forms
    Replies: 5
    Last Post: 09-22-2011, 04:12 PM
  4. Replies: 0
    Last Post: 03-01-2010, 07:42 PM
  5. text box in table
    By texasguy4 in forum Access
    Replies: 0
    Last Post: 08-15-2008, 10:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums