Form Letter from Excel Address book

[thetank]

Is there any way to have Excel (or Word) populate a form letter to each individual in an Excel spread sheet (address book)?

 

[Oaktree]

See: http://spreadsheetpage.com/index.php/tip/mail_merge_without_word/ for one example

 

[thetank]

Thanks for the link. That's pretty much what I need, but it brings up another problem.

Unfortunately all of my data is stored like you would normally write an address and it also has legal description information out to the side. In order to use the form letter spreadsheet, the data needs to be in the same row. Is there a way to transpose the data and keep the information associated with itself? The legal description is in Column A and the mailing address for the property owner is in Column C. Some of the property owner data is four rows while the legal description is always three rows. Here is an example:

LEGAL DESCRIPTION PROPERTY OWNER

1234 Easy St. Mickey Mouse
Southwest Addition Mouse family trust
Block 40, Lot 5 2468 Memory Ln.
Funky Town, FL 86420

1236 Easy St. John Smith
Southwest Addition 1236 Easy St.
Block 40, Lot 6 Any Town, TX 98765

 

[thetank]

That didn't come out right. Try this:

LEGAL DESCRIPTION____PROPERTY OWNER

1234 Easy St__________Mickey Mouse
Southwest Addition_____Mouse family trust
Block 40, Lot 5________ 2468 Memory Ln.
_____________________Funky Town, FL 86420

1236 Easy St__________John Smith
Southwest Addition____ 1236 Easy St.
Block 40, Lot 6_________Any Town, TX 98765

 

[Oaktree]

You can do that fairly quickly with a macro.

As a nudge in the right direction, see VoG's post at http://www.mrexcel.com/forum/showthread.php?t=412753