Creating Personalized Form Letters from Excel Data?

  • Thread starter diamond[at]flash[dot]net
  • Start date
D

diamond[at]flash[dot]net

I am looking for a user-friendly way to take some data that appears on a small Excel worksheet and - by clicking a button - pass that data over into Outlook.

I have a drop-down list in Excel for several fields, which causes the letter's subject and body to customize.

What I want is for Excel to pass the data in a certain cell (say "A1") to the subject field in a new email.

Then I want the data in a range of cells (say "A4 through A40") to be copied & pasted into the body of the same new email.

Is any of this possible
 
Top