Form letter help

[tommyb2825]

I am trying to create a letter in excel with Dear name and name,

I am using a single sheet named Input to create 2 forms and 2 letters. There will always be a name in the first cell, and if there is a name in the second cell I need it to add the and.

So,

Dear Mike,

or

Dear Mike and Sally,

I don't know any VBA and don't want to use a mail merge in word. Trying to streamline so I don't have to input the info into excel for the order forms and word twice for the letters.

Thanks,

Tommy

 

[CWatts]

Try this:

Excel Workbook
	D	E	F	G
2	Person 1	Person 2		List
3	Mike			Dear Mike,
4	Mike	Sally		Dear Mike and Sally,
5	Bill			Dear Bill,
6	Steve			Dear Steve,
7	George	Carl		Dear George and Carl,
Sheet1