Mail merge

Hi Mario, Thanks for the post, in answer to your question, I would email the addresses from your mobile to your work email address as a text file, (your Blackberry can do this) ensure that the address is separated by tabs or commas before you do so.

You should then open the file from Excel and follow this procedure:


You might expect to see this feature on the File, Open menu, but instead you should select Data, Get External Data, Import Text File. This command calls up a dialog box in which you select a text file, whereupon the Text Import Wizard lets you specify how Excel should import the data.

Finally, in the Import Data dialog box, you indicate the desired worksheet destination.

Excel imports the text file as a database query, which you can update if the data in the text file changes (select Data, Refresh Data to do so).

To import the file as static data, click Properties in the Import Data dialog, and remove the check mark from the "Save query definition" box.

Once you have imported the file into Excel it will then be available as a data source for your mail merge requirements.

I hope that has helped, if so please click the resolved link, thanks again for an enjoyable day, Pete.