A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to create a single yet dynamic document using mail merge?



 
 
Thread Tools Display Modes
  #1  
Old March 15th, 2010, 12:47 PM posted to microsoft.public.word.mailmerge.fields
M~T
external usenet poster
 
Posts: 1
Default How to create a single yet dynamic document using mail merge?

Hi,

I am trying to create a document in Word 2003 with the following
properties.

Section 1 - Coversheet, Table of Contents, Introduction

Section 2 - Pulls in data from an Excel sheet, (several paragraphs
with a short title and longer description) based on a value in each
row to describe the audience

Section 3 - Summary text

No page breaks enforced by the mail merge. I've spent a day
researching and experimenting and still haven't got here yet.

For Section 1 - I've learnt how to use the Includetext and bookmarks
to pull in text that is formatted (with varying degrees of success due
to using heading styles and TOC). I am prepared to discard those in
order to achieve my end goal.

For Section 2 - I've learnt how to use the Directory mail merge but
this repeats the text in section 1. I've read MS KB
http://support.microsoft.com/kb/294686/ 'How to use mail merge to
create a list sorted by category in Word' but haven't been able to
make it work for me yet.

Section 3 - should be simple, based on Include text I assume?

If I wanted to replicate the original manual word file (for bonus
credit) there would also be style headers (H1, 2 etc) in between the
sections, including within Section 2 but again I realise this may be
impossible.

Can anyone offer advice on how I might complete this project?

Thanks

Matt
  #2  
Old March 15th, 2010, 09:59 PM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default How to create a single yet dynamic document using mail merge?

Hi M~T,

For '2', your problem description doesn't really suggest a Directory merge but, if you've got a variable number of records per
letter, it may be. If so, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at:
http://lounge.windowssecrets.com/ind...owtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.


--
Cheers
macropod
[Microsoft MVP - Word]


"M~T" wrote in message ...
Hi,

I am trying to create a document in Word 2003 with the following
properties.

Section 1 - Coversheet, Table of Contents, Introduction

Section 2 - Pulls in data from an Excel sheet, (several paragraphs
with a short title and longer description) based on a value in each
row to describe the audience

Section 3 - Summary text

No page breaks enforced by the mail merge. I've spent a day
researching and experimenting and still haven't got here yet.

For Section 1 - I've learnt how to use the Includetext and bookmarks
to pull in text that is formatted (with varying degrees of success due
to using heading styles and TOC). I am prepared to discard those in
order to achieve my end goal.

For Section 2 - I've learnt how to use the Directory mail merge but
this repeats the text in section 1. I've read MS KB
http://support.microsoft.com/kb/294686/ 'How to use mail merge to
create a list sorted by category in Word' but haven't been able to
make it work for me yet.

Section 3 - should be simple, based on Include text I assume?

If I wanted to replicate the original manual word file (for bonus
credit) there would also be style headers (H1, 2 etc) in between the
sections, including within Section 2 but again I realise this may be
impossible.

Can anyone offer advice on how I might complete this project?

Thanks

Matt


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:29 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.