ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print one standard letter to address to diff. costumer (https://www.excelbanter.com/excel-discussion-misc-queries/33382-print-one-standard-letter-address-diff-costumer.html)

faith

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.

Anne Troy

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.




Dave Peterson

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


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com