[u3aavcuss] Re: help
- From: Ron & Rosemary M - U3A <ronandrosemary62-u3a@xxxxxxxxxxx>
- To: u3aavcuss@xxxxxxxxxxxxx
- Date: Mon, 30 Mar 2009 17:06:03 +0000 (GMT)
Hi Jim
What I think you could do is firstly save (Save As) your file with another name
say V2. Then highlight the column (by clicking on the top header) in front of
where you want to insert and right click. This will give you the option to
insert new column. Now you can call this column say "Attend" and add a marker
say "+" against everyone that has attended. Now it is possible to select all
entries and sort on "Attend" and can see all those that have attended and all
those that have not.
Following from this you could add another column with those who have paid and
sort out those who paid but did not attend for example. It is worth having a
practise on some dummy data in the first instance.
I hope my explanation makes sense, it works with Excel 2007
Regards Ron :-)
________________________________
From: James McKay <james.mckay90@xxxxxxxxxxxx>
To: u3aavcuss@xxxxxxxxxxxxx
Sent: Monday, 30 March, 2009 5:29:57 PM
Subject: [u3aavcuss] Re: help
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:
>
> 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: help
>
> Mike
> 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 of
>> the 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 people
>> chose 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] help
>>
>> Mailing 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/09
>> 07: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/09
> 16:56:00
>
> ==========================< U3A Aylesbury Vale>
>========================
>
==========================< U3A Aylesbury Vale> ========================
Other related posts:
