Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Merging to Word

Discussion in 'Information Technology' started by silenceseeker2003@yahoo.com, Jul 28, 2006.

Tags:
  1. silenceseeker2003@yahoo.com

    silenceseeker2003@yahoo.com
    Expand Collapse
    Guest

    In the following tutorial:

    http://www.teachers.ash.org.au/jfuller/access/queries/merge1.htm

    I learned how to merge an Access table to a Word document.

    However, what I noticed was that one can merge only a single table and
    only one item per page.

    I am actually looking for a way to merge *two* tables (connected by a
    third table that simply provides relationship between records in the
    first table to records in the second table) - and I would like to have
    multiple records per page, not one per page as the above tutorial
    shows.

    Is there a way to accomplish that?

    Ideally I would like to be able to "merge" the *results of an SQL
    query* into a Word document (multiple records/sets per page). Is this
    possible with MS Access 2002?

    Is there a good online source where I can learn how to use MS Access
    (2002) in a way less trivial and rigid than the various wizards that
    come with Access?

    Thanks!
    Sam
     
  2. Loading...

    Similar Threads Forum Date
    Merging in the Word Of Sabad Sikh Sikhi Sikhism Jan 26, 2008
    India Punjab emerging as major drug producing centre Breaking News Mar 13, 2013
    Under-19 emerging sikh cricketers Sports & Fitness Jan 22, 2010
    Sikh News Punjab emerging as new international education hub (New Kerala) Breaking News Sep 17, 2007
    Sikh News Punjab emerging as new international education hub (ANI via Yahoo! India News) Breaking News Sep 17, 2007

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    You should be able to create a query that joins the tables however you need
    to, and use that query rather than a table.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    <silenceseeker2003@yahoo.com> wrote in message
    news:1147373214.406251.97650@j73g2000cwa.googlegroups.com...
    > In the following tutorial:
    >
    > http://www.teachers.ash.org.au/jfuller/access/queries/merge1.htm
    >
    > I learned how to merge an Access table to a Word document.
    >
    > However, what I noticed was that one can merge only a single table and
    > only one item per page.
    >
    > I am actually looking for a way to merge *two* tables (connected by a
    > third table that simply provides relationship between records in the
    > first table to records in the second table) - and I would like to have
    > multiple records per page, not one per page as the above tutorial
    > shows.
    >
    > Is there a way to accomplish that?
    >
    > Ideally I would like to be able to "merge" the *results of an SQL
    > query* into a Word document (multiple records/sets per page). Is this
    > possible with MS Access 2002?
    >
    > Is there a good online source where I can learn how to use MS Access
    > (2002) in a way less trivial and rigid than the various wizards that
    > come with Access?
    >
    > Thanks!
    > Sam
    >
     
  4. silenceseeker2003@yahoo.com

    silenceseeker2003@yahoo.com
    Expand Collapse
    Guest

    Douglas J Steele wrote:
    > You should be able to create a query that joins the tables however you need
    > to, and use that query rather than a table.


    Doug, thanks for your answer. Could you please point me to some online
    source that shows how to do that?

    Thanks,
    Sam
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Using a query should be no different than using a table.

    Or are you asking how to create your query?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    <silenceseeker2003@yahoo.com> wrote in message
    news:1147379694.072560.326060@j73g2000cwa.googlegroups.com...
    > Douglas J Steele wrote:
    >> You should be able to create a query that joins the tables however you
    >> need
    >> to, and use that query rather than a table.

    >
    > Doug, thanks for your answer. Could you please point me to some online
    > source that shows how to do that?
    >
    > Thanks,
    > Sam
    >
     
  6. silenceseeker2003@yahoo.com

    silenceseeker2003@yahoo.com
    Expand Collapse
    Guest

    Douglas J. Steele wrote:
    > Using a query should be no different than using a table.
    >
    > Or are you asking how to create your query?
    >


    No, I know how to create a query. My problem is with the strict tabular
    format provided by the "Publish to MS Word" function. Is this the only
    format supported? If not, how do I change it?

    I would like to be able to create multiple entries (query results) per
    page in a format that I carefully craft using MS-Word. I was trying to
    find a good tutorial on how to this, but so far I have failed. The
    Wizards in Access are very friendly but very rigid (limited).

    Can you recommend a good tutorial on how design a word document in
    which fields in the document correlate correctly with fields the
    results of an Access query?

    Thanks,
    Sam
     
  7. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    <silenceseeker2003@yahoo.com> wrote in message
    news:1147442995.754956.68590@i40g2000cwc.googlegroups.com...
    > Douglas J. Steele wrote:
    >> Using a query should be no different than using a table.
    >>
    >> Or are you asking how to create your query?
    >>

    >
    > No, I know how to create a query. My problem is with the strict tabular
    > format provided by the "Publish to MS Word" function. Is this the only
    > format supported? If not, how do I change it?
    >
    > I would like to be able to create multiple entries (query results) per
    > page in a format that I carefully craft using MS-Word. I was trying to
    > find a good tutorial on how to this, but so far I have failed. The
    > Wizards in Access are very friendly but very rigid (limited).
    >
    > Can you recommend a good tutorial on how design a word document in
    > which fields in the document correlate correctly with fields the
    > results of an Access query?


    I was suggesting that you have one query which returns all of the data you
    require, not that you have multiple queries. I don't believe it's possible
    to use anything other than a single data source for a merge in Word.

    Realistically, this is a Word issue, not an Access issue. You'll find lots
    of good information about mail merges in Word at the Word MVP website,
    specifically at http://word.mvps.org/FAQs/MailMerge/index.htm

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)
     
  8. silenceseeker2003@yahoo.com

    silenceseeker2003@yahoo.com
    Expand Collapse
    Guest

    Douglas J. Steele wrote:
    > I was suggesting that you have one query which returns all of the data you
    > require, not that you have multiple queries. I don't believe it's possible
    > to use anything other than a single data source for a merge in Word.


    Oops... I am sorry, I didn't explain myself well enough. I meant a
    *single* query returning multiple entries. That is exactly how the
    "Publish to MS Word" works and that is working excellent - if all I am
    interested in is a *table* with all the results.

    However, I am interested in a different format, something that I design
    myself (similar to an address book or a collection of labels).

    > Realistically, this is a Word issue, not an Access issue. You'll find lots
    > of good information about mail merges in Word at the Word MVP website,
    > specifically at http://word.mvps.org/FAQs/MailMerge/index.htm


    I believe you are right. Thanks for the link. I will check it out.

    Thanks,
    Sam
     
  9. silenceseeker2003@yahoo.com

    silenceseeker2003@yahoo.com
    Expand Collapse
    Guest

    silenceseeker2003@yahoo.com wrote:
    > > Realistically, this is a Word issue, not an Access issue. You'll find lots
    > > of good information about mail merges in Word at the Word MVP website,
    > > specifically at http://word.mvps.org/FAQs/MailMerge/index.htm

    >
    > I believe you are right. Thanks for the link. I will check it out.
    >


    OK. I just tried what was described in the following section, entitled
    "Create an address directory":
    http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#AdrBook

    And I am still struggling with how to generate *multiple* records in a
    single page. So far, following the instructions exactly as described,
    still yields only one record per page. What am I doing wrong?
     
  10. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    I suggest asking in microsoft.public.word.mailmerge.fields

    Cindy Meister, a Word MVP, is one of the experts on this topic. You could
    also check her website http://homepage.hispeed.ch/cindymeister/

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    <silenceseeker2003@yahoo.com> wrote in message
    news:1147458535.610084.261550@i39g2000cwa.googlegroups.com...
    > silenceseeker2003@yahoo.com wrote:
    >> > Realistically, this is a Word issue, not an Access issue. You'll find
    >> > lots
    >> > of good information about mail merges in Word at the Word MVP website,
    >> > specifically at http://word.mvps.org/FAQs/MailMerge/index.htm

    >>
    >> I believe you are right. Thanks for the link. I will check it out.
    >>

    >
    > OK. I just tried what was described in the following section, entitled
    > "Create an address directory":
    > http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#AdrBook
    >
    > And I am still struggling with how to generate *multiple* records in a
    > single page. So far, following the instructions exactly as described,
    > still yields only one record per page. What am I doing wrong?
    >
     

Share This Page