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...Outlook 2003 email remains open in Outbox
When email is finished and send is hit email goes to
outlook folder. If the folder was empty the new email is
auto made to appear as a opened email and will not send.
Any additional emails send will log as should be in the
outbox folder and send save for the first email. Doea
anyone have a fix for this.
...record still not updated until close the form or run report
I have a cmdStart button in frmWorkshop. When click, it opens another form
On load event of frmSignIn, I make frmWorkshop visible = false
Below is cmdSignIn on form frmSignIn. It seems the line
Forms!frmWorkshop.[WS]=1 always in the memory instead of update the record.
Me.Dirty=False does not help. I have to either close frmWorkshop, or run
other report be fore the update to show up. Where did I do wrong?
Private Sub cmdSignIn_Click()
Dim rst As DAO.Recordset
Set rst = Forms!frmWorkshop.RecordsetClone
If Me.intEN <> "" Then
rst.FindFirst &quo...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 >...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'...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...Solution-Stuck Emails in Outbox, Outlook 2003
I've been having similar problems as others with emails
with attachments getting stuck in the Outbox. I've
received both Error 0X8004210B and 0X800CCC60. I finally
found something today on the McAfee website that finally
sent the email. This fix temporarily disables the Email
Scanning Process for outgoing emails. Just do this for
emails with large attachments. Go to your Task Manager,
Processes, click on MCVSESCN.exe and end the process. To
restart the process, go to Start, Run, Browse, C:\Program
Files\McAfee.com\VSO, and click on MCVSESCN.exe again to
start. The On-Access s...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.
...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.
...Self mail only remain in outbox
If I mail myself, the mail resides in outbox and doesn't go even I hit
send/receive. The send/receive status is complete.
On May 18, 9:53=A0am, GJois <guru.j...@gmail.com> wrote:
> If I mail myself, the mail resides in outbox and doesn't go even I hit
> send/receive. The send/receive status is complete.
Contd from previous....
My Outlook version is 2007
"GJois" <email@example.com> wrote in message
On May 18, 9:53 am, GJois <guru.j...@gmail.com> wrote:
...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