Excel 2007 : Creating a "Mail Merge" Type of spreadsheet.

[Rino468]

Hello all --

I may not need help with that actual formula per se, I just kind of need some guidance on how to approach this issue.

What I have to work with is basically a spreadsheet with data (it contains Software Names) and for each software name there is a bunch of questions that needed to be answered. (each column has an answer)

I have about 500 line items like this.

I need to email each point of contact this bit part of the spreadsheet (Application name / questions / answers) --

I would like to email each person their line item in the spreadsheet (as opposed to copying and pasting into the body of an email.

Is there a faster way to do this than -- copying the line to a new workbook or worksheet - manually?

Some sort of formula (like a mail merge type thing<<Software Name>> <<Answer 1>> etc...) to make this go alot faster?

Thanks ahead of time.

Thanks ahead of time

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[Rino468]

Thanks - Will do.

Here is an example:

Basically on the DATA Sheet I have all my data

Software Name and the answers to three questions.

On the "FINAL PRODUCT" sheet

is the spreadsheet I want to send everyone. It has the Software name along with the questions themselves (these would remain static and never change) and then the answers as per the "DATA" Sheet.

I need to email each point of contact the question and answer for their verification.

I am trying to avoid cutting and pasting line by line.

Is there an automatic way of doing this?