POP 3 attachment

Using winsock, how can I read POP 3 email attachment (the attachment is an 
..EML file) ?

Thank you 


0
fniles
9/6/2010 7:55:34 PM
vb.general.discussion 1016 articles. 0 followers. Follow

15 Replies
1105 Views

Similar Articles

[PageSpeed] 38

On 06/09/2010 20:55, fniles wrote:
> Using winsock, how can I read POP 3 email attachment (the attachment is an
> .EML file) ?

Have a look at RFC1939 for the POP3 protocol (It's as easy as login, get 
message, disconnect), and then RFC822, the MIME/multipart MIME specs and 
base64 decoding (if required).
If the attachment is another email, then that is nothing special, it's 
just the same structure again.

-- 
Dee Earley (dee.earley@icode.co.uk)
i-Catcher Development Team

iCode Systems

(Replies direct to my email address will be ignored.
Please reply to the group.)
0
Dee
9/7/2010 7:43:18 AM
Thank you

What is RFC1939 and RFC822 ?
Where can I find it ?

"Dee Earley" <dee.earley@icode.co.uk> wrote in message 
news:%23QILCEmTLHA.5944@TK2MSFTNGP06.phx.gbl...
> On 06/09/2010 20:55, fniles wrote:
>> Using winsock, how can I read POP 3 email attachment (the attachment is 
>> an
>> .EML file) ?
>
> Have a look at RFC1939 for the POP3 protocol (It's as easy as login, get 
> message, disconnect), and then RFC822, the MIME/multipart MIME specs and 
> base64 decoding (if required).
> If the attachment is another email, then that is nothing special, it's 
> just the same structure again.
>
> -- 
> Dee Earley (dee.earley@icode.co.uk)
> i-Catcher Development Team
>
> iCode Systems
>
> (Replies direct to my email address will be ignored.
> Please reply to the group.) 


0
fniles
9/7/2010 9:27:53 PM
"fniles" <fniles@pfmail.com> wrote in message 
news:e8n3JOtTLHA.2068@TK2MSFTNGP05.phx.gbl...
> Thank you
>
> What is RFC1939 and RFC822 ?
> Where can I find it ?

http://www.lmgtfy.com/?q=RFC1939

<g>

0
Bob
9/7/2010 10:22:31 PM
On Tue, 7 Sep 2010 16:27:53 -0500, "fniles" <fniles@pfmail.com> wrote:

>Thank you
>
>What is RFC1939 and RFC822 ?
>Where can I find it ?
>

The poorly named bible/s for the internet ...
"Request For Comments"

"Post Office Protocol - Version 3"
http://tools.ietf.org/html/rfc1939

"Internet Text Messages"
http://tools.ietf.org/html/rfc822

-ralph
0
ralph
9/7/2010 10:27:30 PM
| Thank you
|
| What is RFC1939 and RFC822 ?
| Where can I find it ?

 The RFCs are the official documentation, but
that's a wild goose chase. It's like telling
you to read the official 2010 tax code to find
out whether you can deduct your office in the
home. The info. is in there...but you'll never
find it. I already told you how to find the
attachment and retrieve it. If you don't understand
just try looking at the raw text of a few emails.
The MIME format is text-based and systematic.
You can parse it just like an email program can
parse it.


0
Mayayana
9/7/2010 11:55:18 PM
  I just tried this. It's a little bit tricky, at least in
OE, because the attached email was not fully
encoded. It was just sandwiched. Normally when you
attach a file it gets inserted as a single Base64 string.
(Note that you may have to remove carriage returns,
tabs, or other formatting junk before decoding Base64.)

 Here's a sample of the format for an email with
a JPG attachment. Note that the "boundary" value
defines a random string that separates sections of the
email. The email is parsed using boundary markers
and empty lines to identify content. Boundaries must
begin with "--". The closing boundary begins with
"--" and also ends with "--".

_________ Begin sample ______________

from
to
date
subject
Message-ID
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="BOUNDARY_STRING_1"
X-Mailer: [email program name here]
#
--BOUNDARY_STRING_1
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
#
(email text here)
#
--BOUNDARY_STRING_1
Content-Type: image/jpeg;
 name="pic1.jpg"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="pic1.jpg"
#
 (base 64 here)
#
--BOUNDARY_STRING_1--

________________ end sample ________

Notice that the attachment is identified
with the line:

Content-Disposition: attachment

  The beginning of the attachment info. is marked
by a boundary string. The Base64 string representing
the actual file content has an empty line before and
after. So it's fairly easy to check for attachments
and it's easy to extract the attachment(s).

  When I created an email with an attachment, then
attached that to another email, I ended up with the
entire first email copied in the second email. It began
with this:

Content-Type: message/rfc822;
 name="mmm.eml"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="mmm.eml"

But then instead of a blank line followed by Base64, there
was a blank line followed by the raw text of the first email:

From:
To:
Subject:
  ..etc.

The attachment in the attached email is still there. Then
the end is like this:

--Boundary_string_from_attached_email--

--Boundary_string_from_main_email--


  So you have to parse an email within an email. But as
you can see from the snippets I've posted, it still follows
standards. You'll look for

  Content-Disposition: attachment
with
  Content-Type: message/rfc822

(It may be possible for an email to have other content
type. i'm not sure.)

The attached email will start after the next blank line.
From there you find

boundary=

then find the end of the attached email by
looking for that with "--" appended. Note,
however, that the boundary is only necessary
where Content-Type is multipart/*
If Content-Type is text/plain in the attached
email, the end of the attached email may be delineated
only by a boundary marker in the main email.

  Basically, attached plain text is inserted as
plain text. Attached binary data is base64-encoded.
In the case of an attached email with attachments,
the attachment can be both because the actual file
content of the attached .EML is both. (It's all plain
text, technically, but any base64-encoded content
represents binary data.) So in order to
know whether you need to do any base64 decoding you
need to check the Content-Type of the attachment.
And you might have to do that recursively if you have
an attached EML file.

(I know this all sounds confusing, but it's actually
a simple and fairly sensible system once you get
the gist of it.)


0
Mayayana
9/8/2010 3:30:57 AM
Thank you, all.

Is it possible to save the attachment as a file, so that I can resend the 
attachment as a file in another email ?


"Mayayana" <mayayana@invalid.nospam> wrote in message 
news:i66vu7$bup$1@news.eternal-september.org...
>  I just tried this. It's a little bit tricky, at least in
> OE, because the attached email was not fully
> encoded. It was just sandwiched. Normally when you
> attach a file it gets inserted as a single Base64 string.
> (Note that you may have to remove carriage returns,
> tabs, or other formatting junk before decoding Base64.)
>
> Here's a sample of the format for an email with
> a JPG attachment. Note that the "boundary" value
> defines a random string that separates sections of the
> email. The email is parsed using boundary markers
> and empty lines to identify content. Boundaries must
> begin with "--". The closing boundary begins with
> "--" and also ends with "--".
>
> _________ Begin sample ______________
>
> from
> to
> date
> subject
> Message-ID
> MIME-Version: 1.0
> Content-Type: multipart/mixed;
> boundary="BOUNDARY_STRING_1"
> X-Mailer: [email program name here]
> #
> --BOUNDARY_STRING_1
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> #
> (email text here)
> #
> --BOUNDARY_STRING_1
> Content-Type: image/jpeg;
> name="pic1.jpg"
> Content-Transfer-Encoding: base64
> Content-Disposition: attachment;
> filename="pic1.jpg"
> #
> (base 64 here)
> #
> --BOUNDARY_STRING_1--
>
> ________________ end sample ________
>
> Notice that the attachment is identified
> with the line:
>
> Content-Disposition: attachment
>
>  The beginning of the attachment info. is marked
> by a boundary string. The Base64 string representing
> the actual file content has an empty line before and
> after. So it's fairly easy to check for attachments
> and it's easy to extract the attachment(s).
>
>  When I created an email with an attachment, then
> attached that to another email, I ended up with the
> entire first email copied in the second email. It began
> with this:
>
> Content-Type: message/rfc822;
> name="mmm.eml"
> Content-Transfer-Encoding: 7bit
> Content-Disposition: attachment;
> filename="mmm.eml"
>
> But then instead of a blank line followed by Base64, there
> was a blank line followed by the raw text of the first email:
>
> From:
> To:
> Subject:
>  ..etc.
>
> The attachment in the attached email is still there. Then
> the end is like this:
>
> --Boundary_string_from_attached_email--
>
> --Boundary_string_from_main_email--
>
>
>  So you have to parse an email within an email. But as
> you can see from the snippets I've posted, it still follows
> standards. You'll look for
>
>  Content-Disposition: attachment
> with
>  Content-Type: message/rfc822
>
> (It may be possible for an email to have other content
> type. i'm not sure.)
>
> The attached email will start after the next blank line.
> From there you find
>
> boundary=
>
> then find the end of the attached email by
> looking for that with "--" appended. Note,
> however, that the boundary is only necessary
> where Content-Type is multipart/*
> If Content-Type is text/plain in the attached
> email, the end of the attached email may be delineated
> only by a boundary marker in the main email.
>
>  Basically, attached plain text is inserted as
> plain text. Attached binary data is base64-encoded.
> In the case of an attached email with attachments,
> the attachment can be both because the actual file
> content of the attached .EML is both. (It's all plain
> text, technically, but any base64-encoded content
> represents binary data.) So in order to
> know whether you need to do any base64 decoding you
> need to check the Content-Type of the attachment.
> And you might have to do that recursively if you have
> an attached EML file.
>
> (I know this all sounds confusing, but it's actually
> a simple and fairly sensible system once you get
> the gist of it.)
>
> 


0
fniles
9/10/2010 11:44:42 PM
|
| Is it possible to save the attachment as a file, so that I can resend the
| attachment as a file in another email ?
|
  Why not? It's coming through as the complete text
of an email. The whole thing is just text. You just have
to identify the beginning and end of the attached email,
get that text, and save it. 


0
Mayayana
9/10/2010 11:56:17 PM
Thank you.

I am looking for <HTML> and </HTML> in the text, but there are so many 
things like "3D2=20","3D0=20", "3D1=20" that when I create an email using 
that, the email doesn't look like the original.
Any suggestion ?

Thank you for your help.

This is part of the text:
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18928"></HEAD>
<BODY>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
<TABLE id=3D201179 border=3D0 width=3D"100%" height=3D400>
  <TBODY>
  <TR>
    <TD vAlign=3Dtop width=3D"100%">
      <DIV dir=3Dltr align=3Dleft><FONT color=3D#0000ff size=3D2=20
      face=3DArial></FONT>&nbsp;</DIV>
      <DIV></DIV><A name=3Dtop target=3D_blank></A>
      <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D0 =
cellSpacing=3D0=20
      borderColor=3D#111111 cellPadding=3D0 width=3D"100%">
        <TBODY>
        <TR>
          <TD colSpan=3D3>
            <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D0 =
cellSpacing=3D0=20
            borderColor=3D#111111 width=3D"100%">
              <TBODY>
              <TR>
                <TD width=3D"80%" colSpan=3D2>
                  <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D1=20
                  cellSpacing=3D0 borderColor=3D#111111 cellPadding=3D0 =
width=3D"19%"=20
                  bgColor=3D#ff0000>
                    <TBODY>
                    <TR>
                      <TD width=3D"100%"><B><FONT color=3D#ffffff =
size=3D2=20


"Mayayana" <mayayana@invalid.nospam> wrote in message 
news:i6egfn$kq7$1@news.eternal-september.org...
>
> |
> | Is it possible to save the attachment as a file, so that I can resend 
> the
> | attachment as a file in another email ?
> |
>  Why not? It's coming through as the complete text
> of an email. The whole thing is just text. You just have
> to identify the beginning and end of the attached email,
> get that text, and save it.
>
> 


0
fniles
9/12/2010 6:06:44 PM
The original email looks like this:
<TITLE>Message</TITLE>


<table id="201179" border="0" width="100%" height="400"><tr><td width="100%" 
valign="top">
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<TABLE id=201179 border=0 width="100%" height=400>
  <TBODY>
  <TR>
    <TD vAlign=top width="100%">
      <DIV dir=ltr align=left><FONT color=#0000ff size=2 
face=Arial></FONT>&nbsp;</DIV>
      <DIV></DIV><A name=top target="_blank"></A>
      <TABLE style="BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 
borderColor=#111111 cellPadding=0 width="100%">
        <TBODY>
        <TR>
          <TD colSpan=3>
            <TABLE style="BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 
borderColor=#111111 width="100%">
              <TBODY>
              <TR>
                <TD width="80%" colSpan=2>
                  <TABLE style="BORDER-COLLAPSE: collapse" border=1 
cellSpacing=0 borderColor=#111111 cellPadding=0 width="19%" bgColor=#ff0000>
                    <TBODY>
                    <TR>

And, when I read it in the program using socket, they become like below.
Notice the oginal email doesn't have "<META name=3DGENERATOR 
content=3D"MSHTML 8.00.6001.18928"></HEAD>", and notice when I read it in 
the program there are many "3D" being appended, for ex:
Original
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
What I read in the program
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>

Also, when I read in the program sometimes it has "=20"
Original
      <DIV dir=ltr align=left><FONT color=#0000ff size=2 
face=Arial></FONT>&nbsp;</DIV>

What I read in the program
      <DIV dir=3Dltr align=3Dleft><FONT color=3D#0000ff size=3D2=20
      face=3DArial></FONT>&nbsp;</DIV>

This is what I read in the program:
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18928"></HEAD>
<BODY>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
<TABLE id=3D201179 border=3D0 width=3D"100%" height=3D400>
  <TBODY>
  <TR>
    <TD vAlign=3Dtop width=3D"100%">
      <DIV dir=3Dltr align=3Dleft><FONT color=3D#0000ff size=3D2=20
      face=3DArial></FONT>&nbsp;</DIV>
      <DIV></DIV><A name=3Dtop target=3D_blank></A>
      <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D0 =
cellSpacing=3D0=20
      borderColor=3D#111111 cellPadding=3D0 width=3D"100%">
        <TBODY>
        <TR>
          <TD colSpan=3D3>
            <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D0 =
cellSpacing=3D0=20
            borderColor=3D#111111 width=3D"100%">
              <TBODY>
              <TR>
                <TD width=3D"80%" colSpan=3D2>
                  <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D1=20
                  cellSpacing=3D0 borderColor=3D#111111 cellPadding=3D0 =
width=3D"19%"=20
                  bgColor=3D#ff0000>
                    <TBODY>
                    <TR>

"Mayayana" <mayayana@invalid.nospam> wrote in message 
news:i6egfn$kq7$1@news.eternal-september.org...
>
> |
> | Is it possible to save the attachment as a file, so that I can resend 
> the
> | attachment as a file in another email ?
> |
>  Why not? It's coming through as the complete text
> of an email. The whole thing is just text. You just have
> to identify the beginning and end of the attached email,
> get that text, and save it.
>
> 


0
fniles
9/12/2010 10:08:35 PM
It looks like when I read the email from the program (using socket), some 
characters were read incorrectly.
How can I fix that ?

For ex:
Original email looks like this:
Copyright � 2010 INQUIRER.net
What I read in the program
Copyright =C2=A9 2010 =INQUIRER.net

Original email looks like this:
California Provides Incentive To 'Green' Cars
What I read in the program
California Provides =Incentive To =E2=80=98Green=E2=80=99 =Cars

Original email looks like this:
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
What I read in the program
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>

Also, when I read in the program sometimes it has "=20"
Original email looks like this:
      <DIV dir=ltr align=left><FONT color=#0000ff size=2 
face=Arial></FONT>&nbsp;</DIV>

What I read in the program
      <DIV dir=3Dltr align=3Dleft><FONT color=3D#0000ff size=3D2=20 
face=3DArial></FONT>&nbsp;</DIV>

The original email looks like this:
<TITLE>Message</TITLE>

<table id="201179" border="0" width="100%" height="400"><tr><td width="100%"
valign="top">
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<TABLE id=201179 border=0 width="100%" height=400>
  <TBODY>
  <TR>
    <TD vAlign=top width="100%">
      <DIV dir=ltr align=left><FONT color=#0000ff size=2
face=Arial></FONT>&nbsp;</DIV>
      <DIV></DIV><A name=top target="_blank"></A>
      <TABLE style="BORDER-COLLAPSE: collapse" border=0 cellSpacing=0
borderColor=#111111 cellPadding=0 width="100%">
        <TBODY>
        <TR>
          <TD colSpan=3>
            <TABLE style="BORDER-COLLAPSE: collapse" border=0 cellSpacing=0
borderColor=#111111 width="100%">
              <TBODY>
              <TR>
                <TD width="80%" colSpan=2>
                  <TABLE style="BORDER-COLLAPSE: collapse" border=1
cellSpacing=0 borderColor=#111111 cellPadding=0 width="19%" bgColor=#ff0000>
                    <TBODY>
                    <TR>

This is what I read in the program:
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18928"></HEAD>
<BODY>
<DIV><FONT size=3D2 face=3DArial></FONT>&nbsp;</DIV>
<TABLE id=3D201179 border=3D0 width=3D"100%" height=3D400>
  <TBODY>
  <TR>
    <TD vAlign=3Dtop width=3D"100%">
      <DIV dir=3Dltr align=3Dleft><FONT color=3D#0000ff size=3D2=20
      face=3DArial></FONT>&nbsp;</DIV>
      <DIV></DIV><A name=3Dtop target=3D_blank></A>
      <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D0 =
cellSpacing=3D0=20
      borderColor=3D#111111 cellPadding=3D0 width=3D"100%">
        <TBODY>
        <TR>
          <TD colSpan=3D3>
            <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D0 =
cellSpacing=3D0=20
            borderColor=3D#111111 width=3D"100%">
              <TBODY>
              <TR>
                <TD width=3D"80%" colSpan=3D2>
                  <TABLE style=3D"BORDER-COLLAPSE: collapse" border=3D1=20
                  cellSpacing=3D0 borderColor=3D#111111 cellPadding=3D0 =
width=3D"19%"=20
                  bgColor=3D#ff0000>
                    <TBODY>
                    <TR>


"Mayayana" <mayayana@invalid.nospam> wrote in message 
news:i6egfn$kq7$1@news.eternal-september.org...
>
> |
> | Is it possible to save the attachment as a file, so that I can resend 
> the
> | attachment as a file in another email ?
> |
>  Why not? It's coming through as the complete text
> of an email. The whole thing is just text. You just have
> to identify the beginning and end of the attached email,
> get that text, and save it.
>
> 


0
fniles
9/12/2010 10:49:21 PM
   You'll have to live with that. The "=" is an escape
character. =3D translates to =. I don't remember why
that happens. You'll have to look it up. The other
changes are a problem with IE/OE. Both mangle HTML
badly without asking. They translate it to MS-specific
format. I really don't know why. It's as though they
load the code into the browser and then reconstitute
it by using the DOM. You can save the attached file
and resend it, but it will arrive with the standard MS
corruption. :)

| The original email looks like this:


0
Mayayana
9/12/2010 10:57:14 PM
Thank you.

Actually now I am only working with the email itself, not even an 
attachment.
So, in your knowledge there is no way to get around the garbage characters ?

"Mayayana" <mayayana@invalid.nospam> wrote in message 
news:i6jlov$c1l$1@news.eternal-september.org...
>   You'll have to live with that. The "=" is an escape
> character. =3D translates to =. I don't remember why
> that happens. You'll have to look it up. The other
> changes are a problem with IE/OE. Both mangle HTML
> badly without asking. They translate it to MS-specific
> format. I really don't know why. It's as though they
> load the code into the browser and then reconstitute
> it by using the DOM. You can save the attached file
> and resend it, but it will arrive with the standard MS
> corruption. :)
>
> | The original email looks like this:
>
> 


0
fniles
9/12/2010 11:22:49 PM
"fniles" <fniles@pfmail.com> wrote in message 
news:uJQHDVqULHA.5660@TK2MSFTNGP05.phx.gbl...
> but there are so many things like "3D2=20","3D0=20", "3D1=20" that when I 
> create an email using that, the email doesn't look like the original.
> Any suggestion ?

http://en.wikipedia.org/wiki/Quoted_printable
http://en.wikipedia.org/wiki/Email#Content_encoding


0
Nobody
9/12/2010 11:47:30 PM
They are important for transmission of the code across the internet and =
for decoding such.  They are not garbage characters.

Take the whole message as a string and then do this:

s1=3Dmessage

s1=3Dreplace(s1,"=3D3D","=3D")

I think the coding is mentioned in RFC822, but I don't remember exactly. =
 You may have to do a similar removal of other characters to fix the =
whole text.

steve

"fniles" <fniles@pfmail.com> wrote in message =
news:%23IdBrFtULHA.4576@TK2MSFTNGP04.phx.gbl...
> Thank you.
>=20
> Actually now I am only working with the email itself, not even an=20
> attachment.
> So, in your knowledge there is no way to get around the garbage =
characters ?
>=20
> "Mayayana" <mayayana@invalid.nospam> wrote in message=20
> news:i6jlov$c1l$1@news.eternal-september.org...
>>   You'll have to live with that. The "=3D" is an escape
>> character. =3D3D translates to =3D. I don't remember why
>> that happens. You'll have to look it up. The other
>> changes are a problem with IE/OE. Both mangle HTML
>> badly without asking. They translate it to MS-specific
>> format. I really don't know why. It's as though they
>> load the code into the browser and then reconstitute
>> it by using the DOM. You can save the attached file
>> and resend it, but it will arrive with the standard MS
>> corruption. :)
>>
>> | The original email looks like this:
>>
>>=20
>=20
>
0
Steve
9/13/2010 12:02:07 AM
Reply:

Similar Artilces:

3 color fill pattern
I am using Pub 2003. I need to create a fill patters using red, white and blue. Is there some way I can create a custom fill pattern or edit an existing 3 color fillpattern thich can be seen using the Preset fill patterns? You can make a pattern by creating red, white and blue stripes, snapped to each other, no line... select the three rectangles, right-click, save as a picture, choose whatever format you want, I think wmf is best but that is my opinion. When you want to use this to fill an object, select the texture option in the fill menu, browse to your saved pattern. -- Mary S...

WSUS 3.0 on SQL 2005 and SBS 2003 R2
Hello all, did some searching on a new situation but did not find specific info... SBS 2003 R2 Premium, ISA installed 2 NICs all patched up... Original installation did not include WSUS 2.0 , we now want to install WSUS 3.0 on the SBS Server but want it to be on SQL Server 2005. How do I create an instance in SQL to prepare it for WSUS 3.0 installation? I also need the DB to be placed on another Drive/Partition if possible. Thanks, Dan "Daniel Jewel" <cyberdudeiq@yahoo.com.br> wrote in message news:eLeT#pYsKHA.4360@TK2MSFTNGP05.phx.gbl... > Hello...

some type of pop up blocker
When i try to access certain areas of CRM 3.0, there is some type of pop up blocker or something that will not let the next window open. I have disabled my pop up blocker but it still occurs. When i put the mouse pointer in front of the pop up blocker message, it states no pop ups were blocked. Some have worked by holding down ctrl or alt but others will not open the new window. Any ideas or suggestions? MT - if you have any toolbars installed in IE (google, MSN, yahoo, etc) uninstall them. there are lots of reported cases where disabling them isn't good enough, you need to un...

hyperlink problem #3
hello, I am wondering, when using the hyperlink formula, is there a way to open a file in a folder regardless of the filename extension. I have file names with these extensions in a folder 000340011.tif 000340012.dgn I am writing a series of hyperlinks and would just like to use the general 000340011 number and have it open regardless of the file name extension. This is what i am currently using =HYPERLINK($E$1 & A1 & ".tif","Click to Open") (A1 in this example is 000340011) I would like to just drag down the hyperlinks, however, this only works if the file ...

Workflow generated pop-up messages
I'm using CRM3.0. I would like to know if it's possible from within workflow code (using c# code) to trigger a message (dialog box) back to the web client. So for example if a field is null, display a pop-up message dialog back to the web client such as: "You must enter a Search name before proceeding" I know it's possible to perform validation from within Workflow manager, however the workflow Manager as far as I know, cannot send dialog box pop-up messages back to a Web client. Note that using client side scripting event triggers is not suitable in this situation, ...

Attachment Missing
Dear Sir, When we are attaching a file in Microsoft outlook there is a complaint from the receiver end stating that the attachment is not being received. But for the receiver who is using Microsoft Outlook they receive the attachment. Regards, B.Vinodh & S.V. Moorthy (EDP) ...

Single user can not send attachments?
E2003 O2003 I have a single user who gets an error when sending attachments to SMTP addresses outside the organization. Other users can forward his email to that same recipient without an issue. The error received is: "You do not have permission to send to this recipient" which as always could mean a million things, all of which do not seem to apply here. On 15 Jan 2007 07:39:45 -0800, mqcarpenter@gmail.com wrote: >E2003 O2003 > >I have a single user who gets an error when sending attachments to SMTP >addresses outside the organization. Other users can forward his e...

Can't get access to my attachments
Hi there. I am wondering if anyone knows how to gain access to personal email attachments when a message appears that says 'oe removed access to the following unsafe attachment'. This is happening with all my attachments, and I know that none of them have a virus. Help would be appreciated. Open Outlook Express and select Tools | Options | Security tab and uncheck the second box from the top concerning attachments. "Michelle" <anonymous@discussions.microsoft.com> wrote in message news:273ae01c463e1$b40bcc40$a601280a@phx.gbl... > Hi there. I am wondering if ...

get an average of 3 cells, if they all have numbers, in excel.
In excel I need to average 3 cells, only if they all contain a number. and if they don't contain a number, don't display an error. "rudyjudy" <rudyjudy@discussions.microsoft.com> wrote: > In excel I need to average 3 cells, only if they all contain a number. > and if they don't contain a number, don't display an error. =IF(COUNT(A1,B2,C3)=3, AVERAGE(A1,B2,C3), "") Unfortunately, you will not see this response unless you use a different NG interface, e.g. Google Groups or a newsreader that access the MSnews server, msnews.microsof...

CRM 3.0 Exchange Mail Router Issue with BCC to CRM Users
I recently ran into an issue where BCC to CRM emails from CRM users to other CRM users (or to themselves) are not able to be posted into CRM. Below is one scenario that can cause this. 1. UserA sends an email in CRM to a customer and CC's UserB 2. UserB then replies to the email and then changes the To address to the customers address and also BCC's himself. 3. The BCC copy is routed back into UserB's mailbox (btw he does this so he can file away a copy of the email in Outlook) and is then forwarded to the crm mailbox by the crm forwarding rule. 4. The CRM Exchange Mail Router ser...

pop sound !
I get a pop sound and I checked to find its a "system notification" well nothing shows up on the screen so where can I check to see what its trying to notify me of ? sixpack wrote: > I get a pop sound and I checked to find its a "system notification" > well nothing shows up on the screen so where can I check to see > what its trying to notify me of ? How did you find it was a 'system notification'? -- Shenan Stanley MS-MVP -- How To Ask Questions The Smart Way http://www.catb.org/~esr/faqs/smart-questions.html So are you te...

Opening a form from a Pop-up
I have a pop-up form I have created so that instructors can double-click on a user number and a New Student form is supposed to open. I have done several pop-up boxes to open other forms and they all seem to work just fine. However, on this particular pop-up, when I double-click a number, I get the following error message "The specified field '[UserNumber]" could refer to more than one table listed in the FROM clause of your SQL statement." I am using a query to draw the information and there is only one table being used in the query. When I check the SQL statemen...

in word, i want to change subsection 3.2 to 4 and continue
not sure what u call the labelling, but below u can see "3 tools" and then 3.1 and 3.2 etc. I want to change 3.3 to the higher level label (like 3, but in this case 4, and update the number going forward). ################################################### 3 Tools There are several intelligent matrix switches on the market and there are many similarities in some of the products available. Two that will be discussed here are the Gigavue-420 from Gigamon and the NetOptics Director. (The NetOptics products are also re-branded be Netscout.) 3.1 Gigavue-420 Key Feature...

Problem adding address to Net Folder calender Outlook 2000 since SP 3
Hello, since I have updated to SP 3 with Outlook 2000, I am not able to add an address to my net folder calender. The button is still active but nothing happens if I press it. Does anybody has the same question and can help me? Thanks for the Reply. Best regards, Mathias Ulmer ...

Software Distribution Service 3.0
Just curious to know if anyone else had issues w/ the MS updates that were pushed down on 4/14/10. Issues I experienced - wireless/keyboard mouse (DELL) stopped working, pc froze upon bootup and in IE it kept throwing my home page into 'offline' mode. Updates that came down for the pc is in question are - KB979309 KB977816 KB979683 kB978601 kB978338 KB980232 KB981349 Thanks!! happycamper105 wrote: > Just curious to know if anyone else had issues w/ the MS updates that were > pushed down on 4/14/10. Nope, none in Windows 7, Vista SP2, nor XP Media...

sum at 3 rows below dynamic range
HI i have a dynamic range created with =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A$1:$A$100),COUNTA(Sheet1!$1:$1)) and i want to sum the values in column c with the sum 3 rows below the end of the dynamic range how do i do this? I'd just use the same criteria, but apply it to column C: either another defined name using this formula: =OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$A$1:$A$100)+3,1) or =SUM(OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$A$1:$A$100)+3,1)) dave h wrote: > > HI > > i have a dynamic range created with > > =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A...

Pop Up comment not popping up
All of the sudden my pop up comments stopped working. In fact my macros have errors and everything is wigging out. Does anyone have any suggestions on what to try? Thanks, Julie ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Software! http://www.ozgrid.com/Services/excel-software-categories.htm ** ...

MS MONEY #3
Hi, is it possible to restore a MS Money 2000 backup file into MS Money 2004? If not how else can one recover this old file into MS Money 2004? You don't "restore" or use a "backup" file. What you need is the *.mny file. Navigate to this with Windows Explorer, double click on the file name and M2004 will fire up and convert the *.mny file. -- Regards Bob Peel, Microsoft MVP - Money Hints/Tips http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny UK Wishes/Suggestions mnyukwsh@microsoft.com "renzo" <anonymous@discussions.microsof...

Exchange and POP email in same profile
Gurus, Is it possible to have the Exchange address and a different POP address exist in the same profile? I ask because, while setting up a new account on a new computer, I've discovered that I cannot have the Exchange mail delivered to "Mailbox - User1" (mail left on server), and at the same time modify the POP account to have its mail delivered to the .pst on the local machine. The dialog box only wants the mail delivered to one location, for ALL accounts. Do I have to use two different profiles in this case? Using Outlook 2003 with Exchange 2003. Thanks! Yes its poss...

best practices for Migration of Microsoft CRM from 1.2 to 3.0
I have the upcoming project to migate Microsoft CRM 1.2 to 3.0. I could setup and configure the Microsoft CRM Demo on my vitrual machine. But, I need a step by step migration plan and instrcutions to accomplish my project. Is there anyone who can help in finding such documentations and give me some advices ? I would really appreciate that. Thank you in advance for your help Here you go. Upgrading Unsupported Microsoft CRM 1.2 Environments to Microsoft CRM 3.0 http://www.microsoft.com/downloads/details.aspx?FamilyId=F3C11BF2-83B2-435C-98D3-63D221C000E7&displaylang=en Upgrading Supp...

Chart
Is there a way to create a chart that has 3 data bars on the primary axis and 1 line on a secondary axis? (Similar to the custom chart LINE-COLUMN ON 2 AXES but with 3 column bars.) Create a column chart from your data. Then, right-click on the series that you want as a line, and choose Chart Type from the menu. Select the Line category, and one of the Line subtypes, click OK. Jon Peltier has instructions for creating your own combination charts: http://www.geocities.com/jonpeltier/Excel/Charts/ComboChart1.html Barb wrote: > Is there a way to create a chart that has 3 data bars o...

Attachment View
Hi Is there a way to attach files without them showing in the body of the text in Outlook 2002? I've just created a new profile, and I'm sure I used to be able to attach them in an "attachmet toolbar" that showed just above the body of the text. I want more "attach" than "Insert" I suppose? Many thanks for any help. Nik. -- ============================================================== Remove S P A M K I L L From my Email address to reply to me Directly ============================================================== P4 3.2 / 512MB Samsung 400...

Attaching files to e-mail
CRM-colleagues, Since last week several users have reported to me that they the file they attached to an e-mail is not attached and stored in CRM; they are using the SFO. This not only happens when they make a new e-mail and attach a file, but also when they are trying to promote a "normal" e-mail with an attachment to a CRM-e-mail. I can see that they didn't forget to attach it: when I look at the notes-tab (or attachments-tab, I don't know exactly how this tab is called in the English version), I can see a thick blue line at the place where the attachment should be...

PoP
I am trying to get email through windows setup how do I locate my POP3 and all the other junk they ask me for? "Owner" <jonathanedwardscagle@gmail.com> wrote in message news:eTNzGkADLHA.3880@TK2MSFTNGP04.phx.gbl... >I am trying to get email through windows setup how do I locate my POP3 and >all the other junk they ask me for? > You will find all the junk you need here: How to set up gmail in Windows Mail: http://mail.google.com/support/bin/answer.py?answer=86383 -- Regards Steve. MS-MVP. MAIL. [DTS] UK. ...

Average Question #3
Dates are in column B Prices are in column C I want cell D1 to show the average price for the last two weeks even though I'm adding new data every day. How do I do that? Hi Jim, Am Sat, 30 Apr 2011 04:34:53 -0700 schrieb JimS: > Dates are in column B > Prices are in column C > > I want cell D1 to show the average price for the last two weeks even > though I'm adding new data every day. =AVERAGE(OFFSET($C$1,COUNTA($C:$C)-1,,-14)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 On Apr 30, 4:51=A0am, Claus Busch <...