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 (firstname.lastname@example.org),
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...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...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...Transaction matching NOT
What are the "rules" for money's matching transactions? I
find that it constantly mismatches items when the name is
different and the amount is different. Is there a way to
direct it to "only" match exact amaounts? I don't need it
to attempt to match to similar entries.
Money 2004 deluxe.
I have the exact same issue. Have you had any luck
finding out why the problem exists or how to fix it?
>What are the "rules" for money's matching transactions?
>find that it constantly mismatches items when the...Cancelled transaction report
I'm looking for a report of cancelled/aborted transactions
Any help would be appreciated!
...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 (email@example.com.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...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...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...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...imaginary transactions?
I budget my money for bills and savings by making weekly "imaginary"
transactions for equal amounts that total up to the monthly bill that I am
budgeting for. The downside to this is that it makes balancing my account a
pain. Is there a way to make "imaginary" transactions for budgeting purposes
without the transactions scewing the results of reconciling my bank
In other words, I want to be able to make transactions that are not
calculated in account reconciliations. Is there a way to do this? Perhaps
with an option in each category for exclusion fr...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 ...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...Password expired because of scheduled transactions
Please help me regain access to my money file that I have
created when I first set up the account. I had scheduled
some transactions in the account, not knowing that my
password will expire because of the scheduled
transactions. Now I can't access my file,and I can't go
into passport to submit the security question, because
initially I did not use passport to set up my money
account. Please help!
Your posting is very cryptic to me. Please help clarify:
What makes you think "[your] password will expire because of the scheduled
What does w...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.
>...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....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...Exchange 2003 SMTP Service Timeout Waiting for Transaction
I have an Exchange 2003 Ent server on a Win2k box that is having symptoms
identical to what is described in KB831572. The hotfix provided there
doesn't apply, obviously.
I've been having to watch the server and manually run iisreset each time.
This works, but eventually things start hanging again. Time between the
crashes varies--the longest I've seen it go today is about an hour and a
I'm not sure why this started--I hadn't touched anything on the box in
several weeks. After it first started, I applied some Windows patches and
rebooted. I can't re...mail merge cannot continue
I have been using mail merge in Publisher 2000 on Windows
XP. But it suddenly started refusing to work, giving the
message "mail merge cannot continue". I have tried
reinstalling and uninstalling things I had done recently,
to no avail.
Did you have to relink to your database? If so, try changing your selection
in the checkbox for "First row of data contains column headers".
"Margaret" <firstname.lastname@example.org> wrote in message
> I have been using mail merge in Publisher 2000 on Windows
> XP. But it...Help with Mail merge
I have Publisher 2003 and am trying to merge and excel speadsheet of names &
addresses. My publisher document is 4 - 1/4 page postcards. I am merging a
list of addresses on the back side. I am getting the same name & address in
each of the 4 address blocks. How do I set it up properly. I have already
printed a test page it does move to the recipient on the follow page of 4. So
what I am getting is 4 1/4 page postcards for each recipient. I am a newbie
so any help is appreciated. Thanks
Are you using the postcard page setup? When you merge you can only have one card
on your scre...Centering Pictures in a Catalog Mail Merge
I'm creating a church directory. I've successfully merged three columns of
pictures into my catalog. My picture are all different aspect ratios and
sizes. I would like all of the pictures to be CENTERED in their columns.
However, when I merge my pictures they all show up on the LEFT SIDE of the
picture field of the merge area. I really don't want to center each picture
in every column of every individual page. I NEED HELP AUTOMATING THE
CENTERING OF MY PICTURE IN THEIR RESPECTIVE COLUMNS. I see two potential
solutions, but cannot figure out how to do either o...Merged accounts not staying merged.
I recently upgraded to Money 2006 Premium from 2005 Premium. Since I
upgraded I am now able to use online features for one of my banks that I have
not been able to use with previous versions. The problem I am having is that
it will download the new account information, I merge it with the existing
account and everything looks good. If I open Money again the next day after
my machine has been shut down it shows both accounts again and I have to
Also, I am still having problems getting online information for a few of my
banks, but I guess that is probably a Yodlee issue...How do I delete merged cells in Excel without deleting the final d
I have a column of dates that was formatted YY/MM/DD that I wanted formatted
MM/DD/YY. I split the cells then recombined the 3 new columns into a 4th
using the concatenate function. How do I delete the 3 columns without
deleting the combined data in the 4th?
First, if the data were really dates, you should be able to just format the
cells the way you want.
But if it's text that looks like data, you did ok!
You can either hide the original columns and keep the concatenation formula
--or convert the column of formulas to values (edit|copy, edit|paste spec...E-mail merge
I wonder if there is a way to e-mail merge in Publisher 2003