Permanently deleting mail from deleted items folder?

Any one found a way of permanently deleting obvious junk mail from deleted
items folder yet or is there any Knowledge Base article on it yet beyond the
one which say that this facility in Office or Outlook doesn't work properly?


0
3/3/2004 9:12:18 PM
outlook 87535 articles. 11 followers. Follow

14 Replies
694 Views

Similar Articles

[PageSpeed] 16

Generally, emptying the Deleted Items folder permanently deletes the
contents.  I'm curious, which KB article are you referring to that "say that
this facility in Office or Outlook doesn't work properly"?

Hal
-- 
Hal Hostetler, CPBE -- hhh@kvoa.com
Senior Engineer/MIS -- MS MVP-DTS -- WA7BGX
http://www.kvoa.com -- "When News breaks, we fix it!"
KVOA Television, Tucson, AZ.   NBC   Channel 4
Got Blues? - www.badnewsbluesband.com

"Licensed to Quill" <fountainpen@amexol.net> wrote in message
news:uVxvoRWAEHA.3184@TK2MSFTNGP09.phx.gbl...
> Any one found a way of permanently deleting obvious junk mail from deleted
> items folder yet or is there any Knowledge Base article on it yet beyond
the
> one which say that this facility in Office or Outlook doesn't work
properly?
>
>


0
hhh6225 (363)
3/4/2004 5:50:54 AM
On Wed, 3 Mar 2004 22:50:54 -0700, "Hal Hostetler [MVP DTS]"
<hhh@kvoa.com> wrote in microsoft.public.outlook,
microsoft.public.office.setup, microsoft.public.outlook.general,
microsoft.public.outlook.installation,
microsoft.public.mail.connectivity:

>Generally, emptying the Deleted Items folder permanently deletes the
>contents.

I thought they can still be retrieved from the dumpster (if the server
is configured that way)?

>Licensed to Quill" <fountainpen@amexol.net> wrote in message
>news:uVxvoRWAEHA.3184@TK2MSFTNGP09.phx.gbl...
>> Any one found a way of permanently deleting obvious junk mail from deleted
>> items folder yet or is there any Knowledge Base article on it yet beyond the
>> one which say that this facility in Office or Outlook doesn't work properly?

Which KB article? Have you tried Tools/Recover Deleted Items.../Purge
Selected Items ?

-- 
Michael Bednarek  http://mbednarek.com/  "POST NO BILLS"
0
mb6705 (20)
3/4/2004 6:33:59 AM
> I thought they can still be retrieved from the dumpster (if the server
> is configured that way)?

If using an Exchange server configured for recover deleted, users can't 
disable or bypass it, only empty it regularly.

-- 
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com


"Michael Bednarek" <mb@dev.nul.com> wrote in message 
news:q3jd40dktgijoubgmklurirasc5lfh1c8o@4ax.com...
> On Wed, 3 Mar 2004 22:50:54 -0700, "Hal Hostetler [MVP DTS]"
> <hhh@kvoa.com> wrote in microsoft.public.outlook,
> microsoft.public.office.setup, microsoft.public.outlook.general,
> microsoft.public.outlook.installation,
> microsoft.public.mail.connectivity:
>
>>Generally, emptying the Deleted Items folder permanently deletes the
>>contents.
>
> I thought they can still be retrieved from the dumpster (if the server
> is configured that way)?
>
>>Licensed to Quill" <fountainpen@amexol.net> wrote in message
>>news:uVxvoRWAEHA.3184@TK2MSFTNGP09.phx.gbl...
>>> Any one found a way of permanently deleting obvious junk mail from 
>>> deleted
>>> items folder yet or is there any Knowledge Base article on it yet beyond 
>>> the
>>> one which say that this facility in Office or Outlook doesn't work 
>>> properly?
>
> Which KB article? Have you tried Tools/Recover Deleted Items.../Purge
> Selected Items ?
>
> -- 
> Michael Bednarek  http://mbednarek.com/  "POST NO BILLS" 


0
monkey1 (121)
3/4/2004 7:37:37 AM
On Thu, 4 Mar 2004 02:37:37 -0500, "Diane Poremsky [MVP]"
<monkey@slipstick.com.invalid> wrote in
microsoft.public.mail.connectivity:

>> I thought they can still be retrieved from the dumpster (if the server
>> is configured that way)?
>
>If using an Exchange server configured for recover deleted, users can't 
>disable or bypass it, only empty it regularly.

I didn't say users could disable or bypass the dumpster. I was
commenting on Hal Hostetler's remark:
>Generally, emptying the Deleted Items folder permanently deletes the
>contents.
which I didn't think was quite correct and prompted me to note that
users can indeed recover items even if they had been emptied from the
Deleted Items folder.

To answer the OP's question how to permanently delete items from the
Deleted Items folder: if the Exchange server is configured with a
non-zero "Deleted items retention time": only by purging hidden items
through Outlook's "Recover Deleted Items..."/Purge command; AFAIK this
action cannot be scripted in VBA.

-- 
Michael Bednarek   http://mbednarek.com/   "POST NO BILLS"
0
Michael
3/4/2004 1:48:31 PM
Alternatively, hold the SHIFT key down as you delete the message from your
In box will bypass the Deleted folder and permanently remove the message.

Hope this helps.

Martin


"Michael Bednarek" <mb at mbednarek dot com> wrote in message
news:ng6e40tgpr009vn5iogiued0ubsm9nrv6g@4ax.com...
> On Thu, 4 Mar 2004 02:37:37 -0500, "Diane Poremsky [MVP]"
> <monkey@slipstick.com.invalid> wrote in
> microsoft.public.mail.connectivity:
>
> >> I thought they can still be retrieved from the dumpster (if the server
> >> is configured that way)?
> >
> >If using an Exchange server configured for recover deleted, users can't
> >disable or bypass it, only empty it regularly.
>
> I didn't say users could disable or bypass the dumpster. I was
> commenting on Hal Hostetler's remark:
> >Generally, emptying the Deleted Items folder permanently deletes the
> >contents.
> which I didn't think was quite correct and prompted me to note that
> users can indeed recover items even if they had been emptied from the
> Deleted Items folder.
>
> To answer the OP's question how to permanently delete items from the
> Deleted Items folder: if the Exchange server is configured with a
> non-zero "Deleted items retention time": only by purging hidden items
> through Outlook's "Recover Deleted Items..."/Purge command; AFAIK this
> action cannot be scripted in VBA.
>
> --
> Michael Bednarek   http://mbednarek.com/   "POST NO BILLS"


0
MartinC (17)
3/4/2004 2:36:06 PM
On Thu, 4 Mar 2004 14:36:06 -0000, "Martin C" <MartinC@invalid.com>
wrote in microsoft.public.mail.connectivity:

>Alternatively, hold the SHIFT key down as you delete the message from your
>In box will bypass the Deleted folder and permanently remove the message.

For the 3rd time: Not if the Exchange server is configured with a
non-zero "Deleted items retention time"; then items must be purged
through the command Tools/Recover Deleted Items...

>"Michael Bednarek" <mb at mbednarek dot com> wrote in message
>news:ng6e40tgpr009vn5iogiued0ubsm9nrv6g@4ax.com...
>> On Thu, 4 Mar 2004 02:37:37 -0500, "Diane Poremsky [MVP]"
>> <monkey@slipstick.com.invalid> wrote in
>> microsoft.public.mail.connectivity:
>>
>> >> I thought they can still be retrieved from the dumpster (if the server
>> >> is configured that way)?
>> >
>> >If using an Exchange server configured for recover deleted, users can't
>> >disable or bypass it, only empty it regularly.
>>
>> I didn't say users could disable or bypass the dumpster. I was
>> commenting on Hal Hostetler's remark:
>> >Generally, emptying the Deleted Items folder permanently deletes the
>> >contents.
>> which I didn't think was quite correct and prompted me to note that
>> users can indeed recover items even if they had been emptied from the
>> Deleted Items folder.
>>
>> To answer the OP's question how to permanently delete items from the
>> Deleted Items folder: if the Exchange server is configured with a
>> non-zero "Deleted items retention time": only by purging hidden items
>> through Outlook's "Recover Deleted Items..."/Purge command; AFAIK this
>> action cannot be scripted in VBA.

-- 
Michael Bednarek  http://mbednarek.com/  "POST NO BILLS"
0
mb6705 (20)
3/5/2004 2:11:20 AM
Sorry for any confusion I  may have caused: I was being a bit simpler than
people think

All I want to do is set up a rule within outlook to read junk mail that
comes into the inbox when it is received, delete it,  and then have outlook
automatically delete it (if it sees  AS SEEN ON OPRAH for example, or VIAGRA
etc or MORTGAGE ) from the deleted items folder rather than keep it for you
to view and then delete manually or by exiting the program.


"Michael Bednarek" <mb@dev.nul.com> wrote in message
news:n7of40dkc04irr01cbl7a5050sncu9lcof@4ax.com...
> On Thu, 4 Mar 2004 14:36:06 -0000, "Martin C" <MartinC@invalid.com>
> wrote in microsoft.public.mail.connectivity:
>
> >Alternatively, hold the SHIFT key down as you delete the message from
your
> >In box will bypass the Deleted folder and permanently remove the message.
>
> For the 3rd time: Not if the Exchange server is configured with a
> non-zero "Deleted items retention time"; then items must be purged
> through the command Tools/Recover Deleted Items...
>
> >"Michael Bednarek" <mb at mbednarek dot com> wrote in message
> >news:ng6e40tgpr009vn5iogiued0ubsm9nrv6g@4ax.com...
> >> On Thu, 4 Mar 2004 02:37:37 -0500, "Diane Poremsky [MVP]"
> >> <monkey@slipstick.com.invalid> wrote in
> >> microsoft.public.mail.connectivity:
> >>
> >> >> I thought they can still be retrieved from the dumpster (if the
server
> >> >> is configured that way)?
> >> >
> >> >If using an Exchange server configured for recover deleted, users
can't
> >> >disable or bypass it, only empty it regularly.
> >>
> >> I didn't say users could disable or bypass the dumpster. I was
> >> commenting on Hal Hostetler's remark:
> >> >Generally, emptying the Deleted Items folder permanently deletes the
> >> >contents.
> >> which I didn't think was quite correct and prompted me to note that
> >> users can indeed recover items even if they had been emptied from the
> >> Deleted Items folder.
> >>
> >> To answer the OP's question how to permanently delete items from the
> >> Deleted Items folder: if the Exchange server is configured with a
> >> non-zero "Deleted items retention time": only by purging hidden items
> >> through Outlook's "Recover Deleted Items..."/Purge command; AFAIK this
> >> action cannot be scripted in VBA.
>
> -- 
> Michael Bednarek  http://mbednarek.com/  "POST NO BILLS"


0
3/5/2004 4:11:52 AM
One of the options in the Outlook 2000+ Rules Wizard is to "Permanently
Delete" an item that matches the rule.  This would, however, not be a
permanent delete per the previous discussion on Exchange Server's Deleted
Item Retention setting.  Items so deleted could still be recovered within
the retention period if the "DumpsterAlwaysOn" registry modification is
made.

Hal
-- 
Hal Hostetler, CPBE -- hhh@kvoa.com
Senior Engineer/MIS -- MS MVP-DTS -- WA7BGX
http://www.kvoa.com -- "When News breaks, we fix it!"
KVOA Television, Tucson, AZ.   NBC   Channel 4
Got Blues? - www.badnewsbluesband.com

"Licensed to Quill" <fountainpen@amexol.net> wrote in message
news:%23BgIzgmAEHA.132@TK2MSFTNGP10.phx.gbl...
> Sorry for any confusion I  may have caused: I was being a bit simpler than
> people think
>
> All I want to do is set up a rule within outlook to read junk mail that
> comes into the inbox when it is received, delete it,  and then have
outlook
> automatically delete it (if it sees  AS SEEN ON OPRAH for example, or
VIAGRA
> etc or MORTGAGE ) from the deleted items folder rather than keep it for
you
> to view and then delete manually or by exiting the program.
>
>
> "Michael Bednarek" <mb@dev.nul.com> wrote in message
> news:n7of40dkc04irr01cbl7a5050sncu9lcof@4ax.com...
> > On Thu, 4 Mar 2004 14:36:06 -0000, "Martin C" <MartinC@invalid.com>
> > wrote in microsoft.public.mail.connectivity:
> >
> > >Alternatively, hold the SHIFT key down as you delete the message from
> your
> > >In box will bypass the Deleted folder and permanently remove the
message.
> >
> > For the 3rd time: Not if the Exchange server is configured with a
> > non-zero "Deleted items retention time"; then items must be purged
> > through the command Tools/Recover Deleted Items...
> >
> > >"Michael Bednarek" <mb at mbednarek dot com> wrote in message
> > >news:ng6e40tgpr009vn5iogiued0ubsm9nrv6g@4ax.com...
> > >> On Thu, 4 Mar 2004 02:37:37 -0500, "Diane Poremsky [MVP]"
> > >> <monkey@slipstick.com.invalid> wrote in
> > >> microsoft.public.mail.connectivity:
> > >>
> > >> >> I thought they can still be retrieved from the dumpster (if the
> server
> > >> >> is configured that way)?
> > >> >
> > >> >If using an Exchange server configured for recover deleted, users
> can't
> > >> >disable or bypass it, only empty it regularly.
> > >>
> > >> I didn't say users could disable or bypass the dumpster. I was
> > >> commenting on Hal Hostetler's remark:
> > >> >Generally, emptying the Deleted Items folder permanently deletes the
> > >> >contents.
> > >> which I didn't think was quite correct and prompted me to note that
> > >> users can indeed recover items even if they had been emptied from the
> > >> Deleted Items folder.
> > >>
> > >> To answer the OP's question how to permanently delete items from the
> > >> Deleted Items folder: if the Exchange server is configured with a
> > >> non-zero "Deleted items retention time": only by purging hidden items
> > >> through Outlook's "Recover Deleted Items..."/Purge command; AFAIK
this
> > >> action cannot be scripted in VBA.
> >
> > -- 
> > Michael Bednarek  http://mbednarek.com/  "POST NO BILLS"
>
>


0
hhh6225 (363)
3/5/2004 5:19:37 AM
On Thu, 4 Mar 2004 23:11:52 -0500, "Licensed to Quill"
<fountainpen@amexol.net> wrote in microsoft.public.mail.connectivity:

>Sorry for any confusion I  may have caused: I was being a bit simpler than
>people think
>
>All I want to do is set up a rule within outlook to read junk mail that
>comes into the inbox when it is received, delete it,  and then have outlook
>automatically delete it (if it sees  AS SEEN ON OPRAH for example, or VIAGRA
>etc or MORTGAGE ) from the deleted items folder rather than keep it for you
>to view and then delete manually or by exiting the program.

I don't think this can be done directly in VBA, only in CDO. For an
example, see <http://www.cdolive.com/deletespammessage.htm>.

OTOH, it should be possible to do it in two steps in VBA: first delete
the item from your Inbox, then from the Deleted Items folder.

Good luck.

-- 
Michael Bednarek  http://mbednarek.com/  "POST NO BILLS"
0
mb6705 (20)
3/5/2004 5:26:03 AM
Yes, that was the whole problem which MS's programmers can't seem to to
address (or just possibly are being paid NOT to address, -  it cant be that
difficult to get a feature built into the program which doesnt work to work
properly): You CAN set up a rule which deletes junk mail by identifying
words in the subject matter and it DOES give you the option of permanently
deleting the message when it reaches the deleted items folder but that
function has never in the past worked.

I wonder if Hal is now right in saying that suddenly it does work and MS has
never released info on this?

I dont care about anyone seeing supposedly confidential info in my pst file
or deleting them therefrom, all I want is something simpler: I want (as do
most other people) my folders NOT to be filled up with obvious junk mail.

 And I have another problem which exacerbates this one which I have asked
about but which no one seemed to know the answer which was that my rules (I
cant figure out which one or ones) apply themselves to each message and
CREATE two or three versions of each piece of junk mail and then duly dump
them in my deleted items folder so it is important to have Outlook
permanently delete them so that I don't have to see/check that I dont want
to buy any prescription medications I don't need or see something which had
been on Oprah whoeversheis

Licensed to Quill


"Michael Bednarek" <mb@dev.nul.com> wrote in message
news:ci3g40972aoe95ks7ofe2abtf3ug69rbrh@4ax.com...
> On Thu, 4 Mar 2004 23:11:52 -0500, "Licensed to Quill"
> <fountainpen@amexol.net> wrote in microsoft.public.mail.connectivity:
>
> >Sorry for any confusion I  may have caused: I was being a bit simpler
than
> >people think
> >
> >All I want to do is set up a rule within outlook to read junk mail that
> >comes into the inbox when it is received, delete it,  and then have
outlook
> >automatically delete it (if it sees  AS SEEN ON OPRAH for example, or
VIAGRA
> >etc or MORTGAGE ) from the deleted items folder rather than keep it for
you
> >to view and then delete manually or by exiting the program.
>
> I don't think this can be done directly in VBA, only in CDO. For an
> example, see <http://www.cdolive.com/deletespammessage.htm>.
>
> OTOH, it should be possible to do it in two steps in VBA: first delete
> the item from your Inbox, then from the Deleted Items folder.
>
> Good luck.
>
> -- 
> Michael Bednarek  http://mbednarek.com/  "POST NO BILLS"


0
3/6/2004 2:22:41 PM
"Licensed to Quill" <fountainpen@amexol.net> wrote in message news:<#Z5wza4AEHA.444@TK2MSFTNGP11.phx.gbl>...
> Yes, that was the whole problem which MS's programmers can't seem to to
> address (or just possibly are being paid NOT to address, -  it cant be that
> difficult to get a feature built into the program which doesnt work to work
> properly): You CAN set up a rule which deletes junk mail by identifying
> words in the subject matter and it DOES give you the option of permanently
> deleting the message when it reaches the deleted items folder but that
> function has never in the past worked.
> 
> I wonder if Hal is now right in saying that suddenly it does work and MS has
> never released info on this?
> 
> I dont care about anyone seeing supposedly confidential info in my pst file
> or deleting them therefrom, all I want is something simpler: I want (as do
> most other people) my folders NOT to be filled up with obvious junk mail.
> 
>  And I have another problem which exacerbates this one which I have asked
> about but which no one seemed to know the answer which was that my rules (I
> cant figure out which one or ones) apply themselves to each message and
> CREATE two or three versions of each piece of junk mail and then duly dump
> them in my deleted items folder so it is important to have Outlook
> permanently delete them so that I don't have to see/check that I dont want
> to buy any prescription medications I don't need or see something which had
> been on Oprah whoeversheis
> 

 Oprah's the world's ONLY black billionaire.
0
3/6/2004 7:10:38 PM
OT

(sorry if I had never heard of him)

"cris" <turpentine26@hotmail.com> wrote in message
news:be5f716f.0403061110.5af1b913@posting.google.com...
> "Licensed to Quill" <fountainpen@amexol.net> wrote in message
news:<#Z5wza4AEHA.444@TK2MSFTNGP11.phx.gbl>...
> > Yes, that was the whole problem which MS's programmers can't seem to to
> > address (or just possibly are being paid NOT to address, -  it cant be
that
> > difficult to get a feature built into the program which doesnt work to
work
> > properly): You CAN set up a rule which deletes junk mail by identifying
> > words in the subject matter and it DOES give you the option of
permanently
> > deleting the message when it reaches the deleted items folder but that
> > function has never in the past worked.
> >
> > I wonder if Hal is now right in saying that suddenly it does work and MS
has
> > never released info on this?
> >
> > I dont care about anyone seeing supposedly confidential info in my pst
file
> > or deleting them therefrom, all I want is something simpler: I want (as
do
> > most other people) my folders NOT to be filled up with obvious junk
mail.
> >
> >  And I have another problem which exacerbates this one which I have
asked
> > about but which no one seemed to know the answer which was that my rules
(I
> > cant figure out which one or ones) apply themselves to each message and
> > CREATE two or three versions of each piece of junk mail and then duly
dump
> > them in my deleted items folder so it is important to have Outlook
> > permanently delete them so that I don't have to see/check that I dont
want
> > to buy any prescription medications I don't need or see something which
had
> > been on Oprah whoeversheis
> >
>
>  Oprah's the world's ONLY black billionaire.


0
3/6/2004 7:42:34 PM
On Sat, 6 Mar 2004 09:22:41 -0500, "Licensed to Quill"
<fountainpen@amexol.net> wrote in microsoft.public.mail.connectivity:

[snip]
> And I have another problem which exacerbates this one which I have asked
>about but which no one seemed to know the answer which was that my rules (I
>cant figure out which one or ones) apply themselves to each message and
>CREATE two or three versions of each piece of junk mail and then duly dump
>them in my deleted items folder so it is important to have Outlook
>permanently delete them
[snip]

I too found that certain rules can indeed create multiple copies of a
message. Try adding "Stop processing more rules" to all rules.

-- 
Michael Bednarek   http://mbednarek.com/   "POST NO BILLS"
0
Michael
3/7/2004 5:39:07 AM
Hey, that works pretty well, although when I changed the rule it suddenly
started telling me (on one of my messages) that it can't delete messages
which say $$$ in the subject matter (which was a slightly pathetic way they
used to use about two years ago of getting your attention to a piece of
spam)

Many thanks

L2Q


"Michael Bednarek" <mb at mbednarek dot com> wrote in message
news:02dl40dc5qd7htt42im8n39so0cu63un75@4ax.com...
> On Sat, 6 Mar 2004 09:22:41 -0500, "Licensed to Quill"
> <fountainpen@amexol.net> wrote in microsoft.public.mail.connectivity:
>
> [snip]
> > And I have another problem which exacerbates this one which I have asked
> >about but which no one seemed to know the answer which was that my rules
(I
> >cant figure out which one or ones) apply themselves to each message and
> >CREATE two or three versions of each piece of junk mail and then duly
dump
> >them in my deleted items folder so it is important to have Outlook
> >permanently delete them
> [snip]
>
> I too found that certain rules can indeed create multiple copies of a
> message. Try adding "Stop processing more rules" to all rules.
>
> -- 
> Michael Bednarek   http://mbednarek.com/   "POST NO BILLS"


0
3/7/2004 10:33:46 PM
Reply:

Similar Artilces:

item picture
Is there a way to get an items picture on a report? I use the item price list report and export it to HTML to get my items on my web page. This works fine, however I would like to include the items picture also but I don't see that as a field to include on the report. Is anyone doing this or know of a way to do this? Thanks, Craig You could add the Item.PictureName field to the report. Search the newsgroup and you should find several recent examples of adding a column to a report. This isn't going to be much help though as this is only going to include the Filename of the ...

message shows horizontal and cannot be moved so cannot delete
when double clicking a message it shows up too wide and I cannot move it or shrink it so I can get to the right hand side to move it up or down or to delete it..How can I get it back to the right size?? Panda;1246564 Wrote: > when double clicking a message it shows up too wide and I cannot move it > or > shrink it so I can get to the right hand side to move it up or down or > to > delete it..How can I get it back to the right size?? Click and drag to where you can see it by clicking in the top of the window in which the message is showing. -- rhlhamlet ...

Delete key in open message
In Outlook 2003, is there a way to get the delete key to delete a message you've opened, just as it does if you're reading it in the preview pane? In other words, I'd like to open a message with the enter key, delete it with the delete key instead of having to click the "X", return to the message list, open the next message, etc. ==================================== Larry Wahlers, Systems Specialist Concordia Technologies The Lutheran Church - Missouri Synod ...

adding a signature/stationary to CRM mail
We have been asked by our users to set up email with a default signature. Does CRM-SFO allow for this? If so, how do we go abbout setting up users with them? SFO doesn't have a signature feature, but you could add the signature to a blank email template as a workwaround. >-----Original Message----- >We have been asked by our users to set up email with a default >signature. Does CRM-SFO allow for this? If so, how do we go abbout >setting up users with them? >. > ...

data file to send and receive mail cannot be found
I accidentally deleted a Microsoft Exchange account from Outlook. Now I get "Cannot create an email message because the data file to send and receive messages could not be found. To add a data file such as a personal folder file, double-click on the Mail icon in Control Panel." What should I do? Thank you "matthewcrook" <matthewcrook@discussions.microsoft.com> wrote in message news:EB4D4D31-9435-483C-B847-69B1015A11A9@microsoft.com... >I accidentally deleted a Microsoft Exchange account from Outlook. Now I get > "Cannot create an email m...

Double Items In List
Hi, I am looking for some help with this; I have a worksheet with up to 2000 lines, the first column contains numbers, the entries in this column are either 7 or 8 digit numbers, by formatting it with 0#.###.### I force it to be a 8 digit number in case a 7 digit number has been entered. The worksheet is sorted on this column, I want the first 3 digits of each number being copied into another worksheet without copying double items. ie. original column the copied column should contain 01.123.456 01.1 01.155.897 02.5 01.199.852 02.6 02.527.255 ...

E-mail query to recipients in table
Hello, I have created a database in Access 2003 with a table of suppliers and a table containing my orders with those suppliers. Now suppose I want to send out lists with outstanding orders to those individual suppliers as a sort of reminder, only containing their "own" orders. I have written following code: --- Dim rs As Recordset Set rs = DBEngine(0)(0).OpenRecordset("tblSuppliers") Do While Not rs.EOF If DCount("[SupplierID]", "qryOutstanding", "[SupplierID] = '" & rs.Fields(0) & "'") <...

item sold/on hand report
I can't find a report that will give me qty sold and qty on hand for a specific item or supplier. Anyone know of one? Thank you have you tried the item movement report with criteria being supplier? -- Elizabeth M. "Jeff" <anonymous@discussions.microsoft.com> wrote in message news:249c01c4701e$eacd9d50$a301280a@phx.gbl... > I can't find a report that will give me qty sold and qty > on hand for a specific item or supplier. Anyone know of > one? > > Thank you > yes, unfortunately, the item movement report does not give you the option of showi...

How to delete digits after period
I am working on a price list and want to delete the multiple digit after the period and permanmently on keep two. I know about th increase and decrease decimal. But I need to permanently delete th digits. Can anyone help -- Rogerm ----------------------------------------------------------------------- Rogermb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1673 View this thread: http://www.excelforum.com/showthread.php?threadid=31936 Hi =ROUND(A1,0) -- Regards Frank Kabel Frankfurt, Germany "Rogermb" <Rogermb.1g4s7z@excelforum-nospam.com> sch...

Remake deleted account in Windows Live Mail
Hi, is it possible to remae an acount I have removed from Windows Live Mail ? Or just a possibility to import the emails there was in the 2 account I removed ? I did not think the program would delete the emails, when I removed the account settings. Hope someone can help, as there are some emails I would like to save. Best wishes Steen Did you look on the web access for those accounts to see if the emails are still out there? "steendk" <steendk@discussions.microsoft.com> wrote in message news:652B3826-1F5C-4309-99DC-7EE579109C44@microsoft.com......

user shares vs. folder redirection
Just finished a brute force migration of SBS 2003 to 2008 and I am wondering if there is any reason why I would want to place the old user shares files into the new user shares folder. I should have prefaced by saying that the only reason they used the user shares in sbs 03 is because someone never setup redirection. Instead just told them to copy everything into their ..lnk folder. So I am thinking since these are not files that they cared to share with others anyway why can't I just copy them into their redirected folders? I would just put the files wherever the u...

Quote-like parent-child mail merge possible on custom entities?
I have a client on CRM Online who needs to be able to print out a form document for a CRM record that includes header information from the record as well as a listing of child records from a one to many child entity. The Report Wizard does not give us nearly enough control to print the document in the required form format. The Quote, Order, and Invoice mail merges in CRM do something very similar to what we are trying to accomplish, so apparently it is possible to get this done in CRM. Does anyone know how to accomplish a new mail merge template in CRM that merges a custom parent rec...

Outlook favorite folders keep disappearing!
Hi, As per subject line - my Outlook Favorite folders keep disappearing! I keep replacing them with the shortcuts back to the original folders, but every now and again (read: perhaps a few times per day) they disappear and I'm just left with the Unread Mail folder.... Any ideas? Lee I have just the opposite problem. I have all of my Favorite Folders EXCEPT my Unread E-Mail Folder disappeared yesterday so now I'm missing e-mails right and left. Any ideas how I can recover it? "Lee Sainsbury" wrote: > Hi, > > As per subject line - my Outlook Favorite fold...

Public Folder Migration #5
I want to migrate my Public Folders to a new Exchange server mail server. I have migrated my mailboxes using ExMerge, however, I have no idea on how to migrate my Public Folders. Please help me. Thanks, S Add Your new exchange server also to public folder replication server list. Once it get replicated you can remove old exchange server. And all public folder will be by default Mail enabled public folders when you migrate. Regards, Mallika. "Skc" wrote: > I want to migrate my Public Folders to a new Exchange server mail server. > > I have migrated my mailboxes us...

Choose Profile Message When Sending Report to Mail
We are having a problem with Mail Configuration. We are using GP published through Citrix. We log into the desktop as a particular user, and configure the default Mail Profile using Mail in the Control Panel, which is Outlook. The problem is that whenever we Print a report to Screen, then go Send Mail as text, it pops up with the Choose Mail dialog. After clicking on Options (on the Dialog) you can check "Default Profile" and it sends the email. Yet when we close GP and re-open it, the Choose Profile dialog appears again. Any ideas why this is happening? Regards Konrad Konr...

No Mail Delivery #2
possible duplicate-original didn't show in 30 minutes. Last night I installed SP1 to my exchange server, it went through the install and at the end informed me that the services could not install causing the install to fail. Server roobooted fine. The next day now no mail is being delivered internally or externally. When I go to system manager under that server and qeues most of the states are set to retry. I have under local delivery on the default smtp virtual server the state is retry with several hundred messages awaiting delivery. I have stopped and started the smtp se...

cannot send or receive mail
I configured my Outlook 2003 the same as my Outlook express that has been running successfully for years. I can create mail and it remains in the outbox even after send/receive button is pushed. No error message at all. Just no action and when I close it I do get told that there are messages waiting to be sent. ...

Looking for a quick way to create a bunch of labels for annual mailing to diverse contacts
Using Office 2004 (11.2), I have numerous contacts that are part of diverse categories (some have not been categorized yet) I would like to create mailing labels for the annual calendar mailing. As of now I figured out how to select a large number of contacts & mark them as part of the annual card category (Command & click) and go to Word's Data Merge Manager where select the main document & then the address book as a data source. I went to Query Options and selected the category that fits (annual card). Now what? ...

Disabling password feature on Personal Folders
I've upgraded from Outlook 2000 to 2002 and set up the user's Outlook profile. I go to add his Personal Folders and browse to his saved .pst file and the system asks us for an outlook password. I enter his Outlook password and I get the message that it is incorrect. The problem is the user says he never password protected his .pst file. So how do I - or can I - remove the password protection so that I am able to add his Personal Folders? Any help is greatly appreciated! ...

Cannot view itme in Public Folder between 2 different exchange 2003
I have 2 Exchange 2003 on WIN2k server. Exchange 2003 (A) has 300 mailboxes and store the public folder. Exchange 2003 (B) has 100 mailboxes. User at Exchange 2003 (B) found that they can view the public folder but no items in it. User at Exchange 2003 (A) do not have this problem. Is the public folder must replicate to other server? Is any suggestion to view the item if no replication on public folder ?? Thanks Dennis JoJo These 2 servers in the same routing group. Exchange 2003 (A) is the Master Exchange 2003 (B) is the Member "omer maydan" <omermaydan@yahoo.com> wr...

Business Portal
BP 3.0 I am trying to set up our Business Portal to be as easy as possible for our sales team. One of the requests they have made is the ability to find out WHAT PO is COMMITTED to the SPECIFIC line item in an order. Similar to actually looking at GP Sales Transaction Entry window where it gives an icon to show that the item has been purchased, what PO it's been committed to. I have spent hours trying to make this happen. Has anyone else been able to do this? If so, I would appreciate detailed steps. Thank you ...

Multiple Domain e-mail addresses
We are running Exchange Server 2003 Enterprise addition and I am having a bit of a "brain-freeze" at the moment... Where in the Exchange Admin do I configure the server to accept e-mail from more than one domain. For example, we currently accept e-mail from mycurrentdomain.ca and would also like to accept email from mycurrentdomain.com. Please note that I have updated all of our DNS MX records as required, just need to make the changes on the Exchange server. Thanks in advance... Recipient polices-email address policy. "Raymond Spitzingle" <ray(nospam)@stuff...

Delete rows with true or false
Hi, I want to delete all the rows that contain the word true or false. How can I do this? Thanks Diana wrote: > Hi, > > I want to delete all the rows that contain the word true or false. How > can I do this? Can you sort on the column containing true or false, then select all the rows in one group and delete them? Or does it need to be automatic? -- Jordon If the data is in one column, you could apply data|filter|autofilter (in xl2003 menus) to that column. Show the rows that contain either True or False and delete the visible rows. Then remove the au...

Mail merge from Excel #2
Hello I am trying to use the 2nd worksheet of an Excel spreadsheet for a mail merge, but the mail merge helper only allows me to select the 1st worksheet. I don't want to change the worksheet order because I have another mail merge running from the 1st sheet. Is there a way of selecting the 2nd sheet Thanks in advance Jo, see the like below about using Microsoft Excel Worksheet via Converter to do it. You could also copy the page to a new workbook and use it as your temporary data source. I have run into problems with using some date in excel when I try to merge with word and have overc...

DB Mail is is not working. Need help please.
I have try stop and start the db mail by executing the SPs below but no luck. Does anyone has seem the error below and how to fix it. Thanks in advance for your advise/help. --steps USE msdb; go EXECute sysmail_stop_sp; go EXECute sysmail_start_sp; go EXECute sysmail_help_queue_sp @queue_type = 'Mail'; go queue_type length state last_empty_rowset_time last_activated_time ---------- ----------- ---------------------------------------------------------------- ----------------------- ------------...