Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Caitlin
 
Posts: n/a
Default Coverting an Excel document

How do I convert an Excel document containing 3 columns of names and
addresses into a document (pref into Microsoft Word template) to create a
mailing label document with out individually coping and pasting each name and
address?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default Coverting an Excel document

Hi Caitlin

Don't copy the data anywhere.Ensure you have headers to your data in
your Excel sheet..
In Word, use the Mailmerge wizard, and in Step 3 tell it to use an
existing list and Browse to your Excel file.
You will then see you can incorporate your data into labels or into a
form letter.
You can also filter to select which names to use.

--
Regards

Roger Govier


"Caitlin" wrote in message
...
How do I convert an Excel document containing 3 columns of names and
addresses into a document (pref into Microsoft Word template) to
create a
mailing label document with out individually coping and pasting each
name and
address?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Difficult for me, probably basic to you onlyjohn Excel Worksheet Functions 1 February 3rd 06 05:14 PM
How do you replace a work sheet in excel with a word document? DonxCahill Excel Discussion (Misc queries) 2 July 11th 05 05:03 PM
Help, insert a word document contents into excel tab? Dan Ward Excel Discussion (Misc queries) 2 December 15th 04 12:01 AM
getting specific info from a word document into excel smintey Excel Discussion (Misc queries) 3 December 8th 04 08:20 PM
Getting specific data from a word document into an excel sheet smintey Excel Worksheet Functions 3 December 7th 04 05:17 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"