mail merge

tessa,

See if the followig article is of any help:

http://www.microsoft.com/exceldev/articles/bulkmail.htm

Also, you may want to do a Google search (www.google.com) using a search string like "excel mail merge" and see what it comes up with.

I haven't used mail merge, so this is about the best I can do to help you out. Sorry.

good luck

Hi,

You are going abou this the wrong way round. In Word mail merge you can use xl spreadsheets as the data source. I have certainly done this.
You might need to be careful about positioning of your data in the xl spreadsheet to make it work. That is to say if there is too much stuff above the data table it might not work. My data is always in the format of having the first column header in A1. You might also have to be careful about spaces as I don't think word mail merge likes them.

Good luck

Lewis

tessa,

: i was wondering could i get excel to have a buttom that would interact with a mail merge using information that is in the spreadsheet i have a coloum of names address and total invoice amounts i would like to have a cell with a marcro ect that would actvate a mail merge with this information as some of the assigned spaces in the word document like add the address and name and total invoive in to the letter document any information how ever small appriciated even if just a brift outline of how to go about it thankyou

mail Merrge is really Word only, erm no thats a lie i have written a full VBA to do justthis in Excel but is EXTREAMLYCOMPLEX, selection a choice of letters and filling in ABCDEFGHIJK etc, even money and cross checks it, i couls post the code but no way i could help unless by email and thats tuff.

Work to Word or Word with Excel as database is simpler.

Why did i code out VBA Excel Mail Merge in one book,, i wanted to, simple as that.

HTH Hi, You are going abou this the wrong way round. In Word mail merge you can use xl spreadsheets as the data source. I have certainly done this. You might need to be careful about positioning of your data in the xl spreadsheet to make it work. That is to say if there is too much stuff above the data table it might not work. My data is always in the format of having the first column header in A1. You might also have to be careful about spaces as I don't think word mail merge likes them. Good luck Lewis tessa, : See if the followig article is of any help