Mail Merge question

[gabo22003]

Hello,

We sell books and I need to create a document that has a title with a
variable name that includes book name and date published along with a
listing of folks address in label format.

I have an Excel db document that lists names and addresses (& book
name, phone numbers, email, fax, etc).

When I create a label mail merge it doesn't let me add the title
information. If I create a letter type merge document I can't add the
label format.

A layout of the document I am looking for is:

Steve's Book
Date Published: 1/21/07

Name1 Name2 Name3
Address1 Adress2 Address3
Job1 Job2 Job3

How do I accomplish this?

Thanks,
gabo

 

[Jezebel]

MailMerge *will* do what you want. Read Help more thoroughly and look at the
Catalog examples.

 

[gabo22003]

MailMerge *will* do what you want. Read Help more thoroughly and look at the
Catalog examples.














- Show quoted text -

Thanks for your response.

I have been reading on mail merge and I am requesting a little more
help.

What I have done is select the "letter" option for mail merge. I can
get the header information fine, it is the label-type information that
I am having difficulty with. I can't keep the record information
together or I can't make the records change names.

Here is one example I have is where the address information is, it
dups the same record (same name, job title, etc for both) -


«First_Name» «Last_Name» «First_Name» «Last_Name»
«Job_Title»
«Job_Title»
«County»
«County»
«Company_Name»
«Company_Name»
«Job_Title»
«Job_Title»
«Next
Record»
«Next Record»

any additional help would be greatly appreciated.

 

[Graham Mayor]

Word does not readily lend itself to this type of directory/catalog merge,
but it be done - see How to use mail merge to create a list sorted by
category in Word 2002 - http://support.microsoft.com/?kbid=294686

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[gabo22003]

Word does not readily lend itself to this type of directory/catalog merge,
but it be done - see How to use mail merge to create a list sorted by
category in Word 2002 -http://support.microsoft.com/?kbid=294686

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

My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>











- Show quoted text -

Thank you!!