Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pam Pam is offline
external usenet poster
 
Posts: 91
Default How do i mail merge using excel spreadsheats

I am very new to mail merge. I have managed the basics but I am stuck on the
bit where I select the recipients. I tried to use an existing client list
from a excel spreadsheet but when I tried printing the letters the clients
name and address did not come on the letter. On the spreadsheet I have got
the clients name and full address, the clients name is under column A, 1st
line of address is under B, 3rd line under C .... but when I print the letter
I get the clients name and then just 2 of the columns only. example:
Mr Smith
Chesterfield
Derbyshire

How do I get all of the address onto the letter? Also I want to put Dear Mr
Smith after the address but I cant get the salution on when I merge from an
excel doc.

Initially I created a new recipient list and this seemed to work fine, this
has been saved as a mailing database in my documents. I cant open the file
though. Does anyone know why? Its under data source and when I click on the
mdb icon it says windows cannot open the file.
I need some sort of client list that everyone in the office can have access
to which is why I thought an excel spreadsheet would be good. Im on word 2003


Thanks, Pam

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to merge Excel chart for mass Word Mail Merge for employees hmboomer Mailmerge 3 June 9th 06 10:08 PM
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 John Richmond, Watford UK Mailmerge 8 April 26th 06 06:00 AM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 08:31 AM
How to convert a mail merge document back to excel after mail mer Mail Merge Help Microsoft Word Help 4 August 22nd 05 11:31 PM
Insert Merge Field problem with Word-Mail Merge from Excel documen Augusta E. Microsoft Word Help 2 June 20th 05 10:59 AM


All times are GMT +1. The time now is 02:58 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"