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" <firstname.lastname@example.org>...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 >...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" <email@example.com> 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'...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" <firstname.lastname@example.org> 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" <email@example.com> 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.
...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.
...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...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 ...How do I center an email being sent from Publisher?
I am trying to get the message to appear in the middle of the email message.
It would be great if I could learn how to do a color border too.
Why not compose your email as a publication? Center your message, draw a
rectangle around the creation, give the line a color and send it to the back.
Save the whole message as a .jpg and send. It will be an attachment.
You also can convert the publication to a web page and send. If your recipient
has HTML enabled in their mail program, the message will remain centered.
A PDF will work too, like the .jpg option, it will arrive as an attachment.
...CListCtrl Item Data Question
When I try to 'attach' item data to my list, I am causing my program to
crash when the dialog closes. If I comment out the .SetItemData, all is
OK (but I don't have my data :(
Code snipets are below... any ideas?
-- in my CDlg derived class .h--
CLayoutList layoutList; // a member of the CDlg derived class
-- dlg implementation .cpp
m_lstSheets.SetItemData(0,(LPARAM)layout...move the replenishment method to the item maintenance form
When adding a item number you should be able to decide at that point to make
it a BUY or a Make item. You should not have to go to another form to make
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/...Mark sent items as read
I am using Outlook 2007, and I have configured three different accounts.
I have created rules to move both incoming and outgoing messages to
This is working fine, however it would be nice if the sent items did not
show up as unread.
I have googled different news groups, and it seems like this is a common
Does anyone know of a way around it?
Nils M. Lunde <firstname.lastname@example.org> wrote:
> I am using Outlook 2007, and I have configured three different
> accounts. I have created rules to move both incoming and outgoing
> messages to diffe...recovering a deleted mail before it was sent
One of my users running Outlook 2002 POP composed a long email and
accidentally deleted it before sending it. She closed the prog down and it
was therefore deleted from the 'deleted items' folder. It's not in drafts
either. Any way to get it back?
I won't give you much hope but you can try the following;
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"-keevill-" &...Filter based on a column of items
I have a range of data 500 rows high x 5 columns wide. I want to filter the
range by comparing the values in the first column to a separate range in 92
rows high (x 1 column wide). I want the whole range to therefore be 92 rows
high x 5 columns wide, with the first column equal to the "lookup" range. I
do not want to use Vlookup.
You might look at Data>Filter>Advanced Filter.
On 8/22/05 5:16 PM, in article
> I have a range of data 50...