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...Splitting a cell within a table
I'm attempting to split a cell within a table. I click within the cell that
I want to split and then click Table but "split cells" is grayed out. Please
You can only split previously merged cells.
"Anthony" <Anthony@discussions.microsoft.com> wrote in message
> I'm attempting to split a cell within a table. I click within the cell
> I want to split and then click Table but "split cells" is grayed out.
> Thanks...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 <email@example.com> wrote:
> I have a user that has 2 strange problems with his Outlook 2003 SP2.
&g...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 ...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...Linking Cells: Excel into Word Document
After reading through the help files for Excel 2002, it seems to me that
there is no way, except for programming, to have just a range of cells in a
worksheet be linked to a Word document.
Here is what I am attemping to accomplish: Using Word to create an extensive
document for a database proposal. Using Excel to document the all of the
required tables (since nothing has been created in Acces and I am new
databases), drawing diagrams with lines and other database objects. Would
like to be able to insert/link certain cells from a worksheet (which would
be many inserts/links) into t...Returning left part of cell before a character
I have a text file report that is not customizable. I import that into
Excel. There is a field where relevant data ends after the colon
character ":". Can someone help me with a formula I can put in column C
that evaluates the corresponding cell in column B and brings back all
text to the left of the colon mark?
freddy: 45345 sldf
jeff: 45422 fdflh
In this case I want to return the characters to the left of the colon:
Thanks in Advance!
You can use the formula
This wi...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...Copying Cells #2
How can I copy a range of cells (some of which are filled with gray) from one
worksheet to another worksheet without deleting any data that may be in the
same range on the second sheet.
Say the area is from A1 thru B2.
Select A1 thru B2 on the first sheet and:
Edit > Copy
then select cell A1 only on the second sheet and:
Edit > Paste Special > Formats.
Gary''s Student - gsnu200808
> How can I copy a range of cells (some of which are filled with gray) from one
> worksheet to another worksheet without deleting any data that may be in ...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...Run macro from clicking on a cell
Is there a way that you can run a macro from clicking on a specified
cell with a hyperlink or function. I can use the shortcut key, but some
'here' say it is not user friendly to have to use a shortcut key. help
files haven't helped.
jrd269's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23815
View this thread: http://www.excelforum.com/showthread.php?threadid=376404
> Is there a way that you can run a macro from clicking on a specified
> c...Linked Cells #8
How do I have a link jump to the linked cell vs. showing me the contents?
Without knowing exactly what you're asking, you need to hyperlink the cell
you want to jump from, select Bookmark, and then enter the Cell reference
that you want to jump to.
"Jill" <Jill@discussions.microsoft.com> wrote in message
> How do I have a link jump to the linked cell vs. showing me the contents?
I need cells to show values when a check mark is entered. Like if I check
this box then the value is 1.0 - this needs to be in several columns that I
can then add the values together from
If you're using the Checkbox from the Form toolbar, right click and go to Format
Under the Control, you can link to a cell, select a cell "Z1" just for
illustration, you can pick any empty cell. That can be visible or not but it
will return "True or False".
Now the cell that will return a value, just type =if(Z1=true,1.0,""),Remember to
chang...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...Moving an active cell
I need a snippet of code that will (when you use ctrl-d) look at the active
cell, move the cursor down 9 cells (same column) and make that cell the
active cell, no matter where you start on the spreadsheet.
Thanks to everyone.
Hope this helps. Otto
"Howard" <Howard@discussions.microsoft.com> wrote in message
> I need a snippet of code that will (when you use ctrl-d) look at the
> cell, move the cursor down 9 cells (same column) and ...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...Deleting Parts of Cells
I have a list of information in a column. All the information has the format
of having numbers and letters then a / and more data. I only want to look at
the data to the left of the /. So, I would like the data to the right of the
/ deleted, including the /. For example, I need YYY9/5 to read YYY9. Any
You could bring it into Excel as a txt file
open the txt file in excel
Text Import Wizard will appear
check > other and type the "/" into the box
you should have a separation where the / was.
>...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...I Need to change reference sheet for all cells on a form
I am copying a spreadsheet to make summary sheet and I need to change which
sheet the cells are referncing on my copy. Some of the cells refer
to for example, =PRIOR YEAR!B3, some of the cells use a command
to Round(PRIOR YEAR!B3/100), I would like to change all the references that
currently refer to "PRIOR YEAR" sheet and make them "CURRENT YEAR" sheet, so
my references would look like this =CURRENT YEAR!B3 and Round(CURRENT
YEAR!B3/100). I am curious if a paste special, or shortcut exists that can do
this quickly so I dont have to go in and manual...Printing Patterns in Cells
Hell, I am trying to print a worksheet I created with colors and patterns.
The colors print, but the patterns don't. They show up in print preview. Can
anyone enlighten me please? Oh, and is there a limit to the width of a
worksheet. Mind will only go as far as column IV. Thanks for your help
Tab is supposed to move one cell to the right. Mine moves from column A to S,
to AK to BC and so on. It always moves in hughe ranges. The arrow works,
however, I am used to the TAB and want to continue using that. Ther is
nothing in the set-up screens that would indicate this possibility. What am I
Thanks for helping
Click on Tools/Options in Excel's menu bar, then select the Transition tab
and uncheck the CheckBox labeled "Transition navigation keys".
"Dies-und-Das" <DiesundDas@discussions.microsoft.com> wrote in message
news:E119...fill random cells in an area
I have this problem: in one sheet a have 4 values (in the columns ABCD
row1) and I want to use this 4 values to fill randomly 4 of those 20
cells of the range A1:A20.
How to do this?
Message posted from http://www.ExcelForum.com/
i forgot something: range A1:A20 is in a new sheet not in the same shee
with the values. Sorry
Message posted from http://www.ExcelForum.com
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,
...Cell Range Names
I've looked around, but can't find if it's possible for me to "Lookup" in
column of cells based on group criteria and automatically add a Range Name
I'm busilding a business spreadsheet that has numbered day of the month in
column A and the related day name in column B.
I want to do comparisons with previous years same "Weeks", like "week 1",
"week 2", etc. starting from the first Saturday of the year to the last
Friday of the year. I need to figure out how to lookup, group and