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...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...Outlook 2010
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...Account Group ID #2
Even though I have included Account Group ID in my FA import it is not being
assigned to the asset. This is a problem since the asset G/L depends on this
ID. Right now all assets appear to be defaulting to the default Account
...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...Convert a category into an asset account
Hi, I have been writing checks to pay for materials for a
new building, and assigning those payments to various
subcategories of a main category "Our new Garage". Now I
realize I should have created an asset account for the new
building and transfered the funds from the checking
account to the asset account instead. I would like to know
if there is any way to convert the whole category into an
asset account showing the amounts I have paid as assets.
Probably not easily. Find/Replace will let you replace a category with an
income/expense category but doesn't seem ...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...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...How can I get bar codes w/ Excel & mail merge?
I want to send out a bulk mailing with large postcards. I want the addresses
printed on the postcards via mail merge. I am using Excel, but don't see
where or how to add the bar code to the address, which would save me a lot of
money. Can you help?
>I want to send out a bulk mailing with large postcards.
I want the addresses
>printed on the postcards via mail merge. I am using
Excel, but don't see
>where or how to add the bar code to the address, which
would save me a lot of
>money. Can you help?
I not entirely...Merging worksheet into MS Word mail merge
I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $ and
the , do not show up in the merged letter. Any suggestions on how to solve
Instead of just referring to the cell e.g. A1 use
"Briggs" <Briggs@discussions.microsoft.com> wrote in message
> I am merging a letter and an Excel worksheet. When I merge an Exc...Account Summary borken?
I've been using Money 2004 for about a year now and realized that the
"account summary" for all my investment accounts is supposed to have useful
info, and I don't sem to have that.
When I go to account summary for any investment account there 3 columns
labeled "currency" and thats all. For each column there are entries that
say "US Dollar", the correct number of lines for the number of investments
in that account. I can right-click those and get a menu that takes me to
useful info like details etc, but the security name and other info does not
show up ...Balance Account Issues...
I have Microsoft Money Plus and have been using the Money suite of
applications for over 4 years. Today, when I went to go and balance
my checking account via...
* Common Tasks
* Balance This Account
* Clicked Next
* Typed in the Statement Date and Ending Balance and Clicked Next
* I checked all my "Cleared" transactions and clicked "Next" when my
balance was "0".
Nothing happened! I tried balancing my savings account and it works
fine, but my checking account won't balance.
On Nov 9, 3:48=A0pm, neal.m.s...@gmail.com wrote:
> I ...Changing the user password without the use of SA or DYNSA accounts
Is there any way to save a user password in GP v10 without the use of the SA
or DYNSA login? I would like to grant security to one user to do this.
Currently the save button is greyed out unless they log in as SA or DYNSA.
You can do this by granting that user sysadmin rights in SQL management
Studio. In SMS, expand the Security folder, then logins, then find that
user, right click the user, go to properties, click server roles and check
the box for sysadmin.
"Junior De Alba" wrote:
> Is there any way to save a user password in GP v10 without the use of the S...Error in Mail Merge when selecting Edit Individual Labels
We are noticing an interesting error when trying to perform a mail merge
within CRM and Microsoft Word. We have created a view in contacts and we
perform all the typical mail merge functionality using the Labels option. At
the end, instead of printing the labels without any edits, we click on “Edit
Individual labels” and we get the following error…
C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE has encountered a
problem and needs to close. We are sorry for the inconvenience.
We are on CRM v4 Update Rollup 8 using Outlook 2007 and the CRM Outlook
(Online only) client.
Has an...Pasting into merged cells #3
I want to copy information from an area that doesn't have merged cells to an
area that has merged cells. When I do this I either get an error message or
when I use the Paste values and number formats it only pastes every other
entry. Is there another way to paste that I don't know of that will paste
into the merged cells?
best would be to get rid of merged cells.
You could of course paste cell by cell
> I want to copy information from an area that doesn't have merged cells to an
> area that has merged cells. When I do ...Account Descriptions in FRx
Is there a way to have the GL Account Description from the GL COA to
automatically show when using GL Link to an account number.
I have read and looked at both Row Formats and Column Layout and cannot find
Free Radical, LTD.
If your rows are linked to GP's COA, the only report that will show the
account descriptions as they appear in GP will be the Account Detail report,
which is printed as a result of choosing Account + Transaction Detail in your
catalog of reports.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business...Autofit Row & Merged Cells
Is this just me or is it a common problem:
I have some text in a cell. The cell is merged along a row with the adjacent
cells, I have put word wrap on. Now Autofit Row doesn't work and only shows
the first line of text.
Is there anything I can do, apart for manually adjust the row height?
Take a look at this macro by Jim Rech:
If you need help getting started with macros, look at David
McRitchie's Getting Started with Macros page:
In article...Merged letter and made changes to merged letters. Final merged doc
Merged letter and made changes to merged letters. Final merged document has
date in field code and atty wants to change it from Jan 5 to Jan 4. She does
search and replace but the date automatically updates on print, even if we
change that setting.
"Serena K." wrote:
> Merged letter and made changes to merged letters. Final merged document has
> date in field code and atty wants to change it from Jan 5 to Jan 4. She does
> search and replace but the date automatically updates on print, even if we
> change that setting.
>...New account cannot log in
I have a new Windows Server R2 domain set up.
The servers are in a remote location and are entirely managed and run via
My own account is a Domain admin account, I can log in remotely and manage
I am trying to create NEW accounts that can log in, but I consistantly get
an error like below, I am at a loss, the usernames and passwords DO exist
and we are typing them correctly. This affects new accounts only for some
Unknown username or bad password:
Log Name: Security
Date: ...Merging .pst files
Over the last couple of years I have been working from both a desktop and a
laptop computer when travelling (both running XP but with Outlook 2007 and
2003, respectively; but I'm told that shouldn't have any impact as they use
the same type of .pst file system). I have copied outlook,pst files from
one to another to ensure I'm always working with a current file.
However, during those years, I have not always understood how to manage that
process. Fortunately, I've always saved the old .pst file in case I screw
Well, I have screwed something up....External Account access to custom CRM Report
Our customer wants to be able to provide access to a custom CRM report to
An Account can view only that one report and only for their account record.
The Account should not be able to see any CRM records (even their Account
record) - only the custom report.
What is the best way to implement this requirement?
Thanks in advance.
If you are looking to provide access to Accounts then basically you need to
develop a new custom developed interface. If you use MS CRM interface then
you need to have CRM license. My suggestion will be to develop a website
using CRM...Wrap text in merged cells
I have a complicated spreadsheet which results in a nicely presented report
in which l need the user to input some narrative. To preserve the look and
feel of the report l would like the user to be able to input the narrative
on a single row, restricted to say 6 columns. The row height needs to adjust
automatically dpendent on the amount of text entered.
It seems a simple problem but l have tried many methods without success.
Anybody got any idea's on how to do this ?
All replies greatly appreciated.
You have a problem because:
>>restricted t...How do I create an account in Exchange that can open any mailbox in the domain?
As a generic (but mostly desktop) Windows guy at my last organisation,
I once used an excellent little article to setup a administration
account for Exchange that could open any mailbox on the organisation
for test / troubleshooting purposes. I would log in to the client
machine using that logon and then configure the mail profile to match
the server\mailbox of the account I wanted, and then it would open up
the user's mailbox in Outlook. Unfortunately, I cannot remember how to
do this, although I know it was very simple. I am sure this question
will irritate many due to its low level...Kit Sales Distribution Accounts
Is there a way to use the Sales Account from the component items from a Kit
as the posting accounts on an SOP Invoice?
Not unless there is a 3rd party product that will do this. Basic GP will not.
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
> Is there a way to use the Sales Account from the component items from a Kit
> as the posting accounts on an SOP Invoice?