A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Create Mailing Labels In Word 97



 
 
Thread Tools Display Modes
  #1  
Old October 26th, 2005, 09:58 PM
K
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

I'm trying for the first time to create mailing labels in our Word 97. Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for the
computerly challenged? Thanks, K.
  #2  
Old October 26th, 2005, 10:11 PM
Anne Troy
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

Open an Excel file OR create a Word table with 5 columns and at least 2
rows.
Across the first row, put Name, Address, City, State, Zip
Across the second row, put your first address.
Across the third row, put your 2nd address, and so on....NO SPACES.
Then, do a mail merge:
http://www.theofficeexperts.com/word.htm#MailMerge
By having your data in a table or in an Excel file (separately), you can
sort and add and subtract MUCH more easily than typing up a set of labels
will provide.
************
Anne Troy
www.OfficeArticles.com

"K" wrote in message
...
I'm trying for the first time to create mailing labels in our Word 97.
Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for
the
computerly challenged? Thanks, K.



  #3  
Old October 27th, 2005, 05:47 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

If you just use the Mailmerge Helper (ToolsMailmerge) and follow the steps
it is pretty straight forward.

But in addition you might look at the following articles:

"Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMe...DataSource.htm

"How to convert addresses into a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMe...ToDatafile.htm

"How to create a Mail Merge" at:

http://www.word.mvps.org/FAQs/MailMe...AMailMerge.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"K" wrote in message
...
I'm trying for the first time to create mailing labels in our Word 97.
Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for
the
computerly challenged? Thanks, K.



  #4  
Old October 27th, 2005, 11:02 PM
K
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

Anne and Doug: Appreciate your taking time to consider and answer my
question. You've provided a great deal of helpful info. Even I should be able
to mail merge with all this help. Thanks, K.

"K" wrote:

I'm trying for the first time to create mailing labels in our Word 97. Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for the
computerly challenged? Thanks, K.

  #5  
Old October 28th, 2005, 03:09 PM
K
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

Well, I've finally stumbled thru my first mail merge document. After
converting my list of addresses, all 200 listings were successfully merged.
On screen it showed 4-3/4 addresses on a page of 4-1/4" x 5". When printed,
it printed only 4 addresses per page - in the proper place for that size of
label. Have I not done enough, or done something wrong, to keep from getting
a page full of addresses, like the page full of labels? All ideas and
suggestions will be greatly appreciated. Thanks, K.

"K" wrote:

I'm trying for the first time to create mailing labels in our Word 97. Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for the
computerly challenged? Thanks, K.

  #6  
Old October 28th, 2005, 06:10 PM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

What type of label have you selected for the mail merge main document?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"K" wrote in message
...
Well, I've finally stumbled thru my first mail merge document. After
converting my list of addresses, all 200 listings were successfully
merged.
On screen it showed 4-3/4 addresses on a page of 4-1/4" x 5". When
printed,
it printed only 4 addresses per page - in the proper place for that size
of
label. Have I not done enough, or done something wrong, to keep from
getting
a page full of addresses, like the page full of labels? All ideas and
suggestions will be greatly appreciated. Thanks, K.

"K" wrote:

I'm trying for the first time to create mailing labels in our Word 97.
Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for
the
computerly challenged? Thanks, K.



  #7  
Old October 28th, 2005, 09:15 PM
K
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

Yes, I finally found it and have successfully completed my first mailmerge
mailing labels. Could not have done it without yours and Annes help. Really
appreciate it. Thanks, K.

"Doug Robbins - Word MVP" wrote:

What type of label have you selected for the mail merge main document?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"K" wrote in message
...
Well, I've finally stumbled thru my first mail merge document. After
converting my list of addresses, all 200 listings were successfully
merged.
On screen it showed 4-3/4 addresses on a page of 4-1/4" x 5". When
printed,
it printed only 4 addresses per page - in the proper place for that size
of
label. Have I not done enough, or done something wrong, to keep from
getting
a page full of addresses, like the page full of labels? All ideas and
suggestions will be greatly appreciated. Thanks, K.

"K" wrote:

I'm trying for the first time to create mailing labels in our Word 97.
Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for
the
computerly challenged? Thanks, K.




  #8  
Old October 30th, 2005, 03:18 PM
K
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

During my stumble thru Mail Mergre the other day, at some point in the
process a screen came up during datasource conversion that allowed me to
define what determined the end of a line and what determined the end of a
record. Now I am trying to bulid a list of labels with a different but
similar datasource and I cant seem to find that screen again. Consequently I
cant get my datasource converted like before. I think Im following the same
process as before but of course thats always questionable. Any ideas about
how to get to that conversion screen will be greatly apprciated. Thanks, K.

"K" wrote:

I'm trying for the first time to create mailing labels in our Word 97. Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for the
computerly challenged? Thanks, K.

  #9  
Old October 30th, 2005, 04:36 PM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

It would most likely come up if you were using a .txt file as the data
source. In what format do you have the new datasource?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"K" wrote in message
...
During my stumble thru Mail Mergre the other day, at some point in the
process a screen came up during datasource conversion that allowed me to
define what determined the end of a line and what determined the end of a
record. Now I am trying to bulid a list of labels with a different but
similar datasource and I cant seem to find that screen again. Consequently
I
cant get my datasource converted like before. I think Im following the
same
process as before but of course thats always questionable. Any ideas about
how to get to that conversion screen will be greatly apprciated. Thanks,
K.

"K" wrote:

I'm trying for the first time to create mailing labels in our Word 97.
Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for
the
computerly challenged? Thanks, K.



  #10  
Old October 31st, 2005, 10:30 PM
K
external usenet poster
 
Posts: n/a
Default Create Mailing Labels In Word 97

The data source Im trying to use is a MS Word document, .doc, the same format
as I used before when the window in question came up before. Thanks, K.

"Doug Robbins - Word MVP" wrote:

It would most likely come up if you were using a .txt file as the data
source. In what format do you have the new datasource?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"K" wrote in message
...
During my stumble thru Mail Mergre the other day, at some point in the
process a screen came up during datasource conversion that allowed me to
define what determined the end of a line and what determined the end of a
record. Now I am trying to bulid a list of labels with a different but
similar datasource and I cant seem to find that screen again. Consequently
I
cant get my datasource converted like before. I think Im following the
same
process as before but of course thats always questionable. Any ideas about
how to get to that conversion screen will be greatly apprciated. Thanks,
K.

"K" wrote:

I'm trying for the first time to create mailing labels in our Word 97.
Each
label will be different. Following the Help instructions has proved to be
beyond my capabilities. Any chance there instructions for this task for
the
computerly challenged? Thanks, K.




 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
take yet another lesson from wordperfect "reveal codes" wordperfect is superior General Discussion 5 May 11th, 2009 07:58 PM
word and wordperfect mail merges slgcms Mailmerge 2 September 27th, 2005 02:13 PM
Please add an outlining feature like WordPerfect's. zaffcomm General Discussion 1 September 20th, 2005 07:21 PM
Continuous breaks convert to next page breaks Jennifer Hunt General Discussion 2 December 30th, 2004 05:45 PM
word error mac General Discussions 1 May 6th, 2004 08:14 AM


All times are GMT +1. The time now is 08:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.