Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sheila Sheila is offline
external usenet poster
 
Posts: 31
Default Help With Form Ltr Mail Merge With Multiple Input Records Per Page

I am using MS Word 2007 and Excel 2007. My Excel file source contains the
following fields:
LAST NAME, FIRST NAME, ADDRESS 1, ADDRESS2, DATE, AMT, PROJECT.

I have the same name listed multiples times, depending on the number of
projects they have contributed to, i.e.:
Jones Mary some street some apt. 09/09/09 $10.00 Missions
Jones Mary 10/01/09 $ 5.00
Thanksgiving Baskets
Smith Sue some street some apt. 07/01/09 $20.00 Christmas
Dodge Joe some street 05/02/08 $ 5.00 Global
Missions
Dodge Joe 06/05/09 $ 1.00
Missions
Dodge Joe 08/02/09 $ 4.00
Some Project

My goal is to write one letter to each of the people in my Excel list
itemizing their contributions. So, Mary Jones would have 2 items in her list,
Sue Smith would have 1 item in her list, and Joe Dodge would have 3 letters
in his list.

I am choosing "Directory" in the "Start Mail Merge"; and have connected
successfully to my Excel spreadsheet. I learned that I have to use ctrl + F9
to enter my brackets, but for the life of me I cannot get the logic right.
Can you please help me. I'm stumped.
Bill
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Help With Form Ltr Mail Merge With Multiple Input Records PerPage

The solution Macropod just mentioned is probably also applicable to your
problem:

------------------
To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
------------------

-
Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Sheila wrote:
I am using MS Word 2007 and Excel 2007. My Excel file source contains the
following fields:
LAST NAME, FIRST NAME, ADDRESS 1, ADDRESS2, DATE, AMT, PROJECT.

I have the same name listed multiples times, depending on the number of
projects they have contributed to, i.e.:
Jones Mary some street some apt. 09/09/09 $10.00 Missions
Jones Mary 10/01/09 $ 5.00
Thanksgiving Baskets
Smith Sue some street some apt. 07/01/09 $20.00 Christmas
Dodge Joe some street 05/02/08 $ 5.00 Global
Missions
Dodge Joe 06/05/09 $ 1.00
Missions
Dodge Joe 08/02/09 $ 4.00
Some Project

My goal is to write one letter to each of the people in my Excel list
itemizing their contributions. So, Mary Jones would have 2 items in her list,
Sue Smith would have 1 item in her list, and Joe Dodge would have 3 letters
in his list.

I am choosing "Directory" in the "Start Mail Merge"; and have connected
successfully to my Excel spreadsheet. I learned that I have to use ctrl + F9
to enter my brackets, but for the life of me I cannot get the logic right.
Can you please help me. I'm stumped.
Bill

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sheila Sheila is offline
external usenet poster
 
Posts: 31
Default Help With Form Ltr Mail Merge With Multiple Input Records Per

Peter,
Thank you so much. We'll take a look and get back to you if we still have
problems with hour merge. Really appreciate your timely response and info.
Sheila
"Peter Jamieson" wrote:

The solution Macropod just mentioned is probably also applicable to your
problem:

------------------
To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge
Tutorial at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document
included with it.
------------------

-
Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Sheila wrote:
I am using MS Word 2007 and Excel 2007. My Excel file source contains the
following fields:
LAST NAME, FIRST NAME, ADDRESS 1, ADDRESS2, DATE, AMT, PROJECT.

I have the same name listed multiples times, depending on the number of
projects they have contributed to, i.e.:
Jones Mary some street some apt. 09/09/09 $10.00 Missions
Jones Mary 10/01/09 $ 5.00
Thanksgiving Baskets
Smith Sue some street some apt. 07/01/09 $20.00 Christmas
Dodge Joe some street 05/02/08 $ 5.00 Global
Missions
Dodge Joe 06/05/09 $ 1.00
Missions
Dodge Joe 08/02/09 $ 4.00
Some Project

My goal is to write one letter to each of the people in my Excel list
itemizing their contributions. So, Mary Jones would have 2 items in her list,
Sue Smith would have 1 item in her list, and Joe Dodge would have 3 letters
in his list.

I am choosing "Directory" in the "Start Mail Merge"; and have connected
successfully to my Excel spreadsheet. I learned that I have to use ctrl + F9
to enter my brackets, but for the life of me I cannot get the logic right.
Can you please help me. I'm stumped.
Bill


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple records mail merge - Another Question mom2dramaqeen Mailmerge 10 April 4th 09 12:36 AM
Mail Merge Multiple Records Peter Hibbs[_2_] Mailmerge 5 February 16th 09 04:43 PM
Merge Multiple Records from Excel into Word Mail Merge Jim[_6_] Mailmerge 1 January 8th 09 10:08 PM
Multiple Records Mail Merge yuckster Microsoft Word Help 1 November 26th 05 07:08 AM
Mail Merge - Multiple Address Records paldba Mailmerge 1 August 1st 05 07:41 PM


All times are GMT +1. The time now is 10:31 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"