[mso] Word Merge
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 25 Jun 2003 15:48:51 -0400
Hi All (especially Word Gods & Goddesses).
The sample table is in Access (but it could be Excel if preferred). The
desired result is a merge letter in Word. I can't seem to get the
options & values to merge correctly. Some letters may have 1 option,
some 15. I can get one option but not all. If I put in enough next
record fields to accommodate 15 but the record only has 2 then they
simply repeat (at least that's what I think is happening). Of course,
the total as a calculation won't work although I could include it as
another value in the table.
Any help or advice appreciated.
Thanks. /g
Sample Table
NAME OPTIONS VALUE
Brian Smith Option 1 $50
Brian Smith Option 2 $25
Brian Smith Option 3 $75
Mary Jones Option 1 $50
Mary Jones Option4 $10
John James Option2 $25
John James Option3 $75
John James Option5 $15
John James Option 6 $5
Desired Result
Dear Brian.
You will be responsible for
OPTIONS
Option1 $50
Option2 $25
Option3 $75
TOTAL $150
Sincerely,
Somebody Incharge
-----
Dear Mary.
You will be responsible for
OPTIONS
Option1 $50
Option4 $10
TOTAL $60
Sincerely,
Somebody Incharge
-----
Dear John.
You will be responsible for
OPTIONS
Option2 $25
Option3 $75
Option5 $15
Option6 $5
TOTAL $120
Sincerely,
Somebody Incharge
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
