Converting to PDF #2
I lose my hyperlinks to email addresses when I convert from Publisher 2002 to
a .PDF in Adobe Acrobat 6.0 Professional.
Do I need to upgrade to Publisher 2003 or can this be fixed?
While in a state of ecstasy after repairing his laptop, Ed sees a
message from Banks <Banks@discussions.microsoft.com>. On it is written:
> I lose my hyperlinks to email addresses when I convert from Publisher
> 2002 to a .PDF in Adobe Acrobat 6.0 Professional.
Publisher sends printable information to the printer driver.
As you cannot click a hyperlink on a printed piece of paper, Publisher
doesn...Pasting data from Excel
I'm not sure if I should be posting this question here or in the Excel
forum but here goes. Is it possible to copy data from multiple cells in
Excel and then paste them into multiple lines of the criteria section of an
Access query? For example, Given cells and values: A1- 1
I would like to be able to copy this data from Excel and paste it into an
Access query like : Criteria: 1
I am using Access 2002 SP3 and Exc...Problems with public folders #2
I am having two problems which may or may not be related.
1) In System Manager when I try to view or work with the public folder tree,
I get the following error "The token supplied to the function is invalid",
ID no:80090308. I cannot see any public folders or manage them at all after
2) Whenever anyone clicks on send/receive in outlook 2003, they get the
following error "Task 'Microsoft Exchange Server' reported error
(0x8004010F):'The operation failed. An object could not be found.'"
Does anyone have an idea of what the problem is for either...How do I add vertical lines to separate columns in Outlook 2003 #2
In Outlook 2000, all columns were separated by a gray
vertical line. I can't seem to set this up in Outlook
Any help would be appreciated
ARe you using Word as the message editor?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, mschwartz asked:
| In Outlook 2000, all columns were separated by a gray
| vertical line. I can't seem to set this up in O...Printing data forms
I would like to be able to print Excel data forms. Is
there a way?
In some event of the form (a button, a click of the form itself, whatever):
"Curious" <email@example.com> wrote in message
>I would like to be able to print Excel data forms. Is
> there a way?
If you mean the form you get when you do Data=>Form
with the form displayed, do Alt+Print Screen. then drop the form and go to
a new worksheet and do Edit=>Paste
This will put an image of the form on the worksheet and yo...Swedish characters in the Display name #2
I have a problem with Swedish characters in the senders' names on outgoing
Previously we have formatted the display names like:
Last name, First name
This is causing problems for some external recipients, since their e-mail
program reads this as two addresses (Last name as one name and First name as
I tried changing the display name for one user to "First name Last name"
instead, but then the Swedish characters are not shown when he/she sends an
external e-mail. Example:
"Åke Jönsson" becomes "Ake Jonsson"
"Åsa H...Print 2 receipts when selling item with rebate?
Is there any way to program rms to print multiple receipts on particullar
for example I sell an automatic pool cleaner that has two differant
mail in rebates and we always supply the customer with duplicate receipts
Out of the box, no. The easiest way is to train cashiers to use the Reprint
function when they need a second copy. The other option is to configure the
receipts to print 2 copies every time, but that's probably a waste of paper.
I'm pretty sure this could be accomplished as a customization using the HTML
status bar and QSBridge, but you would need a ...Consolidation Worksheet Data Sequence
I'm consolidating 3 worksheets into one by using Excel 2007 data
consolidation. The worksheets have a product number in column A and sales
figures in columns B, C & D for Jan, Feb and Mar. The worksheets are in
product number sequence. Not all product numbers appear on each sheet, so I
consolidate by category using "labels in left column" and "create links to
source data" to create a consolidation sheet in outline form. The problem is
the consolidated worksheet is not in product number sequence as I need it to
be. I have books on Excel 2007 and Excel 2003 and their ...2007 Schema Prep #2
I extended my AD last night for 2007 and have a few questions to verify it
I have a root domain (domain.local) that houses my schema master and a child
domain (domain.net) that has Exchange 2003. I ran setup /prepareAD then ran
setup /preparedomain: domain.net and both said they completed successfully.
However, I was expecting to see the new OU (Microsoft Exchange Security
Groups) in my child domain. It is present in my root domain. Is that all
In my child domain I now have a new global security group call Exchange
Install Domain Servers.
Last thing, the D...Formula query #2
I am trying to identify a formula which will add and then display th
number of times a number appears in a range.
For example, the range looks like this
The numbers which appear in the applicable range e.g. 1110, could b
any number between 1110 and 9999 and as such I cannot simply predefin
which number to look for.
I am hoping the output could like as follows:
4.....if formula #2
i have this formula in a cell D3 =IF(A1="F",B1&B2)
how can i make it multiple for example i want to add this IF(a2="G",B1&B3)
in D3 also.
"jaypee" <firstname.lastname@example.org> wrote in message
>i have this formula in a cell D3 =IF(A1="F",B1&B2)
> how can i make it multiple for example i want to add this IF(a2="G&q...Limits on Exporting Outlook Contact Data
Anyone know how to get custom fields, follow-up flags,
and/or the "contacts" (links between contacts) from MS
Outlook 2003 to Excel, CSV, Goldmine, or Act? The
standard export utility in Outlook does not offer export
of these fields. Most important is the links between
You'd have to write your own code to do this. A key issue would be what
information from the linked contact(s) you want to include.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode....Free Data Process/Query Tool
If you use Excel everyday and spend lots of time on data/text processing,
then you will find the this tool (UDQ Add-in) is very powerful and can
speed up your daily data processing work.
Currently the tool is free for everyone. Please feel free to distribute this
tool to your friends/colleagues if you think it is helpful to your work.
The following is a list of features/functionality of the tool:
1> Query/Import Data from Multiple External Data/Text/ASCII Files (Can
useful import data from hundreds of files within minutes)
2> Query/Import Data from Multiple Closed Excel Files (Can...Select Rows dependant on certain field data
How can I select certain rows in a spreadsheet based upon the text foun
in one column? To explain: All rows have a column that contains tex
"immediate" or "ongoing" or "closed". How can I select only the row
that contain the word "immediate" in that column?
When I say select a mean select as in ready to 'copy' or 'cut' tha
data ready to be pasted elsewhere.
I know what I mean :confused
Maddy's Profile: http://www.excelforum.com/member.php?action=getinf...sort data without changing pattern
I have a worksheet where every other row has a 'pattern' in it to help make
it easier to read across the spreadsheet.
The problem I'm running into is as I add new rows at the bottom of the
spreadsheet and then resort them into their correct place, the patterns go
with the sort and now the patterns have to be redone again the get them back
to every other row.
This will happen if your patterns are manually applied. It would be
better to remove that manual shading and to apply background colours
using conditional formatting, the condition being if th...Reminder is not work in default folder #2
I used as follow coding to send email to outlook client(outlook 2000):
Dim ll As New CDO.Message
Dim bb As New CDO.Configuration
bb.Fields(cdoSMTPServer) =3D "nc80012"
bb.Fields(cdoSendUsingMethod) =3D cdoSendUsingPort
Set ll.Configuration =3D bb
ll.Fields.Append "urn:schemas:mailheader:x-mess=ADage-flag", adBSTR _
...POP3 & IMAP4 services #2
I got problems on starting POP3 & IMAP4 services. Recently they cannot be
start after my exchange server restarts. At the beginning, POP3 cannot be
start automatically, later it's IMAP4. After I can start them manually after
the server has been completely started, I check event viewer, I found the
server did try to start IMAP4, but got error
"An error occurred while starting the Microsoft Exchange IMAP4 Service:
server instance number 1 failed to start with error 0x80040a01." At the same
time, an event also there, "Microsoft Exchange IMAP4 Service (Build..."X-axis crosses at..."
You can make the x-axis cross at the maximum Y-value, but is it possible
(without macro) to make it cross at the minimum value?
I should find that much more useful.
nsv's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26500
View this thread: http://www.excelforum.com/showthread.php?threadid=526722
When this is an issue for me, I just use some value <= the minimum Y
axis value that the data will ever see. So, if my Y data will always
be positive, I set the X axis crosses...Customizing Contact Data
Is there a way to customize contact card/data to collect data from others
that I want to use rather than the generic that Microsoft has used?
Thank you very much.
"TallPaul" <TallPaul@discussions.microsoft.com> wrote in message
> Is there a way to customize contact card/data to collect data from others
> that I want to use rather than the generic that Microsoft has used?
What type of information do you want to collect?
Brian Tillman [MVP-Outlook]
> Is...2 accounts being sent under one address
I currently have two accounts in my Outlook 2000. email@example.com &
PPP@provider.net. The PPP@provider.net is the primary account. When sending
an email from the firstname.lastname@example.org, it still shows as the PPP@provider.net
address, so in turn I get any replies to the email@example.com back to the
PPP@provider.net. Is there any way to make the reply address or the address
of sender shown to the firstname.lastname@example.org account?
You said you had 2 accounts.
You then listed 2 email addresses.
Those are not the same thing.
Clarify your post.
"jeepstr9" ...Compare 2 Worksheets Create a 3rd depending on results
I have a unique problem that none of the other posts or shareware seems
I have 2 worksheets (orig.xls and new.xls) that are 15 columns wide (to
the "O"). The data is just numbers but the second column either has the
words: "new" or "cancel" which is important as you will see. I need to
compare the two worksheets and create a third worksheet (update.xls)
depending on the three possible results:
1) If a row is removed in the new.xls file = copy the row from the
orig.xls file and make the 2nd column "Cancel"
2) If a row is added to the new.xls...Printing Externally #2
That works great...except it word brings up a message box stating tha
Word is currently printing, if you exit, you will cancel you
print.....and if i click no, so i dont close word, it still doesnt wan
to print...any suggestions???Thank
tess457's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1393
View this thread: http://www.excelforum.com/showthread.php?threadid=26662
There's a setting in MSWord that allows you to do background printing. I've
turned this off--so Word do...money 03 same funds in 2 accounts
I have 1 tax defered account and 1 non-tax defered account. They both have the
same mutual fund in them. Money won't let me use the same symbol twice for 2
accounts. Any thoughts ?
"Fruehauf2000" <email@example.com> wrote in message
>I have 1 tax defered account and 1 non-tax defered account. They both have
> same mutual fund in them. Money won't let me use the same symbol twice for
> accounts. Any thoughts ?
...OT: Trend Micro WFBS SP2 beta starting 2/15/10
Anyone interested in helping to improve the WFBS product should join the
beta...and all future ones.
Gregg's pet peeves:
First of all, what does a peeve look like, and why would anyone want one as
Peeve #1: Apostrophes: when in doubt, leave them out! You will be correct
more often than not.
Its = Belonging to it. For example, "Look at the sky. Its color is blue."
It's = It is. For example, "It's hot today."
It's = It has. For example, "It's b...Obtain data from list
I want to get the data from the list on to a cell in
I have 2 sheets - On Sheet 1 - I have drop downs.
Whatever is selected in the list - I want to show that
value in a cell on Sheet 2.
Any help is greatly appreciated.
I think if you just change the properties of your dropdown
so that the linked cell refers to the cell on your other
sheet, it should work fine. Right-click on the dropdown
and goto properties...Linkedcell.
>I want to get the data from the list on to a cell in
>I have 2 sheets -...