SQL Server Job with file attachment
This is SQL Server 2005.
I dont know whether its possible or not. i thought will post here.
Am running a sql server job schedule to run, which will send mail to
file attachment using msdb.dbo.sp_send_dbmail. The file attachment is just a
single file. its running fine now.
Now instead of attaching a single file, can i attach the contents of a
folder using msdb.dbo.sp_send_dbmail with a SQL Server Job.
"Arun" <Arun@discussions.microsoft.com> wrote in message
news:BF1BBE1B-3165-4CBA-90E2-AD11CA6B280C@microsoft....File opens when Excel opens
I used an excel file to import contacts into outlook.
Now everytime I open Excel, Excel opens to a file called
contacts, which is the file I used to import into
Outlook. The data is all garbled. What I want to do is
to eliminate this file from being opened and have Excel
open to a clean workbook called Book1.
Can anyone help?
The only way that could happen is for contacts be in the
xl start folder. remove it form the start folder.
where is that? varies but..
try exploring around the above path. got to be there
somewh...protecting sheet with combox
i'm trying to protect a sheet with a combo box in it. the combox list a
bunch of values. each value you pick is linked to a formula which
changes a price value in a different cell. i would like to protect the
sheet so that the money value that appears in the cell can't be changed
by the user. whenever i try to protect the sheet i then can't change
the values in the comb box . i want to be able change the values in
the combo box but have the formulas and automated cells protected. any
~~ Message posted from http://www....Password Protect Two Sub-contact Lists
I have a regular contact list, and within this list I have two
subcontact lists. One is personal, and the other is personal business.
How can I password protect the personal and personal business lists?
Thanks for any help!
Sorry, I just realized that there's a newsgroup dedicated to contacts.
I'll post this there.
> Hi everyone!
> I have a regular contact list, and within this list I have two
> subcontact lists. One is personal, and the other is personal business.
> How can I password protect the personal and...Unable to Read File #3
After upgrasding to Win XP from Win 98, I am unable to
read any of my saved Excel (Office XP version) files on
my PC. I get a message "Unable to read file"
Try to Re-register Excel
On the Windows Taskbar
Start>Run "excel.exe /regserver"(no quotes)>OK.
See the space between exe and /regserver
You might have to designate a full path to excel.exe.
In that case Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Tom" <anonymous@discussion...Passwords #5
I would like to password protect a workbook so that when
the workbook is selected to open a dialog box pops up
asking for the password and after the password is entered
correctly the workbook will then open. Thanks for the the
Todd, do a save as and look under options, depending on what version you are
using and set a password to open
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address t...Stubborn Misplaced File
Recently I attempted to backup my Outlook Express using the Windows NT
Backup Utility and when I tried to restore the files to the new directory
they did not properly restore to the correct location and when I try to
delete the misplaced folder it will not allow me to, it gives the following
X Cannot delete Outlook Express: The file name you specified is not valid
or to long.
Specify a different file name.
It is located in the following location:
C:\Documents and Settings\Compaq_Administrator\Local Settings\Application
Hi, I have a password field in a database. How do I set it so that a
user can only type in 7 characters for a password. and if they type
more an error message will appear?
> Hi, I have a password field in a database. How do I set it so that a
> user can only type in 7 characters for a password. and if they type
> more an error message will appear?
You may use the ValidationRule and ValidationText of the field in the
table design view. Setting ValidationRule to Len([YourField])>7) will
raise an error in your case.
--> stefan <--
...How do I import e-mail files into Microsoft Publisher 2003?
I receive files thru the internet that I need to get into publisher and
change the size, or add data. How do I save them to get them into Publisher?
How do I get Word files into Publisher for editing?
"Publisher Fan" <Publisher Fan@discussions.microsoft.com> wrote in message
>I receive files thru the internet that I need to get into publisher and
> change the size, or add data. How do I save them to get them into
> How do I get Word files...Keep user passwords
We've just finished installing a new Exchange server and connecting it to a
separate DC. We used to have everything on the same server but we'd like to
be able to scale our solution better in the future - therefore the new
setup. Users are primarily connecting to Exchange by means of RPC over HTTP
from clients that are not part of our AD.
The old setup allowed users to save passwords if they configured their
clients to use NTLM authentication and followed the directions in this
This worked both for RPC...exporting excel charts as eps files
I am wanting to know whether it is possible to export (or
save) a microsoft excel chart or graph as a vector file
(e.g. eps or emf file).
Basically i am wanting to export an excel chart or graph
as a vector-based file so that i can input it into a
desktop publishing programme like Adobe Indesign. Simply
doing a copy and paste from excel to InDesign only copies
a screen-resolution image, which is, of course, useless.
Most other graphing programmes have the option of
exporting graphs as vector files, so i am hoping that
excel is the same.
Any help would be greatly appreciated.
Cheer...Pulisher Files on shares drive
Hi, we have three computers each with publisher 200 installed. One computer
has a shared drive which is accessed by all computers and is used for
storing data files.
Have had no problems uintil recently. Now if we create a publisher file on
Machine 1 and then try to open it on machine 2 or 3 I get a message telling
me that the file is locked by another machine. I can cvreate a file on
machine 2 or 3 and open it on machine 1.
Not quite surre what has happended, but and advice gratefully received
Publisher is not network-friendly.
MVP Microsoft [Pub...how do I import a Quottro Pro 10 notebook file (.qpw) into Excel
I would like to import my worksheets and notebooks (.qpw) that I developed in
Corel Quottro Pro 10 into excel 2003.
Thank you in advance for your help and information.
...How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the
password. Is there any way that I can gain access to my worksheet?
There are tons of FREE good Excel password 'cracking' tools. Your favorite
search engine should get about a gazillion hits on a phrase like "crack excel
password" or "excel password cracker".
A good one that many report great success with can be found at:
> I password protected an Excel spreadsheet and now can't remember the
> p...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...How to protect cells?
I would like to protect a range of cells (A2:D24) with a password for a
group of users that would make changes to cells in this range. Then on
the same sheet, also protect a range of cells (E2:E24) from everyone but
me. Is this possible?
Please don't multipost.
See the thread in .programming.
"Mark F." <firstname.lastname@example.org> wrote in message
> I would like to protect a range of cells (A2:D24) with a password for a
> group of users that would make changes to cells in this range. Then on
> the same she...Password
I am working with publisher 2007. I finished my site last Dec. and went to
It is not letting me make changes because it does not like my password. I
can not figure out how to go in a reset everything from my provider.
I was also trying to see if I could find web publishing wizard, which
doesn't seem to exsist with 2007.
If you are saying you forgot your password then contact the ISP Tech Support
and they will reset the password to something like 1 2 3 4 or something
other that is very simple. They will also instruct you to change it to
For some reason, it will not store the password. I have
checked the box that says "remember password", but, each
time I try to log in. It will ask me for it. Any ideas.
I am thinking about recreating the profile for thismailbox.
I am a consultant, and my customer doesn't know how (or
won't write down what I tell them) to do this.
...Protection from copying
I have a workbook with hidden cells that I would like to protect (leaving
certain cells visible for input). However, even with password protection on
the entire workbook, a user can copy all of the cells into another workbook
and view/edit/change all of the cells in my workbook. Is there a way around
If it's formulas you want hidden, use Format - Cells - Protection - Hidden.
Then protect the sheet (Tools - Protection - Protect sheet). If it's data,
forget it. Users can copy/paste cells , copy the sheet, take a picture of
the workbook with PrtScrn (or with ...File Size #4
I have several workbooks linked to one autofeed. Most of the workbooks are responding fine, but I have one workbook that significantly increases in size every time it's saved; even when we've not made any changes. Though it contains the same amount of data as a similar workbook, it is now 5 times the size of the others. Is there any way to quickly troubleshoot the problem? I've gone into File, Edit, Links as well as re-linked several pages to see if there was a problem in the way it was set-up originally and so far nothing has worked. I've even removed information only to ...Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...Sending a publisher file as an email attachment
When sending a publisher file as an email attachment and is opened, it does
not look like the original. Any suggestions why and how to fix it? Thanks
> When sending a publisher file as an email attachment and is opened, it does
> not look like the original. Any suggestions why and how to fix it? Thanks
Different fonts are installed on different computers.
Create a PDF and send that instead.
Ed Bennett - MVP Microsoft Publisher
Its not just the fonts, words are added, hyphens are added, and graphics are
upside down. Any other thoughts?
&quo...Preprocessor symbols ignored in .RC file
(I posted this question in another group that is related to resource
talk, but there's SO little activity I had to post it here too. Sorry
to those who might be annoyed by that.)
I am trying to set up the version info so that the exe file has
different info in the version fields, depending on one of my
I created a configuration that has the string _W98 in the
Configuration Properties C/C++ Preprocessor tab. Then I tried using
the following inside the .rc file
VALUE "FileVersion", "0.74 W98"
I have five Excel files which contain the records of my previous 4 years
Business matters. Suddenly yesterday when I opned one of my files I received
the following messege.
The file is not in recognizable formate.
if you know the file is from another program which is incompatible with
Microsoft Excel, click Cancel, then open the file in its original
application. If you want to open the file later in Microsoft Excel, save it
in a format that is compatible, such as text format.
If you suspect the file is damaged, click help for more information about...password prompt when no password is set.
thru a series of unfortunate events I had to reinstall my os and all of
my programs. I was using ms money 2000. I have always kept the main
*.mny file but lost my backups. When i reinstalled money and tried to
open my mny file I get a password prompt. I have never password
protected the file and when i tried to run a password recovery program
it says "no password set". I do have older backups of this file but
they are too old to be of much use. But i am able to access them. any
suggestions would be appreciated. Thanks
The password prompt often appears when you open a dataset m...