Mail Merge with large data base

#1 (**permalink**) 19-Nov-2005, 21:59 PM

Hi, I use mail merge to get info stored on my data base onto a word doc so i
can add stuff unique to that record, however i keep all of the years records
on one data base and that has now grown to over 800 records and each one has
about 12 fields that it merges. So each time I mail merge it now takes about
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7721-mail-merge-with-large-data-base.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7721
20 min to get my word report. When i use mail merge i just hit the button on
the tool bar and dont use any marcos cause i dont really know how. my
question is, is there an easy to make this go quicker? can i just merge the
last record that i inputed? I know if i publish it in word as a rich text doc
i can merge that qucikly but i would like to not have to do that step. thanks!

#2 (**permalink**) 19-Nov-2005, 21:59 PM

what version of word are you using

"kyle" wrote:

> Hi, I use mail merge to get info stored on my data base onto a word doc so i
> can add stuff unique to that record, however i keep all of the years records
> on one data base and that has now grown to over 800 records and each one has
> about 12 fields that it merges. So each time I mail merge it now takes about
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7721
> 20 min to get my word report. When i use mail merge i just hit the button on
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7721
> the tool bar and dont use any marcos cause i dont really know how. my
> question is, is there an easy to make this go quicker? can i just merge the
> last record that i inputed? I know if i publish it in word as a rich text doc
> i can merge that qucikly but i would like to not have to do that step. thanks!

#3 (**permalink**) 19-Nov-2005, 22:00 PM

both word and access are 2000. Also for some of the forms that it merge into
it goes very quickly and takes in the 700+ records almost instantly

"Sygorny" wrote:

> what version of word are you using
>
> "kyle" wrote:
>
> > Hi, I use mail merge to get info stored on my data base onto a word doc so i
> > can add stuff unique to that record, however i keep all of the years records
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7721
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7721
> > on one data base and that has now grown to over 800 records and each one has
> > about 12 fields that it merges. So each time I mail merge it now takes about
> > 20 min to get my word report. When i use mail merge i just hit the button on
> > the tool bar and dont use any marcos cause i dont really know how. my
> > question is, is there an easy to make this go quicker? can i just merge the
> > last record that i inputed? I know if i publish it in word as a rich text doc
> > i can merge that qucikly but i would like to not have to do that step. thanks!