Is it possible to create a document in publisher (mine is
a certificate) and then merge the desired information from
a select querry in access?
Hi Tina (email@example.com),
in the Microsoft� newsgroups
|| Is it possible to create a document in publisher (mine is
|| a certificate) and then merge the desired information from
|| a select querry in access?
Yes, you can. Which version of Publisher and Windows are you using?
Microsoft Office Publisher MVP
Official Publisher MVP Site:
This posting is provided "AS IS" wit...Outlook 2003 PRF File
Does anyone know if it is possible to set-up multiple profiles in a PRF files.
We have a document management product that required a second profile in
order to interact and so when Outlook is started we would like it to set-up
the user profile and this additional profile, so 2 profiles.
I know that you can set-up multiple services but we would like to have
Hampshire County Council
Each PRF file can set up only one profile, and Outlook can process only one
PRF file per Outlook session. Therefore, you can do this, but it will
require ...Merge same transaction
I've had transactions that I've placed in my register with detailed info in
the memo area only to have the same exact transaction download with no info
and unrecognized as the same transaction. Traditionally I've copied and
pasted the info into the downloaded transaction and then deleted my
transaction. This is a real PAIN... Is there a way to tell Money that these
two separate transactions are the SAME transaction and then have it merge
It works exactly as intended when Money recognizes the transaction that's
already in the register and then merges them beautiful...Multiple Excels
Here's a really easy question for you with what's probably a really easy
answer, but Excel Help is no help so I need your help.
I have two Windows shortcuts to open separate Excel files. What I'd like is
that they open the files in two separate instances of Excel instead of in
the one instance. When I'm working with two workbooks I find it easier to
switch between two applications than to flick between two open workbooks
using the toolbar option. Can anybody help?
W: http://www.digital.ke...Trying to combine multiple records into one record in a Query
I am new to Access, and very little knowledge about SQL. I read allot about
normalization, need to know if I went to far with it with my Family table.
Here is the structures for the tables I have, and of the query I want to
ContactID (Create using VBA in a form) (PK)
tabContactID ContactID FirstName LastName etc....
0001 DonDuck Donald Duck
0002 MicMouse Mickey Mouse
Next the Family Table:
tabFamID (Autonumber)(PK...how to combine multiple versions of single spreadsheet?
Well, the doomsday scenario has happened - two colleagues working on the
same spreadsheet fail to communicate. Each has updated a project tracking
sheet at the same time so we now have two new versions. Is there a way of
Excel combining the latest data out of each sheet?
Person X opens spreadsheet version A to update and creates version B
Person Y opens spreadsheet version A to update and creates version C
There is a lot of work entailed in updating the sheets but luckily persons X
and Y have their own projects so they do not update the same information.
Is there a way to c...Closing Outlook in a .bat file...?
Can I force Outlook to close in a DOS .bat file so I can then invoke the
backup of the .pst database in the same .bat...?
"Tiscali" <firstname.lastname@example.org> wrote in message
> Can I force Outlook to close in a DOS .bat file so I can then invoke the
> backup of the .pst database in the same .bat...?
Yes, but two caveats:
1) The tool you use may depend on your version of Windows
2) Unless you take very special measures (keystroke pushing to
answer dialogs) ....csv file
I am creating a .csv file which includes bank account numbers. Some of them
include zeroes at the beginning but even if I format the column as text, the
zeroes keep disappearing.
Is there a way to keep the zeroes at the beginning of each cell?
I am on Windows XP Professional and running Excel 2003 SP2.
How are you checking for the leading 0's?
Are you opening the .csv file in NotePad?
Or are you reimporting the file into excel?
Try opening in NotePad to check.
> I am creating a .csv file which includes bank account numbers. Some of them
...Some JPG files cannot be open after Security Update for Outlook.
Just recently some of the users cannot open some JPG files. After some
testing when file was saved through Outlook the size increased by ~30
KB and Windows Picture and Fax Viewer wasn't able to open the file.
When files was saved through OWA Windows Picture and Fax Viewer could
open the file fine. Tried to disable antivirus on outlook, server and
nothing helped. Eventually uninstalling "Security Update for Microsoft
Office Outlook 2003 (KB945432)" fixed the problem. Since then if the
file is saved through Outlook it opens fine.
Anybody experiencing this problem as well? Is there...Opening a pst file with Outlook...
I sent home my contacts from outlook at work to my home
here. The file is contacts.pst which is 761 KB. I went to
outlook and clicked "file" "open" then "open data file"
but my contacts are not showing. It brings me to a blank
page. Does anyone know or have any idea where the
contacts may have gone. I need these fiels ASAP as I am
now working from home. If you can help please respond or
call my cell at 630.532.1773 It would be greatly
appreciated. Thanks, Shaun
How did you create this PST?
It's too small to contain much data.
If you opened it and they...Shared excel file dissapears
We use a shared excel 2000 xls file shared on a w2k server as a production
log. we now have about 30 users with about 12 users constantly editing. As
we add more users the dissapearances seem to mount up. we are at about 2 a
I was wondering what the max amount vs the recommended amount of
simultaneous users are. Are there any known issues which would cause excel
to mysteriously vanish??
It has been said that democracy is the worst form of government except all
the others that have been tried. - Winston Churchill
In Outlook 2003 I had one .pst file with all contacts inside, but used 3
email accounts with no automatic rules for mail delivery.
I manually put the emails down in it's respective archive.pst files and want
it done this way.
In Outlook 2010 when using several email accounts, it's automatically
established one .pst file for each email account where the respective email
drops into. Is there a way to have it all into one "Personal Folder" (the
(I want to send emails were sender account is the only on showing as sender
and not any "sent on behalf ...Merging 2 Companies into 1
Are there any guidelines or outline for what tables you need to look at to
gather the various information you need in order to merge 2 companies
together as well as issues to consider when undertaking such a project?
It is a project and a half. I got approval from a major client yesterday to
proceed with just this project.
You literally need to look at all of them!
I understand that MS Professional Services will do this project for you. In
my case the client cannot be down and has too many 3rd party products for us
to pass it off.
When does your project need to be completed?
Ri...Excel "file is already open"
Whenever I open a '.xls' workbook from outside Excel
(such as from Windows Explorer), Excel indicates that the
file is already open - although, once I click OK, I seem
to be able to work with the file normally. The same file
will open fine from within Excel. I am using Excel 97 on
an XP-Home machine.
Can you explain why I may be getting this message, and
how I might correct for it?
The FAQ at Debra Dalgleish's site might give the solution:
John McFadden wrote:
> Whenever I open a '.xls' workbook from ...Word mail merge
After printing a document there exists a activity with subject "Word
Mail Merge" to the contact with status completed.
Is there a possibility to change the subject name or to make a link
to the original Word document?
I think that the subjct name is hardcoded. The issue of only adding this
paltry information to the activity and not showing what document was sent is
a problem many have asked about.
Microsofts workaround to this glaring gap in functionality is to then add a
copy of the word document to the record using notes. Totally unworkable if
you have just mail merg...Opening Multiple files simultaneously
I am trying to open several excel files at once, ie.
select 2 or more files, right click, then click open, but
I cannot get them to open at the same time. I have to
open each file separately. I can have several files open
at once but they must be opened individually
Hi Lothar, I am not sure of a VBA way to do this but you
can certainly open multiple files when using Explorer.
Just shift+click the files you require, right click and
>I am trying to open several excel files at once, ie.
>select 2 or more files, right cli...Sharing one outlook file between a laptop and a desktop
Does anyone know if it is possible to have the same outlook file on two
machines, running different versions of outlook?
I would like to buy a laptop, and use it while traveling. My desktop at
home has Outlook 2002, and I would like both systems to run off the same
outlook database (is it the .pst file?). When I return home, I would like
to update the desktop by syncing it to the laptop, like a pocket pc, and
updating the files on the desktop. Am I living on the other side of the
looking glass, or is this possible?
Can you this same idea work amongst a network of different machines runnin...Can I freeze multiple rows?
I'm working on a spreadsheet that has contact information in the farthest
lefthand collumn and collumn headers at the top of the spreadsheet. Is there
a way that I can freeze both of them so that I always know what I'm looking
at without having to scroll all the way up or all the way over? Thanks a
If you click on cell B2 and do Window > FreezePanes, then both column A and
row 1 will be "frozen".......
Vaya con Dios,
" <email@example.com> wrote in message
news:3B58B895-7C24-4418-87B3-B3B5F35AA682@microsoft.com....Win32 DLL def file question
How can we export Win32 dll functions for dynamically LoadLibrary and
I see VS MFC DLL project has a def file but Win32 DLL does not have one,
should we add a def file to VS Win32 DLL project , how can I do that ?
Thank you .
This will be helpful:
"Kid" <Kid@discussions.microsoft.com> wrote in message
> How can we export Win32 dll functions for dynamically LoadLibrary and
> GetProceeAddress ?
&...Split "Firstname Lastname" text box into two columns, Multiple Aut
I've got a bibliography data base I'm trying to set up and would like to
enter a name, "John Smith" into my form and have it add an entry into my
Authors table as Column 1 - John, Column 2, Smith.
Also, there are sometimes mulitple authors on any given paper. How can I
enter mulitple authors for the same paper?
Below is the VBA, SQL code I've been trying to work from. I get an error,
"Number of query values and destination fields are not the same" when I try
to run it. But it still would 't solve the mulitple author problem even if
it wo...mail merge/merging 2 address lists...
Is there a way to merge two of your address lists in Publisher 2002? I have
two address lists in my data base folder and would like all the addresses
merged into one as there are some addresses different in each and some the
Hi Robin (firstname.lastname@example.org.NOSPAM),
in the Microsoft� newsgroups
|| Is there a way to merge two of your address lists in Publisher 2002?
|| I have two address lists in my data base folder and would like all
|| the addresses merged into one as there are some addresses different
|| in each and some the same.
No, you cannot. You nee...adding data from multiple spreadsheets into one chart
I need to put information from 4 different spreadsheets into one graph. Can
someone please help me?
Produce a graph from your first spreadsheet.
Copy the relevant data range from the second spreadsheet, then select the
graph and edit/ paste special/ new series or new data points.
Similarly for the third and fourth sheets.
If you have difficulties getting exactly what you want that way, you can use
edit Source Data in the graph to add an extra series or to change the X or Y
data range for an existing sreries.
"Marjory" <Marjory@discussions.microsoft.com&g...Can I save application as .exe file
I have created several successful Access applications in the past. I need an
application that can be maintained on several different computers which may
not all have MS Office installed. Can I put the complete database on a CD so
different people can update the data? I guess that this means the application
would have to be a .exe file and maybe use CD-RW CDs so it can be written to
on different computers.
There's never been an ability to create an executable from an Access
database, and I wouldn't expect there ever to be such a capability.
Take a look a...merge and compare
We have two versions of the same work sheet from differnt dates.
Some of the cells have been changed in the latest version and we need to
compare which cells have had changes and selectively merge the two.
Is there any hope???
> We have two versions of the same work sheet from differnt dates.
> Some of the cells have been changed in the latest version and we need
> to compare which cells have had changes and selectively merge the
> Is there any hope???
have a look at
An add-in which compares two worksh...Autopopulate Multiple Fields in Table Using a Form
I have a form based on a table where I want to store data. The data to store
comes from combo boxes based on various lookup tables. The wrinkle is that
there is one lookup table that contains 2 fields of data (questionnum and
question) I want stored in the table once the questionnum is selected. The
question field is formatted as 'memo'. When I create the combo box the
question field is not an option for selection. I add it manually to the
properties after completing the criteria for the combo box. I have been
struggling with the code used to autopopulate more than one field but...