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
1319 Views

Similar Articles

[PageSpeed] 36

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:

Excell attachement do no shows up
I got an e-mail in Outlook from someone and it is supposed to have an attachement of something in Excel, but I don't see the attachment anywhere in the Outlook window, and I don't even know where to find the attachment to open it. I do have Office 2003, but never have used Excell. Any advise on how to find the attachemnt? Thanks in advance. Octavio, This question would be better asked in an Outlook newsgroup, not an Excel newsgroup. That said, are you sure that the sender actually attached the file? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, ...

Attachments in e-mail sent to many users
Hello All I am trying to find out how to send an e-mail attachment to a lot of different contacts in CRM 3.0. We were told there was a way but the instructions don't work. The e-mail goes to all the receipents but no attachment is every sent. Can someone please give me directions on how this is done. -- Thanks ...

Beginner
Hi ! I am a beginner to databeses, and particulary to MS Access 2003. (althought I passed the first lessons) I want to make a small database with possibility to grow up. (max. 100 entries for a table) I think that in my case the data must be structured like loop into loop. Like that: Year: 2000 2001 2002 2003 etc. Plant: plant_1 plant_2 plant_3 etc. Generator: gen_1 gen_2 gen_3 etc. So for every Year it must exist some Power Plants, and for every Power Plant it must exist some Generators. I already have ma...

#REF #3
Hi, I'm doing a projection spreadsheet. The new months in diff sheets will be added as and when the actual month passes, ie, up to now i have sheets up to Aug. But in the MAIN sheet, I'm supposed to have months for the whole year up to Dec. Since Sep to Dec don't have equivalent sheets yet, the cells show #Ref since my formula is =Oct!A1. I want to tell the cell to get the amount from "Oct" sheet if there's such a sheet and if not, get the amount from "Sep" sheet. I tried this "=if(Oct!A1="#REF", Sep!A1,Oct!A1)" but it doesn'...

Excel as a database #3
is there any possibility that i used to print a invoice through excel for my product sale. is there any way excel can generate monthly sales book as a database. Please show me any path Thanks in advance. Rao Ratan Singh Rao, Consider Access for this project. To do this properly, you'll likely need a table for your products (your inventory or product line), one for your invoices, one for the items in your invoices, and if you're keeping customer information, one for your customers. Excel is terrific, but a lot of darn work to implement related tables, move records around, ...

2 worksheets--3 questions
Hello! I have a workbook that tracks patients (mothers) and contacts (mom's family members). The mother worksheet is named MAT_INF and the contacts one is named CONTACTS. 1. In MAT_INF, I have a field named CASE_NUMBER. How can I tell this field to automatically start out with a value like "2009-"? An example case number would look like 2009-001 or 2010-099. 2. Once CASE_NUMBER, LAST_NAME_MOM and FIRST_NAME_MOM have been populated by the user in MAT_INF, how can I automate adding those values to the CONTACT sheet, where the corresponding fields are named CASE_N...

installation #3
Installing Office:mac and I typed in my email address wrong and now I can't enroll in passport services. Any ideas? In article <015101c48d40$306c8c20$a401280a@phx.gbl>, "karen Kaul" <anonymous@discussions.microsoft.com> wrote: > Installing Office:mac and I typed in my email address wrong and now I > can't enroll in passport services. Any ideas? Passport isn't required for Office. Registration is mostly a marketing feature - it allows you to sign up for an e-newsletter. You can always go back and get a passport for your correct email address: ...

Out of Memory #3
As a spreadsheet grows, I'm beginning to have occasional "Out of Memory" problems while doing "Paste" operations. Grumble, grumble.... Digging into the problem a bit, I find the INFO statement tells me that I have roughly 50MB available to Excel and that most of it is used up. My question is simply whether there's anything that I can do to increase that 50MB gross amount before I tinker with how Excel is actually using it in the spreadsheet? 1) Would it make any difference if I changed from Excel97 to the current version? Or does the same 50MB limit exist ...

Can i post a Q related to CRM 3.0 here?
Can i post a Q related to CRM 3.0 here? Hi Chong! Chong wrote: > Can i post a Q related to CRM 3.0 here? Until the public v3 beta, please refer questions to the private beta newsgroup. Cheers Arne Janning ...

How do I stop saving attachments with sent mail?
I have many >5 Mb attachments in my sent mail and archive sent mail folders. As I understand it there is no facility to afterwards strip the attachment but keep the mail. So how do I change my Outlook 2003 settings so that I do not save the attachment when sending mail? regards, Beemer To strip the attachment open the message from your Sent Items folder rightclick the attachment and choose Remove. Save and close the message. -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Navigation Pane Tips & Tricks -Create an Office 2003 CD slipstreamed with Se...

Failed to import sample data to CRM 3.0 beta
Hello, I've same big problems while trying to import the sample database with the wizard. Importing the users ist ok but the, the following error occurs (lots of them): Sample Data Wizard started at 14.11.2005 15:19:59 Refresh with new data set started at - 14.11.2005 15:21:57 fetch organization - 14.11.2005 15:22:35 Created Business Units and Users. - 14.11.2005 15:23:59 Imported workflows. - 14.11.2005 15:25:20 Created Emails - 14.11.2005 15:25:20 Created Subjects. - 14.11.2005 15:25:21 Created Territories. - 14.11.2005 15:25:21 Created Teams. - 14.11.2005 15:...

How do i drag and drop an attachment from mail to a task in Entourage?
I want to be able to drag an email or an attachment in mail to a task, calendar, or note. How can I do this in Entourage? ...

Outlook Express attachments #7
Hi, Can anyone help me? My attachments are not accessible. They are recieved but unopenable, these are graphics files such as tiffs and pdfs, even word files are not accessible. They appear as normal until you click on the 'paperclip' at which point they are in faded text and nothing happens when you click on them. I also do not have the attachment icon in my toolbar options. Please help! This is urgent as I rely on attachments for work. Thankyou so much mc wrote: > Hi, > > Can anyone help me? My attachments are not accessible. > They are recieved but unope...

Attachments #3
Hi, I have a question, where are allocated the attached files on CRM 3.0? Thanks. Ing. Mauricio Ramírez Consultor CRM MultiConsulting S.A. de C.V. http://www.multiconsulting.com.mx ...

product key #3
Is there anything I can do if I've lost the cd-case with the product key on it? I had to reinstall windows and now I can't get publisher back on my computer. Call microsoft Scott wrote: > Is there anything I can do if I've lost the cd-case with > the product key on it? I had to reinstall windows and now > I can't get publisher back on my computer. (425) 635-7056 -- JoAnn Two things are aesthetically perfect in the world - the clock and the cat. --Emile-August Chartier "Steve in NC" <dtp2webSPAM@netscape.net> wrote in ...

autocomplete email addresses #3
OL 2002 SP3, Win XP HE Hi, I would like to delete the file used by OL to "autocomplete" with email addresses the "To:" field in email massages--(only that field/function) as I would like to start a new one fresh. Can anyone tell me where to find it--I forget its name and location. Tx. S find the .NK2 file under C:\Documents and Settings\USER\Application Data\Microsoft\Outlook Rename the old file (just to have a backup), or you can delete all together. Next time Outlook restarts it will build a new .NK2 file. Hope this helps -MJM find the .NK2 file under C:\Documents a...

Cell Formatting #3
I want c2 to have the first name of an employee preceeded by a comma automatically.... ,MARY. The first name will change but the , always needs to be there. Is there a way to do that? And is there a way to force all users of the report to type in capital letters? -- Tralee6 ------------------------------------------------------------------------ Tralee6's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29273 View this thread: http://www.excelforum.com/showthread.php?threadid=490146 On Fri, 2 Dec 2005 07:50:26 -0600, Tralee6 <Tralee6.1zf11m_1133531700.63...

Address book problems #3
How do I move the address book from Outlook to Outlook Express? Somehow, I've lost the Outlook Express address listings completely... Cindy Outlook does not use an address book. You would have to export your Contacts Folder into some format that OE can import, such as CSV. -- Russ Valentine [MVP-Outlook] "Cindy Forman" <cforman@fcol.com> wrote in message news:upFFdhcREHA.556@TK2MSFTNGP10.phx.gbl... > How do I move the address book from Outlook to Outlook Express? Somehow, > I've lost the Outlook Express address listings completely... > > Cindy > &g...

sending attachments #6
I am using Outlook 2003. As my normal user account, I am sending an email with an attachment and the recipient receives the email but not the attachment. When I send the same email as the administrator, the recipient gets the attachment. Your thoughts? thx alex ...

Multiple Attachments using command line swtches
I'm trying to figure out a way to launch a new e-mail message, with multiple file attachments, from the command line. I know how to do it with a single attachment, using the following method: outlook.exe /a c:\document.doc I've tried a number of permutations of this syntax to try to attach multiple files, such as using quotes, commas, semi-colons, but none of them seem to work. Any ideas? TIA - Dave You can't. You might want to use a compressing program first that generates a single .zip file out of all the attachments and attach that by the command line switch. -- Robe...

pdf attachment in outlook 2003 does not show up but shows in OWA a
TWe have exchange 2007 server and Blackberry enterprise server. outlook 2003 is client software. When we receive pdf attachment from a particular company, we can not see those attachment in outlook but can find them in OWA and in blackberry. I know attachments are in the mailbox but not showing for some reason in outlook. Can any one please tell me how to fix this issue? Thanks. -- Dipti Do you see them if you hit forward? Are any other attachments affected? -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Cente...

Gift Cards #3
I am looking to create gift cards. Cards that customers can buy as gifts, add any amount of credit on them. I would like wither bar code or magnetic swipe. Is this possible to do without having to use the cervice of an outside company (beyond making the cards)? Yes it is called vouchers. Built in to RMS can be used with barcodes as well as mag stripe. "Willie" <Willie@discussions.microsoft.com> wrote in message news:CF668839-DBDF-4E09-805C-3904CF7B82CE@microsoft.com... >I am looking to create gift cards. Cards that customers can buy as gifts, >add > any amoun...

Upgrading CRM 3.0 from SQL 2000 to SQL 2005
Hi, We are planning to upgrade CRM 3 to CRM 4 but currently our CRM 3 runs on SQL 2000 and according to the upgrade path CRM4 requires SQL 2005! So, what is the process of upgrading SQL 2000 to SQL 2005 for CRM? I have found the method of upgrading SQL itself whcih basically entails installing 2005 SQL then moving the 2000 databases to the 2005 instatnce, but will this work OK for CRM as well? Are there any other steps/dependancies than need to be considered. Thanks in advance (of a long night upgrading!) Nik Upgradation is SQL Server 2005 installation which will upgrade from SQL 200...

email broken up into multiple attached text files on emails with multiple images
Hi There, I am encountering a fairly annoying problem with emails I am receiving with Outlook 2003 and that that have been sent from a Macintosh using the latest version of AppleMail. The emails have multiple image attachements (all coming though fine, although not in line which is how they have been sent) but the text of the email is broken up into text files that are attached. The first section of text in the email (ie before the first image) comes through fine, but the text after the first image in in an attachment, then the text after the second image is in another, seperate at...

Cwnd::CreateEx creates a window under Win2k that looks like Win 3.1!
This is a weird one. I'm creating a window for a class derived from CWnd using CreateEx. The window is created and it is perfectly usable. However, all of its widgets, and its style in general is that of Windows 3.1! I don't understand how this can be. My code: CString my_class = AfxRegisterWndClass(CS_VREDRAW | CS_HREDRAW, ::LoadCursor(NULL, IDC_ARROW), (HBRUSH) ::GetStockObject(WHITE_BRUSH), ::LoadIcon(NULL, IDI_APPLICATION)); BOOL status = mInterpreter->CreateEx( WS_EX_APPWINDOW|WS_EX_CLIENTEDGE| WS_EX_WINDOWEDGE, my_class, _T("Python Interpreter"), W...