Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2005

Tip: Looking for answers? Try searching our database.

Merge all records to same page in word97

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Matt Williamson - 06 Apr 2005 17:21 GMT
I'm trying to do a mail merge in word 97 using Outlook 2k contacts as the
data source to create a single quote/comma delimited file that I can import
into excel. Is there an easy way to supress the page break between each
record so that all records appear on the same page until they overflow onto
the next one?

TIA

Matt
Graham Mayor - 06 Apr 2005 17:26 GMT
This is the function of a directory/catalog merge - everything you enter is
such a merge document is repeated for each record one immediately after the
other.
Incidentally Outlook will export its contacts list to a CSV file which you
can import into Excel without using Word.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I'm trying to do a mail merge in word 97 using Outlook 2k contacts as
> the data source to create a single quote/comma delimited file that I
[quoted text clipped - 5 lines]
>
> Matt
Matt Williamson - 06 Apr 2005 18:59 GMT
Graham-

That was simple. Thank you.

I'm using word as an intermediary because I need some IF THEN logic to
determine what fields to pull. I judged this to be the fastest way to get
where I needed to go.

Matt

> This is the function of a directory/catalog merge - everything you enter
> is
[quoted text clipped - 13 lines]
>>
>> Matt
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.