Forum Home
Press F1
 
Thread ID: 16181 2002-02-28 23:11:00 Outlook 97 - bulk Reply ? Guest (0) Press F1
Post ID Timestamp Content User
37521 2002-02-28 23:11:00 I have changed ISP and th4 email address and I wnat to send an advisory mssge to:

1)email addresses from all mssges in my Inbox
- how do I do this (without duplicates)in Outlook 97.

2)To all email addresses in my Contact Address Book

I obviously want to do this in one or two goes - and without broadcasting all these emails to each recipiant

How hard can it be??
Thanks
Guest (0)
37522 2002-03-01 03:55:00 Do you have Excel or Works spreadsheet ?
If so you can try this:

- In Outlook select the folder eg Inbox you want to work with.
- Make sure the view is just plain 'Messages' ie one message per line in the listing
- Select All (CTRL/A)
- Copy (Ctrl/C)
- Go to a new spreadsheet in Excel
- Edit...Paste... Special... Text
You now have a table with the Senders name in some column (usually first but you may have change your Outlook view)

To sort and get no duplicate in Excel is a bit messy but this usually works

- Select the table
- Data... PivotTable... Report... Next...Next... Drag 'From' to both Row box and Data Box... Next... Finish
You should now have a new table with list sorted no duplicates in Col A.
Use this for sending you message
:-)
jt
Guest (0)
37523 2002-03-01 04:00:00 If you want to send a message to a heap of people, eg, everyone in your address book and you don't want everyone to see the other addresses, open a new message, click To, that displays all the possible entries, select the ones you want to advise and click the BCC tab, that way no one will know who else has the same message Guest (0)
1