Export to Word

  • Thread starter Thread starter Mandi
  • Start date Start date
M

Mandi

I have a spreadsheet with 2 columns (Name and Address). I
need to send out a statement to all of the people on my
spreadsheet. I have my letter formatted in Word - Is
there anyway to to somehow merge the 2 and get the name
and address at the top of the letter (in Word) for each
name listed (in Excel) ?
 
You sound like you just want a simple mail merge. Give the range which
includes the addresses, names, and column headers, a name and save the Excel
file. Go to Word and use TOOLS>lETTERS AND MAILINGS>MAIL MERGE WIZARD and
follow directions. Post back if you need further help.
Richard Choate

I have a spreadsheet with 2 columns (Name and Address). I
need to send out a statement to all of the people on my
spreadsheet. I have my letter formatted in Word - Is
there anyway to to somehow merge the 2 and get the name
and address at the top of the letter (in Word) for each
name listed (in Excel) ?
 
Back
Top