excel course - mailshot

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course - Mailshot

excel course - Mailshot

resolvedResolved · Low Priority · Version Standard

Alistair has attended:
Excel Advanced course

Mailshot

How do I do a mailshot from Excel?

Edited on Wed 14 Mar 2007, 09:37

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

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.

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Customize the toolbar in Excel 2010

You 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.

View all Excel hints and tips


Server loaded in 0.08 secs.