[mso] Re: Office 97 Word Merge
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 5 Dec 2002 14:14:45 -0500
duh me. of course I'd ask a question without giving enough information.
sorry.
the data comes from a third party system over which I have absolutely no
control. the system is Access based but I don't have access to it. I can
only control the merge field. What I think I need is some way of putting
the trim function or code in the mergefield itself.
is that even possible?
g
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, December 05, 2002 12:39 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Office 97 Word Merge
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
*************************************************************
*************************************************************
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:
