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 / August 2006

Tip: Looking for answers? Try searching our database.

Producing directories using mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nessy - 18 Aug 2006 12:01 GMT
Can I produce different style directories using mailmerge. I have about 270+
adddresses plus individual interests (upto 20 options for each) Any ideas of
how I can create a horizontal listing. any advice welcome. Thanks Vanessa UK
Peter Jamieson - 18 Aug 2006 14:05 GMT
You can produce lots of different layouts using Word (generally speaking
it's useful to experiment), but
a. which version of Word?
b. what is the data source (Outlook contacts? An Excel spreadsheet?...)
c. what do you mean by a "horizontal listing" ?

It may also be better or easier to produce a directory in another
application such as Access, Excel, etc. depending on what you need and what
software is available to you.

Peter Jamieson
> Can I produce different style directories using mailmerge. I have about
> 270+
> adddresses plus individual interests (upto 20 options for each) Any ideas
> of
> how I can create a horizontal listing. any advice welcome. Thanks Vanessa
> UK
nessy - 18 Aug 2006 16:09 GMT
Hi Peter, I'm using word 2003. Datasource is an Access database. By
Horizontal listing I'm thinking one listing for each of my members which
flows across the top of a portrait page. Follwed by another one underneath.
I've tried changing the page set up. Thanks Vanessa


> You can produce lots of different layouts using Word (generally speaking
> it's useful to experiment), but
[quoted text clipped - 13 lines]
> > how I can create a horizontal listing. any advice welcome. Thanks Vanessa
> > UK
Peter Jamieson - 18 Aug 2006 16:43 GMT
First, you may find it easier to produce what you want in Access using its
Report generator anyway. I'm not so familiar with that.

> Horizontal listing I'm thinking one listing for each of my members which
> flows across the top of a portrait page. Follwed by another one
> underneath.

I'm still not clear what you want - if it's one /row/ per member in a table,
it's generally best to set your mail merge main document up as a single-row
table with one column for each field. Put one mergefield in each cell.
Don't have anything else in the mail merge main document - not even extra
paragraph marks. Merge to a new document, then add a row to the table for
headings.

However, a tabular layout like that may not be so good at dealing with
this...

> plus individual interests (upto 20 options for each)

How to do that depends partly on your table structure. if all the optional
information is in a single record in Access, I suspect what you need is
something along the general lines of

Name          Other details                Interests
<<Name>>  <<some field name>> <<Interest field A>>
                                                     <<Interest field B>>
                                                     <<Interest field C>>
etc. up to the 20th interest field.

where the fields and header are aligned using tabs (you probably won't see
it like that in this message). Word should remove lines where the interest
fields are blank.

If on the other hand you have a separate interest table, you may need
something else. But let's cross that bridge if we come to it.

If that's not the problem, have another go at spelling it out...

Peter Jamieson

> Hi Peter, I'm using word 2003. Datasource is an Access database. By
> Horizontal listing I'm thinking one listing for each of my members which
[quoted text clipped - 22 lines]
>> > Vanessa
>> > UK
 
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.