Notes to a File
I use my Notes to store usernames and passwords (bad, I know). I want to
transfer them all to a Word File and then delete them but I can't seem to do
this in bulk.
"GeorgeA" <GeorgeA@discussions.microsoft.com> wrote in message
> I use my Notes to store usernames and passwords (bad, I know). I want to
> transfer them all to a Word File and then delete them but I can't seem to do
> this in bulk.
Export your Notes folder to a CSV or TSV file and open that in Wor...old topic, new questions: VSS and Exchange
I saw in a post on VSS and Exchange in a microsoft newsgroup and I had
a quick question.
Is there a site (or can you answer) that describes the disadvantages
and advantages of using the Exchange VSS Writer vs. using the streaming
API? I'm having a hard time picturing scenarios and what I understand
so far is that VSS doesn't allow "no loss" restores or "out of place"
restores. But what these are is blurry to me. Given that the Recovery
Storage Group was touted as an awesome feature for Exchange 2003, is it
thus useless if you are using VSS as your backup strategy?...Cannot edit data in forms but can in tables
I have a problem!
I created a database where I can only edit the data in tables. In the forms
I created I can see the data but cannot edit the data.
I am using 2007 that I have set so the file can be opened in 2003. The data
was imported to create tables from two Excel spread sheets using the wizard.
The tables are linked together and the combined data is shown in a report.
This all works without a problem.
Now I need to edit the data, so I created several forms all of which I
cannot add, delete or edit the data.
I saw under the User and Group Permissions that u...Publish Directory, Data from Access
I am preparing our neighborhood directory, hoping to use Publisher instead of
cutting and pasting documents from Access, Excel, and Word. I have Office
2007 Pro. The data itself requires an Access report of 70 pages. Not all
data fields resist for all residents (some are null). The report requires a
subreport listing the children if they exist.
I tried to export the report from Access to an Adobe Acrobat 7 document
(standard in Office 2007) and import it as an object in Publisher. I get the
1st page, but cannot get it to flow through to additional pages. Exporting
one page at a t...Broken counter for Notes and Tasks in Outlook Today
When I choose the folders Notes and Tasks in "Customize
Outlook Today">Messages, the Notes and Tasks appears in the
column of Outlook Today with zero being the number next to
it. The numbers never change even though I have made notes
and tasks. It always shows zero. Is that the same for
anyone else or does it show the number of tasks and notes
that one has. If so, how do I fix so that the amount of
tasks and notes appears. Thanks
I'm fairly new to exchange server and I have a quick question. I would like
to be able to see all the emails that are sent in one day from my server and
also which accounts sent them. I have read thru the log file, but that
looks like the received emails. Is there anyway to do this type of logging?
Thanks for any help you can provide.
On Mon, 11 Sep 2006 15:01:29 GMT, "Auddog" <firstname.lastname@example.org> wrote:
>I'm fairly new to exchange server and I have a quick question. I would like
>to be able to see all the emails that are sent in one day from my s...Notes in the SOP Sales Transaction, are incorrect
I am just recently experiencing this error, the notes in the "Sales
Trx Entry", either for the document number, or customer or Inventory
ID, are not correct.
This is because in certain cases, notes dated from 09/06/2002
(dd/mm/yyyy) are attached to current documents, ie.
any reason as to why this could be happening, and how to resolve it
Thanks in Advance
It sounds like your next record Note Index (NOTEINDX) in
the SY_Company_MSTR (SY01500) table is too low. So it is
giving new records Note Index's which have already been
used and ...Macro or VB code to Export data to an Excel file?
I have a query that assembles the data that I would like to routinely
export as an Excel file to a specific file location.
I would like it such that various users can 'just press a button' so to
speak and get the most current data from the database for use in an
Excel Pivot Table.
I would like either or both a Macro or VB code to do this. When I
looked at the Macro options this was not obvious?
Take a look at the TransferSpreadsheet function in the Help file.
"BobC" <Bob.CallenNoSpamm@cox.net> wrote in message...Exchange 5.5 support from Microsoft
I heard Microsoft did or is about to drop support for Microsoft Exchange
5.5. Does anyone have a link to the announcement page? Thank you. P
"P" <P@no_spam.com> wrote in
> I heard Microsoft did or is about to drop support for Microsoft
> Exchange 5.5. Does anyone have a link to the announcement page? Thank
> you. P
...auto fill in data when changing fields
i new to crm 4 and i would like to; once i selected the account i need it to
grab the main phone and put it in the phone field, and could you tell me
where i need to do this, thanks
you can modify the mappings of the corresponding relationship
> i new to crm 4 and i would like to; once i selected the account i need it to
> grab the main phone and put it in the phone field, and could you tell me
> where i need to do this, thanks
I normally give the training attendees notes of the presentation after
There are 4 slides per sheet and I observe that there is a lot of space
unused. can I make the slides occupy more space so that they are bigger and
easier to read
See if this help:
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> I normally give the training attendees notes of the presentation after
> trai...Data from another worksheet
Good Morning All,
Using Windows and Excel XP.
On sheet "A" I want to show data from sheets "B", "C" and "D". On
sheets B,C and D the data is in column A but changes rows everyday.
I know the formula on sheet "A" to show data on sheet "B" that is in a
fixed location, e.g. =B!A1. How would I set up the formula that would look
for the last row of data in column A on sheet "B".
Thanks for any help.
One way is to try and get a match on a number larger than would be possible
in your case
=match(99999999...Data lost on reinstall
I had outlook2003 installed on my machine for long time and had lot of my
mails backed up in personal folders. Yesterday I required to install
outlook2002, for the purpose I uninstalled outlook 2003. Today when I
reinstalled my outlook 2003, I found that my personal folders are lost. I
tried to serach for the .pst files, but failed to find any. Please let me
know it there's any way out.
"C Chandrashekhar" <email@example.com> wrote in
> I had outlo...I have a list of data, fill in the gaps. FILL function won't work
I have a list of data in which I would like to fill in the gaps. Is this
I have age in years in A2 to A100 then data in colums in 5 year gaps (eg B2
has data then B7 then B12 etc) all incremental. I would like to fill in the
gaps belween giving me data B2, B3, B4... to B100.
How can I fill in the gaps whilst still making sure my 5 year results are
Simple example below
Many Thanks for any help
You could select a range (B2:B7 for 20 to 30).
Then do Edit|fill|series
There...lines of text...notes box
I have created a custom database for our marketing woman, I have designed the
table and layout...but I have created a Notes box for the user to enter
But the notes box is getting full and I would like to configure it so the
notes box can be unlimited rows or attach a text file to the table if
needed...I have read somewhere thatg the notes box is limited to 255 lines is
any help gratefully recieved but please be aware I dont know much about access
Hi Mister Bobzi,
Rather than defining the notes area as a Text field, make its properties a
A M...security issue in notes
we are facing a security issue with notes in MSCRM 3.0
I want some users to be banned from the entity account e.g. So I set a
security that they can only see their own accounts (user level)
Now I want them to be able to access all contacts. So I set a security so
they have full access on contacts.
For the notes, I need to give them access to notes so they can attach docs
and view all notes on all contacts.
Now if this user has advanced find privileges, he will be able to query the
notes of ALL accounts in the advanced finds. Anyone experienced this before?
any way to restrict that acc...how to change data form?
I have a form like this:
and i want to change the data above to:
a b c d
11-010001 meat 1 2
11-010003 apple 4 3
11-010012 orange 2 4
don't tell me to use copy & paste because the original data is more
than 60000 rows.
anybody please help!!
For a =3D 1 To Cells(Rows.Count, 1).End(xlUp).Row
If Cells(a, 1) <> "" Then
Cells(a, 2) =3D Cells(a + 1, 1)
Cells(a, 3) =3...How do I save notes in outlook?
I have a number of Notes saved for Outlook 2003 and I have lost them in the
past because I assumed they we're saved along with my Archieve information,
only to find out later they were not. Had to start creating them from
scratch which was a pain. How can Outlook 2003 NOTES be saved? Please
You can copy/export the Notes to a PST file. To export use the File menu >
Import & Export command or you can open a PST using the File menu > Open >
Outlook Data File command then drag/drop the notes into the other PST.
"jhr07" <firstname.lastname@example.org...Can I have default data in new rows?
I have a sheet that the first 5 rows have "administrative" data and some sums
of the data below, basically it's a "header" section, the entire worksheet
below that, the first 15 columns hold all the data for the worksheet. What I
want to do is whenever someone inserts a new row or starts on a blank row at
the bottom, to autofill some of the data within the columns, some of them are
formulas and some are simple like "Yes/No" drop down lists. Can you do a
"onNewRow" event type macro to copy formulas or is there simply a default
data fil...Sync Service Calendar with Exchange
I would like to Sync our service calendar with our exchange server, our
engineers have windows mobile devices and will receive appointments on those
wirelessly from the exchange server. They don't necessarily have to sync
their laptops everyday then.
How can I do this?
We are planning to come out with a similar add on solutions with SMS , if
you are interested we can offer the solution for windows Mobile. Please drop
a email for more info.
ERP SOlutions Specialist
> I would like to Sync our s...coalesce excel data
I developed a data logger for a computer simulation that people
interact with. The logged data is stored in a tab deliminated text
format. That data can be imported into Excel. I bring in different
subjects and have them test the simulation while I log their usage of
the simulation. I would like to be able to coalesce the logged data of
all the different subjects data into meaningful statistics about the
simulation. I can log the data by time or by room the person is in the
simulation. The data logged per time slice or per room is health,
amount of object 1, amount of object 2, etc. So it woul...Access 2007 Note table in date order, note form is not. What can I
The first thing you can is learn to use this big white sapce to post your
question. My Subject Line got cut off and I almost missed the question.
No answer your question... Use a query based on your table as a
RecordSource for your form. (Table order is irrelevant to the form
otherwise.) In that query you can set the Sort Order of the records to be
by the date field.
"I feel I have been denied critical, need to know, information!" - Tremors
"Rach...Data correlation problem
I hope I can write this question so it makes sense...
I have an item database, about 30,000 items. It is realy only about 50
items, laptop batteries and adapters, but most of them works with a lo
of laptops, so the same items are listed over and over again, bu
generally not right next to each other. For instance, a Compaq Presari
1200 might take two batteries, an AC Adapter, and a Car Adapter, s
that's 4 part numbers:
Each day I receive an "eta" file, a list of part numbers that are ou
of stock in one column, with the date that they are backo...Comparing data 04-24-07
Dim i As Long
Dim j As Long
Dim cnn As ADODB.Connection
Dim rs1 As ADODB.Recordset
Dim strSql1 As String
Dim lngRecordCount1 As Long
Dim lngParseID As Long
Dim strMsg As String
Dim lngTime1 As Long
Dim strDataSource1 As String
Dim strDataSource2 As String
Dim lngCurrRecord As Long
Dim CurrTime As Long
CurrTime = Time()
'Recordset to retrieve the combat log
Set cnn = CurrentProject.Connection
Set rs1 = New ADODB.Recordset
strSql1 = "Select ParseID, lngTime, strDataSource, strMsg,
lngParseID from tblParsedData ORDER BY lngTime ASC"
rs1.Open strSql1...bold font for lotus notes email
I am using the following code in Access 2003 to send an email in Lotus
notes. I want to bold some text, does anyone know how I can amend
this code to allow for some bold text?
Public Sub SendQtrNotesMail(Subject As String, Recipient As String, WL
As String, SQA As String, _
DC As String, ADR As String, TDR As String, SafetyNote As String,
QualityNote As String, _
ProdNote As String, SaveIt As Boolean)
'Set up the objects required for Automation into lotus notes
Dim Maildb As Object 'The mail database
Dim UserName As String 'The current users notes name