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...Save Workbook Under Custom Name
I have came across assistance to save a workbook using a macro which will
save a workbook with a name typed in a specific cell. It works nicely, but I
want to specify also the path and sub-directory in which the file must be
I have used the following code
The contents in Range "Name" will be the file name, but it will safe the
workbook under the new name in the same directory in which the master file
Once I am able to specify the path, I want to expand my macro to clear all
ranges as well, then the master wi...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...Formula Help! #3
I need to transform a date to week date , for example:
10/11/05 to Tuesday
Is there any formula can do this transform?
Thanks in advance
A1 = 10/11/2005
This returns a TEXT value = Tuesday
OR, you could just format the cell, A1, as dddd. This retains it's numeric
value but will display as Tuesday.
"Meme" <Meme@discussions.microsoft.com> wrote in message
> I need to transform a date to week date , for example:
> 10/11/05 ...Problems with Outlook 2003 #3
I have a user that has 2 strange problems with his Outlook 2003 SP2.
When replying to an email or writing a new one, he starts typing then goes
to use another app and comes back to finish his email.
He sends it and the receiver only gets what he typed at first, not the stuff
from his second time.
Also he gets emails with .GIF attachments that he cannot see. He only sees
it when clicking on reply, it appears suddenly as an attachment.
Pascal M. Dorion <firstname.lastname@example.org> wrote:
> I have a user that has 2 strange problems with his Outlook 2003 SP2.
&g...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...Unprotect a Shared Workbook
I wish to share a spreadsheet on a LAN drive. I foolishly assigned a
password so that only the responsible parties could open it. Now, when I try
to open a cell to make changes, I receive a message telling me to unprotect
the sheet. But, in REVIEW > CHANGES, that option is greyed out. HELP.
18 Mar 10
If the workbook is shared you must unshare before you can unprotect
> I wish to share a spreadsheet on a LAN drive. I foolishly assigned a
> password so that only the responsible parties could open it. Now, when ...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...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...Cannot view cells that contain 3 or more digit numbers
Every time I try to copy and paste data that contains 3-digit numbers o
more, I cannot view the numbers on the spreadsheet.
However, If I try to type in 3-digit numbers and one letter in tha
cell, I can view it.
How do I eliminate this feature, so that I can view numbers-only dat
Message posted from http://www.ExcelForum.com
what do you mean with 'cannot view'. How are these pasted numbers
displayed (please give an example)
"Jon Purgason >" <<Jon.Purgason.firstname.lastname@example.org> schrieb
im ...Gather data from several workbooks.
I know this is probably an easy fix, but I'm at a loss as to how to do it.
I've copied the two Macro's in question at the bottom of this email.
I have a number of (Source) spreadsheets/workbooks and they all have a tab
I have a separate (Destination) spreadsheet/workbook with a macro (primarily
written by Nikos Yannacopoulos from this newsgroup) called
Process_All_Workbooks. That spreadsheet/workbook is called "Update".
The Process_All_Workbooks Macro will call another macro and run it on all
spreadsheets/workbooks in a folder ...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...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...Concatenate #3
there is anyway with concatenate, when i am choosing a
text to format specific characters of this format?
A1 -- Actual
A2 -- 2003
B3 -- to ask "Act 2003"
Thanks in advance,
Truncating can only be done with string functions, for example
=LEFT(A1,3) & " " & A2
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Manos" <email@example.com> wrote in message
> Dear All,
...Creating a simple workbook in 2007
Wanting to create a simple workbook to record the inventory of items.
1st worksheet name In
2nd worksheet name out
3rd worksheet name shelf
On #1 the item would be entered when it arrives and then show on #3
When the item is sent out it would be entered in worksheet #2 and
again be reflected in total on #3
Is this maybe something that can be done using forms for the in and
out items so others can enter information in a form and have the
totals show on #3?
Link to a tutorial on this would assist greatly TIA
HTH. Best wishes Haral...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 ...Programmatically sales process crm 3.0
he is it possibel createing sales process through program
bacuse i need to insert some condition in the sales stage
so i am not able to use workflow manager
any one is implemented
please help me out
Sorry I can't help but to suggest looking at CRM 4 which does offer just
The CRM 3 seperation between work rules and sales process is very
restrictive but they are merged in CRM 4.0
"Jack" <Jack@discussions.microsoft.com> wrote in message
> he is it possibel createing sales process through ...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...check box size #3
Is there a way to change the size of a checkbox? I am working in a
spreadsheet that will not allow me to change the size of the box itself.
Thanks as always for your help!
You could cheat, and use a label.
>From the control toolbox, draw a label and set its BorderStyle to 1 -
fmBorderStyleSingle. Set its font to Wingdings and set its font size to
whatever best fits inside the label. Give the label the following code
Private Sub Label1_Click()
If Label1.Caption =3D "=FC" Then
Label1.Caption =3D ""
Label1.Caption =3D "=FC"
E...ecm2001 v5.3 winols shoemaster wilcom bentley amiable xshowsoft 306634772000014
We can crack or emulate any protection type: Dongle,
Hardlock, Hasp, Serial, Password, Hasp4, Flexlm, Sentinel,
Wibu, Eutron Smartkey, Hasphl, Proteq, All the Protections!!
email = firstname.lastname@example.org
email = xshowsoft at gmail.com
If you have some protected program, and want to crack it, we can help you!
Ecm2001 v5.3 professional, all checksums enabled download
Kess v4 all family enabled download
WinOls 1.38 download crack
wilcom 2006 full
HMI/SCADA System Zenon Software for Industrial Automation
SHOEMASTER v3.04 all modules download
Victor EAT Designscope 2.05 all modules...Workbook hanging Excel
I have workbook that was working fine when I saved it an hour ago but
when I try to open it, excel hangs.
It is not particularly complicated. A bunch of detailed numbers being
subtotaled in about 12 sheets. No links, no external references, no
complex formulas. Even the formatting is bland.
I was able to "open" it in MS-Access and import the tables... so it
seems to be OK overall - but I really need to get it back in Excel
with all the hours of formatting and polishing I did.
Any clues ?
When you say it is hanging, do you mean it will open but just takes a
long ti...Inserting pictures #3
I've been using publisher for over 8 years, and recently the version on my
laptop stopped inserting pictures.. all I have is an empty box. I can go
into the graphics manager and it shows its there big as life, but not in my
publication. Any ideas?
Have you made *any* changes to your system recently?
Microsoft MVP - Publisher
How to ask a question
"rcmedia" <email@example.com> wrote in message
> I've been using publisher fo...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.