[mso] Re: Office 97 Word Merge
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 05 Dec 2002 12:38:45 -0500
Where is the data? In Word? Access? Excel?
If it's in Excel, you can just add a column and use the LEFT function to
get the first letter of the word ...
=LEFT(A1)
Then you can use that column as the field in your mail merge
If it's in Word, tell me how you trimmed it in the first place and I can
probably tell you how to get it into the merge....but I'm sorry, I don't
know how to "trim" in Word. (If it were me, I would highlight all the
data in the Word table and copy it and paste it into Excel, then do what
I said above)
If it's in Access, I have no clue how to do it...sorry.
Personally, I find Excel is the best place to store a flat database for
Word Mail Merges. Word tables just don't give me enuf functionality and
Access is overkill for a flat database, IMO.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Glenda Wells
Sent: Thursday, December 05, 2002 11:46 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Office 97 Word Merge
Please forgive if this is a duplicate. I wasn't sure I sent this
earlier. I
can't find my sent copy or a reply. My system crashed twice so I might
have
meant to and didn't...it's one of those days!
The data is a full single word such as Training or Filming. In a merge
for
labels, I only need the first letter of the word. I know how to trim to
get
the letter but how do I include that in a merge field?
/g
*************************************************************
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?Subject=unsubscribe
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:
