How to use outlook address in Excel
I have an Excel sheet which I use as an invoicing-application. I would like
to retrieve address-data from Outlook where I keep all my contact-data of my
customers. So, I want to select a customer from my Outlook contactlist when I
am writing a new invoice in Excel.
In Word, I have a macro which does this, but unfortunately the
Application.GetAddress does not work in Excel.
Can somebody help me ?
"Henny Slokker" wrote:
> I have an Excel sheet which I use as an invoicing-application. I would like
> to retrieve address-data from Outlook where I...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...how to select multiple text boxes in excel for formatting
I am trying to select multiple text boxes for formatting the font but seem
unable to select all of them other than to click on each one individually.
Is there an easy way to select all of the text boxes at once?
To select multiple objects on the sheet --
Click on one object
Hold the Ctrl key, and click on additional objects
To select all the objects on the sheet --
Choose Edit>Go To, click Special
Select Objects, click OK
Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:
Select the Commands tab...Excel Drop Down Box
I'm trying to edit an excel worksheet that has drop down boxes.
However, the drop down boxes are not typical forms. These drop dow
boxes appear to be normal cells (They contain text). When I click o
the box, a little gray box shows up w/ a down arrow to the right of th
cell. However, if you right click on the cell, there aren't an
property options that are displayed.
I was wondering if anybody had any idea what kind of drop down box thi
is. How can I edit or create one
Message posted from http://www.ExcelForum.com
It sounds like it's under Data|Validation.
chris313 wr...IE8 uses 95+% of cpu after update to sp3
I just updated to XP sp3 and did updates after that and IE8 is running so
slow. I loaded task manager to see what was happening and IE8 was using up to
My system was a slow XP sp2 but did a disk clean and defrag and it was
running a lot faster. Apps load and run faster after sp3 but not IE8.
Thanks for any suggestions
> I just updated to XP sp3 and did updates after that and IE8 is
> running so slow. I loaded task manager to see what was happening
> and IE8 was using up to 99%.
> My system was a slow XP sp2 but did a disk clean and defrag and...excel margin issues on landscape
When I print a spreadsheet I cant get it to print to the full page - it
prints smaller unlike older excel program.
Also when i set the margins for a spreadsheet the left hand margin wont move
over to the edge of page like right hand side?
In Page Setup: If you are using the Scaling option to print to a certain
number of pages wide by pages tall and/or you are using the columns to repeat
at left, try:
- clearing the number of pages tall value (so that it is blank), and/or
- if you are printing to one page wide, remove the columns to repeat at left
"Peter MB" wrote:
>...Amex/Costco account update not working
Wondering if anyone else is having issues update and Amex/Costco account in
2006 version. It was working on 2004 version but has been broken since the
Downloads from Amex/Costco work fine here.
Explain what "issues" are you experiencing?
"Andrew" <email@example.com> wrote in message
> Wondering if anyone else is having issues update and Amex/Costco account
> in 2006 version. It was working on 2004 version but has been broken since
> the upgrade.
I had problems wi...Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing
Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
Is there still a way of accessing macros via Alt+F8?
Any suggestions appreciated.
ALT+F8 works for me in E2007. What do you mean by 'I get is a series of
ribbon help letters'
> In Excel 2003 I used to be able to list all macros in a workbook by pressing
> Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
> Is there still a way of...Can I only allow printing to pdf in Excel?
I have created a template in Excel which has been set up so that the layout
is perfect when printing to pdf (which is how the document will mostly be
used) but the layout changes if printing direct to our printer. Is there a
way that I can ONLY allow printing to pdf from this document?
You may consider using some VBA to achieve this.
One way is to use the Workbook_BeforePrint event and specify the pdf printer
in the PrintOut method, eg:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PrintOut copies:=1, ActivePrinter:="CutePDF Writer on CPW2:"
Pl...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...query will not write to excel
I have set up a query to a Foxpro .dbf file in a database from excel. When I
tell Excel to import the data it it appears to be working but never seems to
return the data. Running the same query via msquery.exe returns the data with
no problem. Can anyone tell me what the problem is ?
...Inserting formulas with PL/SQL
I'm not familiar with PL/SQL, but my friend is using it to place data
into an Excel spreadsheet. She can place strings into the
spreadsheet, but cannot figure out how to put in formulas.
Specifically, she is trying to place web links into a column of cells.
She is able to put in 'http://www...' as a string, but then cannot
link from the cell.
I suggested using Excel's hyperlink function, but again it ends up as
a string, not a function.
htp.p('...How to make a column of formulas all ROUND
I created a spreadsheet in which I have a column of formulas. Most of these
fomulas are simply pulling a single number off another sheet. I want to make
all the formulas ROUND versions of the existing formula without having to go
into each cell and making the change. They are not in order to which I can
just make the first fomula a ROUND fomula and copy down. So, is there a way
to select a range of cells and make the existing fomulas all ROUND versions?
Would this help?
Dim mystr As String
Dim cel As Range
For Each cel In Selection
If...FWD: See this corrective update which comes from the Microsoft
Content-Type: multipart/related; boundary="wbqnfbpivy";
Content-Type: multipart/alternative; boundary="lzvglunuqmeli"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to maintain the se...Updating large pivot source data
I'm experiencing the following problem with a very simple macro in Excel
2007 to update pivot table data source. That is, my data has more than 74000
rows and I'm trying to update the source data with the following code:
Dim rng1 As Range
Set rng1 = Sheets("Test_sheet").Range("A1:A74000")
PivotCaches.Create(SourceType:=xlDatabase, SourceData:=rng1, _
The problem is that the code ...EXCEL FORMULA #28
I'm trying to fine a formula which would show me how much money I would
save on a mortgage if I were to pay additional principal each month--in
addition to paying the additional principal how long would it take to pay
I'm looking at a 160k mortgage at 7.5 for 30 years. I'll like to pay this
off as soon as possible by paying additional principal each month.
There are tons of free templates at:
Maybe you'll find something you like.
> Good afternoon,
> I'm ...OLE: Excel.Application
in VB.Net, I use Excel to display results :
dim xl as new Excel.Application // creates an Excel process
// snip (putting values into cells)
xl.Visible = true
If the user closes the Excel file and then my program,
the Excel process is killed in memory, which is good.
If the user closes my program first and then the Excel file,
the Excel process remains in memory !
How can I make sure the process will be killed ?
You need to set
(and before that ensure that excel doesn't halt and ask things like "save
changes?" on quitting) somewhere in your p...Export relationship information from Visio to Excel
Is there a way to export information regarding relationships from a visio
diagram to an excel spreadsheet?
In addition, is there a way to tell the excel spreadsheet to eliminate or
change a relationship and for that action to be applied onto the visio
as a general answer I'd have to say "no, not without custom code". You
didn't define what you meant as a relationship.
"Ivan Salas" <IvanSalas@discussions.microsoft.com> wrote in message
> Hello all,
&...startup excel euro symbol
when i digit € symbol inside any application excel 2007 automacic startup and
for me is impossible to use this symbol anywhere, i use windows xp
professional ..have you a response to solve this problem?
...Excel 2003 Print Issue
I have created a spreadsheet to help with a university engineering
assignment and I have added a worksheet that is basically an
automatically generated report of all the calculations.
I have set the Print Area up in such a way so that the results are
printed out in well defined pages (e.g. page 1: title page, page 2:
summary of input variables, page 3: summary of calculation results
etc). The report is arranged vertically in the worksheet, so the pages
are 'stacked' on top of each other.
It prints out fine in Excel 2000 and 2002 but I recently upgraded to
Excel 2003 and now find tha...Formula for Date
I'm new to formulas and just want to display the current date in my
outlook form (e.g., December 18, 2004). What I've done is created a
combination text field where I have the following fields:
[Email Opening Date]
Dear [Full Name]:
When I send a new message, I then copy the values into my email instead
of copying the data (name, title, address, salutation) one field at a
time. This allows me to personalize the email. The problem is that I
do not know what to do to with formulas to show the current date as I
Thank...short cut for copy past w formulas??
I hope I can explain this right.
If Sheet 1 cell 1A were to equal Sheet 2 Cell 1A
I need a quick way to copy that formula so on sheet 1 cell 9A will = sheet
2 cell 2A , sheet 1 row 17 A = Sheet 2 Cell 3A and so on ..
If i do a straight copy past it equals the row on sheet 2 which is no good
to me.. I only have about 300 cells to do so any short cut would help.
Thanks in advance.
In sheet1 cell A1 enter the formula
Then copy this down to every 8n+1'th row
Return email address is not as DEEP as it appears
"DR, Bob" <bob@mai...Bank Acct Auto Update without sync to MSN
I would like to have my accts auto update without syncing to the MSN website.
I would also like to not use the passport password. When I remove the
pasport password and create a local password, I no longer am able to auto
update from my bank. Do I have to have the MSN passport and web access to do
this? If not, how do I do this? I have Money 2005 Deluxe on an Windows XP
Pro system. I am creating a new money file so I can wipe clean and try
In microsoft.public.money, fire_317 wrote:
>I would like to have my accts auto update without syncing to the MSN we...excel 2000 message
excel 2000 message - 'cannot use object linking and
Were they hit by the MSBlast worm?
One poster (Lutz Meyer) guessed that this was the cause of his problems. I
haven't seen any confirmation/denial, but you may want to read his post:
Post back with your results. I'm curious if that was the problem. (It's come
up quite a few times since MSBlast hit.)
bill bootle wrote:
> excel 2000 message - 'cannot use object linking and