Sent to as attachment command
I was wondering if there is a way to set up a hyperlink
that when clicked sends the workbook as an attachment to
the person specified by the hyperlink??
A hyperlink can't do this as far as I know
But you can use a macro that will send it
to the address in the activecell
If ActiveCell.Value Like "*@*" Then
ActiveWorkbook.SendMail ActiveCell.Value, _
"This is the Subject line"
See for more mail examples
Regards Ron de Bruin
(Win XP Pro...how do i openexcel spreadsheet sent via e mail
how do iopen aspreadsheet sent via email windows need to know what programme
created it .i dont understand
Always copy the file on your harddisk first before you open it
Never open it in the mail.
Maybe they send a link to the file to you instead of the file ?
You can try this
Tools>Options>General uncheck "Ignore other Applications"
Exit Excel and try again
If this doesn't work try to re-register Excel
Close Excel first and
On the Windows Taskbar
1 ) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver&qu...Tracking inventory of lot matrix items
I have a situation where we sell cigars by pack or
individually. I have created lot matrix items so we can do
that. Now, how do I track inventory in this situation. My
cashiers break open a packs to sell individual cigars all
day long. It is not practical to change inventory every
time a pack is broken open. Is there a better way to track
inventory. Any help is appreciated.
Go into a Standard item > Special tab. Look at the Parent > Child section
Parent item: Displays the item lookup code of the parent of this item. A
parent item is defined as a...Sent Mail, have mail in sent box not sent by me??
This has now happened two weeks in a row. How can I correct this? My
computer is turned off when this is done. Email is being sent to people not
in my contact list. Do I have to close this account in order to correct?
Is it a Hotmail account?
Recent reports of Hotmail Account hijacks
If from another mail service, You can use the above as a guide for the
sorts of things to check/change.
Mike - http://TechHelp.Santovec.us
"eve" <email@example.com>...Finding "missing" Sent Mail
My Boss just came to me in a panic as he had a message on his screen about
consolidating his mail (how he describes it) and he told it Yes.. He now
can not find his saved Sent Mail.... Can you help? Where did it go?
Perhaps he archived his email? Open Outlook, click on Tools > Options > Other > Autoarchive and see if autoarchive appears to be turned on. If it is, this will show you the exact file the
items have been moved to.
Next you will need for Outlook to display this file within the user interface. To do that, click on File >...Weird POP3 Timeout issue in Outlook XP
I'm running windows 2000 SP4, w/ Office XP SP3.
I've been getting Pop3 timeout errors sporadically: "sending and receiving
reported error (0x8004210A) operation timed out (POP) server...." Whenever
I get the error, I close down outlook, reopen, and everything is fine.
I have also setup Outlook Express, and it can check mail just fine, even
when Outlook is spazzing out.
I have done the repair option for office xp. I have deleted, and re-created
the mail configuration, and nothing seems to work. Things will be ok for a
day or so, and then I get the message.
One thing to...Outlook 2003 meeting request issue
Greetings experts! :)
Recently we have switched to Outlook 2003 here. (about 50 users) On
occasion, meeting requests do not function correctly, in fact, the behaviour
is exactly the issue documented in Q307313 about iCalendar interoperability
problems, and we experienced this problem during the transition from O2K to
O2K3. However, everyone is on O2K3 now, so there should be no problem.. and
usually there isn't.. but SOMETIMES, a meeting request comes out just like
it did in O2K, like the recepient can't read it.. when this happens, all the
recepients of that particular request get ...missing items in transactions reports
I think there seems to be a bug in money. I created a new account in MS
Money 2005. and then I manually added
the payee and the proper catagory. However, when I go to reports and
click transactions by catagory, I do not see
my transaction even though I set it to the catagory. I searched and did
everything but nothing. can anyone help?
Did you ever actually add a **transaction** in the account register for the
payee with the category?
Have you checked the customizations on the report to make sure that it
covers the right account, payee, category,...No labels for sent or forwared mail
Sometimes when I am forwarding or replying mails label of message is not
changing as forwarded or replayed. Where is problem and how I can solve it?
You mean the icon doesn't reflect the change?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"girts" <firstname.lastname@example.org> wrote in message
news...old email sent back randomly
I'm running exchange 2000 on a server 2000 professional, both exchange and
windows with the latest patches installed.
One user sent an email in september to a bunch of people with an attachment
of around 800 KB.
Randomly this email is sent back to some of the people recipients of the
first email. The user who sent the email and who is in destination of this
email, does not receive it. Some of the recipients do not receive it and a
NDR is generated however their email address is correct.
I've checked the outbox on both outlook and outlook web access on the user'...Having major issues with Outlook 2003
Help! I have tw omajor problems with Outlook 2003 and I don't know if they
are related. I am running winxp pro and have jsut upgraded to Office 2003.
Everything was great for about 3 weeks, and now two things happen.
1) When I start up Outlook i get a message that says "There was a problem
reading one or more of your reminders. Some reminders may not appear. The
server is not available. Contact your administrator if this condition
Then after I hit ok, outlook continues to open, however 50% of the time I
get errors when I try to retreive mail. The other 50% I receive ...CheckBox click on CtreeCtrl item
How it's possible to intercept when a user click on the check box of a
I only know of one way to do this. subclass a CTreeCtrl class, takeover the
WM_LBUTTONDOWN. Use the HitTest method of the tree ctrl to see where it
void CMyTree::OnLButtonDown(UINT nFlags,CPoint Point)
HTREEITEM Item = HitTest(Point,&Flags);
if (Item != NULL)
if (Flags & TVHT_ONITEMSTATEICON)
//it was on the checkbox
"Davids" <email@example.com> wrote in messag...Preventing End users in Outlook from Deleting sent folders
I want to be able to prevent users from deleting their sent emails. Is there
a way to do so on the server side?
I've never heard of any way to do this...all you could do, if you need to
ensure you have copies of all data, would be to enable journaling...
Susan Conkey [MVP]
"brenda" <firstname.lastname@example.org> wrote in message
> I want to be able to prevent users from deleting their sent emails. Is
> a way to do so on the server side?
A user has full control over their *own* mail...Deleted Items in Cached Exchange Mode
I currently have users connecting to Exchange 2003 SP1 using Outlook
2003 SP2 in cached Exchange mode. I am coming across occasional users
who are hitting their mailbox limit even though their mailbox seems
On further investigation it seems that users have been religiously
emptying their deleted items in cached mode but when I use webmail to
check their server version it has loads of deleted items still sitting
in the deleted items folder.
Is there any particular reason why the synchronisation between OST and
server would fail but only for deleted items?
<...mail not sent
User had an Excel spreadsheet open and tried e-mailing it
from with Excel. It would not send. Message would
appear at top saying that the file has not been sent. Has
happened with other users.
...Number Format Issue
It seems that from time to time, some of our numbers get into Excel
2002 as text and will not sort properly. I know how to fix, by using
the Multiply feature in Paste Special to multiply all the offending
numbers by 1.
The question is, what causes this to occur when we start out with the
General format, and certainly do not format the cells as text?
Thanks in advance
Do you paste anything into the sheet? Do you copy from one
sheet to another? Do you imprt or get external data into
>It seems that from time to time, some of our numbers ...Sent Items Disappear
For some reason, after an e-mail has been sent and it is
moved to the sent items folder, it doesn't always stay
there. Go back a day later and some of the e-mails you
sent will be there, and some won't be. It seems to be
doing this at random.
We're utilizing Outlook 2003 with Exchange 2000 Post SP3
Rollup on the backend. The cache exchange feature is
also being used if that makes a difference. Any help
would be greatly appreciated.
...rpc over https issue
I have successfully setup outlook 2003 to connect to exchange 2003 via rpc
over https using basic authentication. But everytime
I start outlook it prompts for a username and passwd.
Is there anyway to save the credentials so I dont have
to enter them everytime ?
anand <email@example.com> wrote:
> I have successfully setup outlook 2003 to connect to exchange 2003
> via rpc over https using basic authentication. But everytime
> I start outlook it prompts for a username and passwd.
> Is there anyway to save the credentials so I dont have
> to enter them everytime ?
No, no...Add an item in outlook
How can i add a folder under inbox remotely for all my
users.I want to create this folder for all my users with
his inbox charcterstics(is special for each user).
Then i want to send a message with special content to go
inside this folder.
...Outlook 2003/Sent to folder
Does anyone know why my sent to folder will not display the id of the person
I sent the email to even if I select "to" in the arranged by section???? It's
making it difficult to grab previously sent I without having to scan the
subjects and do a search. I would much appreciate the assistance!
Did you try resetting the view?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a ...How can I confirm a 'sent' e-mail?
Please tell me how I can tell if my e-mail has been sent.
It will be in the Sent folder of your e-mail application.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
"Giacomo" <Giacomo@discussions.microsoft.com> wrote in message
news:D1133488-777F-4A5E-9E1D-63323636...Bare Metal Recovery Issue
I have an SBS2008 server running on a whitebox server that I would like
to move to an HP ML350 G5 server. I have been attempting a bare metal
recovery by booting from the SBS2008 cd following the recovery option
then attaching the USB drive afterward selecting the backup and
attempting to recover. I get an error that says the drive selected as
active in the bios is not large enough.
White box server:
8 GB Ram
2 Sata Drives (1TB drive with a 240 GB partition, 500GB drive with a
Intel quad core processor
10 GB Ram
5 SAS drives o...display sent msg sent from outlook in sent item on server
i am using outlook express, but when i send any msg from outlook, it never
appear in sent items on server, is there any feature that if i sent msg from
outlook it appear in sent message section on server.
You'll need an IMAP account for that. You probably have a POP3 account.
Contact your ISP and ask if they support IMAP as well for your account.
Note that this is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
http://www.microsoft.com/communities/newsgroups/en-us...budget per INV item
Budgeting is based on GL-accounts. Is theire any way to budget per inventory
items or inventory class ID (add on software etc)
...Exchange 2003 Not Storing Email in Sent Items
We just migrated over to 2003 and Exchange 2003 and have been noticing
sporadic occasions of some email not being saved in sent items. No, there
are no filter, rules or anything on the outlook clients and this does NOT
happen on ever mail so "save sent items" is turned on. At first it seemed
that it was only emails that were old but I have users reporting that after
creating a brand new email they are not stored. I have another user that
when he forwards a certain email it will not show up no matter how many
times you try. I've logged in using OWE and other workstations with ...