Unable to amend email address in cc group

Status
Not open for further replies.
W

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.
 
R

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" <Woody> wrote in message

news:5872F781-D3DA-4E21-A4D4-9490F82C1326@microsoft.com...
> 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.
>
 
W

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]" wrote:


> 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" <Woody> wrote in message
> news:5872F781-D3DA-4E21-A4D4-9490F82C1326@microsoft.com...
> > 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.
> >

> .
>
 
R

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" <Woody> wrote in message

news:8DEFA148-9A4B-46DF-ABFB-5824070CF4C8@microsoft.com...
> 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]" wrote:
>
> > 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" <Woody> wrote in message
> > news:5872F781-D3DA-4E21-A4D4-9490F82C1326@microsoft.com...
> > > 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.
> > >

> > .
> >
 
W

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]" wrote:


> 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" <Woody> wrote in message
> news:8DEFA148-9A4B-46DF-ABFB-5824070CF4C8@microsoft.com...
> > 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]" wrote:
> >
> >> 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" <Woody> wrote in message
> >> news:5872F781-D3DA-4E21-A4D4-9490F82C1326@microsoft.com...
> >> > 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.
> >> >> .
> >>

> .
>
 
R

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" <Woody> wrote in message

news:866579FE-C0C8-4351-BD28-51B7B9B201F9@microsoft.com...
> 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]" wrote:
>
> > 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" <Woody> wrote in message
> > news:8DEFA148-9A4B-46DF-ABFB-5824070CF4C8@microsoft.com...
> > > 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]" wrote:
> >> >> 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" <Woody> wrote in message
> > >> news:5872F781-D3DA-4E21-A4D4-9490F82C1326@microsoft.com...
> > >> > 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.
> > >>> >> .
> > >>

> > .
> >
 
W

Woody

Thanks Roady

"Roady [MVP]" wrote:


> 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" <Woody> wrote in message
> news:866579FE-C0C8-4351-BD28-51B7B9B201F9@microsoft.com...
> > 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]" wrote:
> >
> >> 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" <Woody> wrote in message
> >> news:8DEFA148-9A4B-46DF-ABFB-5824070CF4C8@microsoft.com...
> >> > 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]" wrote:
> >> >> >> 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" <Woody> wrote in message
> >> >> news:5872F781-D3DA-4E21-A4D4-9490F82C1326@microsoft.com...
> >> >> > 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.
> >> >> >> >> .
> >> >
> >> .
> >>

> .
>
 
R

Roady [MVP]

You're welcome! :)

---
"Woody" <Woody> wrote in message

news:2B9A6487-B613-4043-9C44-D4C4CAD2FBEC@microsoft.com...
> Thanks Roady

> "Roady [MVP]" wrote:
>
> > 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" <Woody> wrote in message
> > news:866579FE-C0C8-4351-BD28-51B7B9B201F9@microsoft.com...
> > > 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]" wrote:
> >> >> 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" <Woody> wrote in message
> > >> news:8DEFA148-9A4B-46DF-ABFB-5824070CF4C8@microsoft.com...
> > >> > 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]" wrote:
> > >>> >> >> 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" <Woody> wrote in message
> > >> >> news:5872F781-D3DA-4E21-A4D4-9490F82C1326@microsoft.com...
> > >> >> > 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.
> > >> >>> >> >> .
> > >> >
>> >> .
> > >>

> > .
> >
 
Status
Not open for further replies.
Top