What I want/need to be able to do is insert another column (or two) into the data base (without losing it) so that I can prepare a mailing list by selecting names. At present if I use the database to prepare a mailing list (labels) it selects all the names on the list. I need to be able to make labels for those who are not present at meetings.. As you will have guessed I need to be able to work better with excel/word
cheers Jim Mike Bean wrote:
==========================< U3A Aylesbury Vale> ========================Yes, it is easy IF what you want to select by is in your data file! So tell all! Mike -----Original Message----- From: u3aavcuss-bounce@xxxxxxxxxxxxx [mailto:u3aavcuss-bounce@xxxxxxxxxxxxx] On Behalf Of James McKay Sent: 26 March 2009 07:44 To: u3aavcuss@xxxxxxxxxxxxx Subject: [u3aavcuss] Re: helpMike Thanks 'done & dusted' now have to work out how to set a selective filter so I only print selected labels. easy ???Jim Mike Bean wrote:Jim, Let me guess that you are using and Excel spreadsheet as your data source and that you are using the Wizard to create your label run. If that's the case at the point where you 'Select recipients' and click 'using an existing list' and 'Browse' do you click on the 'Surname' bar to sort the recipients into surname order before proceeding with the rest ofthe process?If this does not fix the ordering tell us more about your setup and we'll have another go! Mike PS - It's a good idea to give a meaningful title to e-mails - many peoplechose whether to read an e-mail depending on its title alone!-----Original Message----- From: u3aavcuss-bounce@xxxxxxxxxxxxx[mailto:u3aavcuss-bounce@xxxxxxxxxxxxx]========================On Behalf Of James McKay Sent: 25 March 2009 14:13 To: u3aavcuss@xxxxxxxxxxxxx Subject: [u3aavcuss] helpMailing lists. why cant I persuade MS Word to mail merge my data base in alphabetical order??? it makes the labels perfectly but wil not put them in the correct order. I am using a microsoft access database and merging it with ms word.thanks in advance Jim==========================< U3A Aylesbury Vale>========================No virus found in this incoming message.Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.28/2022 - Release Date: 03/25/0907:16:00==========================< U3A Aylesbury Vale>==========================< U3A Aylesbury Vale> ========================No virus found in this incoming message.Checked by AVG - www.avg.com Version: 8.5.285 / Virus Database: 270.11.31/2029 - Release Date: 03/29/0916:56:00==========================< U3A Aylesbury Vale> ========================