Unable to amend email address in cc group

[Woody]

I send a lot of mass mailers using outlook 2007.
The email addresses are mostly in the cc box, but if one of them is
incorrect ie: the @ sign is missing, it pops up when i try and send saying it
does not recognise the address. It does then not let you amend that email
address unless it is in the contacts list. Most of the people i send to are
not in my contacts. It was easy to change in 2003 but i cannot figure out how
to do it in 2007. Has anyone got any ideas, as i send a fair amount of these
emails.
Thanks.

 

[Roady [MVP]]

Where do you get stuck and how is this different to you when comparing to
Outlook 2003?
Cancel the Check Names dialog and modify the address which is incorrect.

 

[Woody]

This isn't really practical to do, as there sometimes upwards of 500 email
addresses and it takes time to scrool through all these to get to the one
that is wrong.

 

[Roady [MVP]]

Let's take a step back then; where are you getting these addresses from?
Can't you filter the source already?
How did you do this in Outlook 2003?

 

[Woody]

Thanks Roady,
The addressses are cut and pasted from an excel spreadsheet, which as i said
can be upwards of 500 addresses.
Because of the amount of data there is it is very time consuming going
through all these email addresses on the spreadhseet before they get into an
email.
All i wanted to know is if there was a quick way to edit an email address
from the CC box before sending. I am trying to get the spreadsheet updated
but it takes time, and sometimes i need to get a mailer out.

 

[Roady [MVP]]

The quickest way to find the culprits in your Excel sheet when not being too
familiar with Excel, is to use Condition Formatting.
Select the column that contains the addresses and then;
Conditional Formatting-> Highlight Cells Rules-> Text that Contains...-> @

All the cells that are not highlighted will require your attention.
To easily leave out the ones that are wrong (in case you do not want to fix
it now but to send out a mailing with valid addresses only);
Sort & Filter-> Custom...-> Sort On: Cell Color

 

[Woody]

Thanks Roady

The quickest way to find the culprits in your Excel sheet when not being too
familiar with Excel, is to use Condition Formatting.
Select the column that contains the addresses and then;
Conditional Formatting-> Highlight Cells Rules-> Text that Contains...-> @

All the cells that are not highlighted will require your attention.
To easily leave out the ones that are wrong (in case you do not want to fix
it now but to send out a mailing with valid addresses only);
Sort & Filter-> Custom...-> Sort On: Cell Color

 

[Roady [MVP]]

You're welcome!



-----

Thanks Roady