mxd

Hi guys,

I have a spreadsheet that has name, address, phone etc.. in it and would like to be able to select a row and have that produce/fill in a word doc.

I looked t mail merge but that takes all entreis in a spreadsheet and produces a doc for each where I only need to take 4 or so coloums out of 60 or so columns to produce the form.

Is this possible ?

The spread sheet conatains a list of leads (building) the form I wold like to produce will have the name etc.. on it as well as other information I fill out on site (height, length, width, material, etc..)

Would/could this be better done another way, i.e select row, press button then xml -> report -> print ?

any suggestions/tips/hins/examples greatly appreciated. The only thing that is mandatory is the leads will start from a spreadsheet.

cheers

Matt

Glaswegian

Hi and welcome to TSF.

Rather than transfer data to Word, why not create a document in Excel, since all the data is there already? Then it would just need some VBA code to transfer the data. What version of Excel are you using?

mxd

Hi

I am using 2007 office, I thought keeping it in excel would be the easiest I was just unsure of how to do that.

thanks
Matt

Glaswegian

Hi Matt

You can produce forms or invoices or even letters in Excel - and nobody would be able to tell the difference between that and one produced on Word.

Put all the items, such as logo or invoice details etc into your sheet. You can adjust the column widths etc to suit - for example, I create forms where I need to have one letter in one cell. I therefore make the column width = 4.

Once your layout is finalised, and you know where your data will go, you can then start on the code to populate the form.

This is one of those things you really need to play around with, just to get the right settings to suit your own purpose.

I'm not familiar with XL2007, but the basics will be pretty much the same.

Post back with any questions etc.