PC Review


Reply
Thread Tools Rate Thread

How can I maintain a database used as a source for mail functions

 
 
Beverly907
Guest
Posts: n/a
 
      10th Apr 2008
Using a previous version of Word, I established a data base containing
approximately 500 entries, which I use to create mailing labels. I
maintained it (added new entries, changed entries and deleted entries) using
the database toolbar. How can I accomplish this same task using Word 2007.
Because of its size, I do not want to retype the entire file.

I previously posted this question and was informed that someone had replied.
I could not, however, read the reply. Please respond to
(E-Mail Removed) if you are able to help.

Thank you.
 
Reply With Quote
 
 
 
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      10th Apr 2008
What you are describing is a mail merge data source. The tools for mail
merges are on the Mailings tab in Word 2007, and it appears that the secret
is to click Select Recipients and choose Use Existing List. After you've
done that, presumably the Edit Recipient List button will be enabled.

Also, Start Mail Merge gives you the menu on which you can choose the type
of mail merge main document. If you can't figure out any other way to
proceed, you can choose Step by Step Mail Merge Wizard, which I believe
also gives you the option of selecting an existing list.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Beverly907" <(E-Mail Removed)> wrote in message
news:48258923-1A00-46C7-AE69-(E-Mail Removed)...
> Using a previous version of Word, I established a data base containing
> approximately 500 entries, which I use to create mailing labels. I
> maintained it (added new entries, changed entries and deleted entries)
> using
> the database toolbar. How can I accomplish this same task using Word
> 2007.
> Because of its size, I do not want to retype the entire file.
>
> I previously posted this question and was informed that someone had
> replied.
> I could not, however, read the reply. Please respond to
> (E-Mail Removed) if you are able to help.
>
> Thank you.
>



 
Reply With Quote
 
Beverly907
Guest
Posts: n/a
 
      11th Apr 2008


"Suzanne S. Barnhill" wrote:

> What you are describing is a mail merge data source. The tools for mail
> merges are on the Mailings tab in Word 2007, and it appears that the secret
> is to click Select Recipients and choose Use Existing List. After you've
> done that, presumably the Edit Recipient List button will be enabled.
>
> Also, Start Mail Merge gives you the menu on which you can choose the type
> of mail merge main document. If you can't figure out any other way to
> proceed, you can choose Step by Step Mail Merge Wizard, which I believe
> also gives you the option of selecting an existing list.
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
>
> "Beverly907" <(E-Mail Removed)> wrote in message
> news:48258923-1A00-46C7-AE69-(E-Mail Removed)...
> > Using a previous version of Word, I established a data base containing
> > approximately 500 entries, which I use to create mailing labels. I
> > maintained it (added new entries, changed entries and deleted entries)
> > using
> > the database toolbar. How can I accomplish this same task using Word
> > 2007.
> > Because of its size, I do not want to retype the entire file.
> >
> > I previously posted this question and was informed that someone had
> > replied.
> > I could not, however, read the reply. Please respond to
> > (E-Mail Removed) if you are able to help.
> >
> > Thank you.
> >

>
>
> I am able to use my file to as a mail merge source. My question relates to the maintenance of the file - that is, how can I easily add, change, and delete records prior to using the file as the mail merge source.

 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      11th Apr 2008
As stated, once you have linked the list to the mail merge main document,
you can use the Edit Recipient List button. If the data source was created
as a Word table (in a Word doc), you can edit it directly (which is why I
always create data sources as Word tables or Excel spreadsheets); if you
create the data source using Word's tools, recent versions use an
Access-type format that can't be opened directly for editing, as I
understand it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Beverly907" <(E-Mail Removed)> wrote in message
news:573583E4-A278-4E41-88E6-(E-Mail Removed)...
>
>
> "Suzanne S. Barnhill" wrote:
>
>> What you are describing is a mail merge data source. The tools for mail
>> merges are on the Mailings tab in Word 2007, and it appears that the
>> secret
>> is to click Select Recipients and choose Use Existing List. After you've
>> done that, presumably the Edit Recipient List button will be enabled.
>>
>> Also, Start Mail Merge gives you the menu on which you can choose the
>> type
>> of mail merge main document. If you can't figure out any other way to
>> proceed, you can choose Step by Step Mail Merge Wizard, which I believe
>> also gives you the option of selecting an existing list.
>>
>> --
>> Suzanne S. Barnhill
>> Microsoft MVP (Word)
>> Words into Type
>> Fairhope, Alabama USA
>>
>> "Beverly907" <(E-Mail Removed)> wrote in message
>> news:48258923-1A00-46C7-AE69-(E-Mail Removed)...
>> > Using a previous version of Word, I established a data base containing
>> > approximately 500 entries, which I use to create mailing labels. I
>> > maintained it (added new entries, changed entries and deleted entries)
>> > using
>> > the database toolbar. How can I accomplish this same task using Word
>> > 2007.
>> > Because of its size, I do not want to retype the entire file.
>> >
>> > I previously posted this question and was informed that someone had
>> > replied.
>> > I could not, however, read the reply. Please respond to
>> > (E-Mail Removed) if you are able to help.
>> >
>> > Thank you.
>> >

>>
>>
>> I am able to use my file to as a mail merge source. My question relates
>> to the maintenance of the file - that is, how can I easily add, change,
>> and delete records prior to using the file as the mail merge source.

>



 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      11th Apr 2008
You can still edit the list in Word. When you have attached the data source,
the Edit Recipient List button becomes active. This will list the records in
the top window and the data source in the bottom window. Select the latter
in order to activate the edit button.

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Beverly907 wrote:
> "Suzanne S. Barnhill" wrote:
>
>> What you are describing is a mail merge data source. The tools for
>> mail
>> merges are on the Mailings tab in Word 2007, and it appears that the
>> secret
>> is to click Select Recipients and choose Use Existing List. After
>> you've
>> done that, presumably the Edit Recipient List button will be enabled.
>>
>> Also, Start Mail Merge gives you the menu on which you can choose
>> the type
>> of mail merge main document. If you can't figure out any other way to
>> proceed, you can choose Step by Step Mail Merge Wizard, which I
>> believe
>> also gives you the option of selecting an existing list.
>>
>> --
>> Suzanne S. Barnhill
>> Microsoft MVP (Word)
>> Words into Type
>> Fairhope, Alabama USA
>>
>> "Beverly907" <(E-Mail Removed)> wrote in message
>> news:48258923-1A00-46C7-AE69-(E-Mail Removed)...
>>> Using a previous version of Word, I established a data base
>>> containing approximately 500 entries, which I use to create mailing
>>> labels. I maintained it (added new entries, changed entries and
>>> deleted entries) using
>>> the database toolbar. How can I accomplish this same task using
>>> Word 2007.
>>> Because of its size, I do not want to retype the entire file.
>>>
>>> I previously posted this question and was informed that someone had
>>> replied.
>>> I could not, however, read the reply. Please respond to
>>> (E-Mail Removed) if you are able to help.
>>>
>>> Thank you.
>>>

>>
>>
>> I am able to use my file to as a mail merge source. My question
>> relates to the maintenance of the file - that is, how can I easily
>> add, change, and delete records prior to using the file as the mail
>> merge source.



 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      11th Apr 2008
Which I believe is what I said:

>>> choose Use Existing List. After
>>> you've
>>> done that, presumably the Edit Recipient List button will be enabled.
>>>



--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Graham Mayor" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> You can still edit the list in Word. When you have attached the data
> source, the Edit Recipient List button becomes active. This will list the
> records in the top window and the data source in the bottom window. Select
> the latter in order to activate the edit button.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Beverly907 wrote:
>> "Suzanne S. Barnhill" wrote:
>>
>>> What you are describing is a mail merge data source. The tools for
>>> mail
>>> merges are on the Mailings tab in Word 2007, and it appears that the
>>> secret
>>> is to click Select Recipients and choose Use Existing List. After
>>> you've
>>> done that, presumably the Edit Recipient List button will be enabled.
>>>
>>> Also, Start Mail Merge gives you the menu on which you can choose
>>> the type
>>> of mail merge main document. If you can't figure out any other way to
>>> proceed, you can choose Step by Step Mail Merge Wizard, which I
>>> believe
>>> also gives you the option of selecting an existing list.
>>>
>>> --
>>> Suzanne S. Barnhill
>>> Microsoft MVP (Word)
>>> Words into Type
>>> Fairhope, Alabama USA
>>>
>>> "Beverly907" <(E-Mail Removed)> wrote in message
>>> news:48258923-1A00-46C7-AE69-(E-Mail Removed)...
>>>> Using a previous version of Word, I established a data base
>>>> containing approximately 500 entries, which I use to create mailing
>>>> labels. I maintained it (added new entries, changed entries and
>>>> deleted entries) using
>>>> the database toolbar. How can I accomplish this same task using
>>>> Word 2007.
>>>> Because of its size, I do not want to retype the entire file.
>>>>
>>>> I previously posted this question and was informed that someone had
>>>> replied.
>>>> I could not, however, read the reply. Please respond to
>>>> (E-Mail Removed) if you are able to help.
>>>>
>>>> Thank you.
>>>>
>>>
>>>
>>> I am able to use my file to as a mail merge source. My question
>>> relates to the maintenance of the file - that is, how can I easily
>>> add, change, and delete records prior to using the file as the mail
>>> merge source.

>
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail-merge dynamic database source RizzKid Microsoft Word Document Management 1 9th Jan 2010 11:28 AM
Mail Merge source Access Database using Excel VBA... Pls Anyone fi.or.jp.de Microsoft Excel Programming 2 4th Nov 2009 05:43 AM
Mail Merge source Access Database using Excel VBA fi.or.jp.de Microsoft Excel Programming 1 26th Oct 2009 05:03 PM
Problem with mail merge using Access Database as source =?Utf-8?B?U1I=?= Microsoft Word Document Management 1 7th Nov 2007 02:34 PM
usuing a secured database as the data source for a mail merge docu =?Utf-8?B?Q2FybWluZQ==?= Microsoft Access Security 1 8th Dec 2004 03:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:05 PM.