Mail merge from Office support- troubleshooting

Closed - This job posting has been filled and work has been completed.
Admin Support Other - Admin Support Posted 2 years ago

Fixed Price

Budget: $20
Delivery by December 17, 2013

Start Date

December 17, 2013


I am trying to do a mail merge from Excel into a pre-done Word doc; however, when I modify the address block or greeting line, I get one of the two as it changes both:

John Smith                              OR                            Mr. Smith
123 Main St.                                                            123 Main St
Anywhere, USA                                                        Anywhere, USA
123456                                                                    123456

Dear Mr. John Smith,                                                  Dear Mr. Smith,

It's been correct in the past, so know it can be done. I've tried starting over again with both files with no success. The way it should be read and merged is the following:

John Smith
123 Main St.
Anywhere, USA

Dear Mr. Smith,

About the Client

(5.00) 2 reviews

United States
Cleveland 02:04 PM

3 Jobs Posted
100% Hire Rate, 1 Open Job

$248 Total Spent
3 Hires, 1 Active

$5.56/hr Avg Hourly Rate Paid
40 Hours

Member Since Dec 20, 2011