Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
faith
 
Posts: n/a
Default print one standard letter to address to diff. costumer

I want to send all my costumers a standard letter, however, it will
personalize by adding their name, address, services, cost, etc. These
informations (name, address and etc) will be on an excel file, I'm not sure
what type of file the letter will be on (whatever that will work). I
remember that i was able to do this in high school, but I'm not sure if its
with MS programs. I also know that when i go to print, it will fill and print
for all the costumers on the list without me going through it individually.
I own a small company, so i can't afford to hire anyone....someone please
help me.
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Hi, Faith. You just need to do a Mail Merge from Word. This article
describes how to do labels, but Letters are similar (I'm working on that
one!).
http://www.officearticles.com/word/m...osoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"faith" wrote in message
...
I want to send all my costumers a standard letter, however, it will
personalize by adding their name, address, services, cost, etc. These
informations (name, address and etc) will be on an excel file, I'm not

sure
what type of file the letter will be on (whatever that will work). I
remember that i was able to do this in high school, but I'm not sure if

its
with MS programs. I also know that when i go to print, it will fill and

print
for all the costumers on the list without me going through it

individually.
I own a small company, so i can't afford to hire anyone....someone please
help me.



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Some more references:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

faith wrote:

I want to send all my costumers a standard letter, however, it will
personalize by adding their name, address, services, cost, etc. These
informations (name, address and etc) will be on an excel file, I'm not sure
what type of file the letter will be on (whatever that will work). I
remember that i was able to do this in high school, but I'm not sure if its
with MS programs. I also know that when i go to print, it will fill and print
for all the costumers on the list without me going through it individually.
I own a small company, so i can't afford to hire anyone....someone please
help me.


--

Dave Peterson
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
In Microsoft Excel when print last letter of each line cut off? Gerhard Excel Discussion (Misc queries) 1 May 13th 05 01:39 PM
how can I print address labels from an excel file bcowan Excel Discussion (Misc queries) 2 February 10th 05 02:07 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM
How do I make and print 3x5 address cards? spbaechle Excel Discussion (Misc queries) 3 January 11th 05 08:03 AM


All times are GMT +1. The time now is 04:42 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"