98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course - Mailshot
excel course - Mailshot
Resolved · Low Priority · Version Standard
Wed 7 Mar 2007, 09:29Delegate Alistair said...
Wed 7 Mar 2007, 17:03
Edited on Wed 14 Mar 2007, 09:37Trainer Tracy said...
RE: mailshot
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
Mon 12 Mar 2007, 11:21Delegate Alistair said...
RE: mailshot
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.
Wed 14 Mar 2007, 09:43Trainer Tracy said...
RE: mailshot
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Customize the toolbar in Excel 2010You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please. |
