How do I do a mailshot from Excel?

Hi Alistair,

A mailshot facility is usually initiated from a word processing package like Word. In Word you can go in to the Tools menu and go down to Letters and Mailings and follow the wizard. Where it says do you have an existing data source say yes and browse to your excel spreadsheet containing the data.

Good luck and let me know how you get on

Tracy

Thanks Tracy,

Definitely a step in the right direction.

What I'm trying to do is, from a spreadsheet containing 100 mobile phone bills, email the individual bills to the individual people. But the Mail merge seems to just email the same spreadsheet to everyone.

I'm thinking of trying to write a macro that does them one at a time and just repeats till all 100 are sent.

Cheers
ALi.

How about trying to use Access instead of Excel to store your information. If you have Access you can import your spreadsheet table from Excel. There are alot more ways of sorting and producing reports and mailings.

If I/we can help let us know

Tracy