Pre formated workbook. Can it be done?
I have several Access databases and I was infomed for a quick and direty way
I can make a pre formatted workbook then use the transfer spreadsheet for my
report. I dont want the spreadsheet to lose its formatting everytime a user
runs a report. Is anyoen familiar with this process? I can do the trangfer
from Access and use the recorded macro on Excel's end but is there anything
else I need to do?
Thanks in advance
you need to save your transfer workbook as a template delete all the info out
of it and then save it again.when you open a template you open a copy,not the
template itse...Can you drag/drop rows w/o using Cut/Paste
Can you drag/drop rows (or columns) in Excel without using the Cut/Paste
keystrokes. What I would like to do is be able to highlight a row, click the
Ctrl button, and then drop it on another row where it would be moved to?
If you select the row and click on the border and drag it, you'll move it.
Experiment a little.
try selecting and dragging.
try selecting and dragging while holding the shift key
try selecting and dragging while holding the ctrl key
Heck, select a cell and rightclick and drag it where you want. When you let go,
you'll see lots of options.
...Can we share Outlook Contacts on a network
Is there a way to share and/or synchronize "Outlook" contacts on a network
not natively, within outlook
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exc...Add extra mailboxes to users outlook.
We have Exch2003 - and use OutLook 2003/2007.
I try to add mailboxes and public folders to some users OutLook and we do
this manually - these are support, spam and others.
How do we this in a smarter way - gpo, script - any ideas?
Create a security group with the users you want. Then add that security
group to the mailbox/public rights. Then you just have to manage the
security group from now on.
"Tor-Magne" <firstname.lastname@example.org> wrote in message
> We have Exch2003 - and use OutLook 2003/2007.
&g...More than one line in a single cell?
How do I enter multiple lines in a single cell in a column? I need more than
one line of information to fit it all in a cell of a row in a column. Please
Use Alt-Enter at the end of each line, and format the cell for Wrap-text
Vaya con Dios,
> How do I enter multiple lines in a single cell in a column? I need more than
> one line of information to fit it all in a cell of a row in a column. Please
...Multiple reply-to email addresses in one account
Operating System: Mac OS X 10.6 (Snow Leopard)
I have a catch-all email account, and would like to be able to choose between different reply-to email addresses, is that possible in Entourage? <br><br>Example: <br>
main email@example.com <br>
firstname.lastname@example.org <br><br>So when I create a new email, I would like to select which email address to use. <br><br>In Apple Mail you simply add multiple emailaddresses (separated by comma) in the account settings. <br><br>kind regards <b...i want to download "Advanced Windowsby Jeffrey Richter" ISBN:1572315482 please any one give me the link to download this book for free thank you #2
i want to download "Advanced Windowsby Jeffrey Richter" ISBN:
1572315482 please any one give me the link to download this book for
free thank you
Please can anyone send this book to my gmail account.
My account is email@example.com.
Get over this man. You already posted this. Stop this nonsense of sending
books to you email account.
<firstname.lastname@example.org> wrote in message
> i want to download "Advanced Windowsby Jeffrey Richter" ISBN:...Location of Contacts and Rules & Alerts
I moved my outlook.pst file and found that the Contacts folder and Rules and
Alerts information did not come along to the new location. How can I find
You posted no information. Explain what you did. Include your version.
"Gary Lindgren" <email@example.com> wrote in message
>I moved my outlook.pst file and found that the Contacts folder and Rules
>and Alerts information did not come along to the new location. How can I
>find this information.
> Th...Having repeated concepts just ones
I have a column (A) with different concepts repeated several times, what I
want is to create another column (B) having the concepts just 1 times. Ex.
Column A Column B
Bikes Air Planes
I will really appreciate if someone can help me with this.
You need to copy and paste your data in Excel and then sort the data
alphabetically. Once this is done, in column B you need to enter the
In B! enter: =A1
In B2, ent...Mail SENDING from more than ONE domain on one Exchange box
An Exchange guru had taught this in a Microsoft seminar before but I
happened to not write it down. There's a way to trick Exchange to send
emails on one Exchange box with one Default recipient list to go FROM more
than one domain. Anyone here has any idea? Thanks.
You can change the default SMTP address of any user to any domain and that
will be the from address.
Whether people will receive the message depends on whether DNS records
correctly point both domains at your Exchange server.
"Gee0" <firstname.lastname@example.org> wrote in message
news:85idnVOkeoj4UsjfRV...mailbox manager reports???
when I run mailbox manager in Audit mode in the report I get on of the lines
says: Messages Moved
Moved to where? I know that in actual deletion mode you can specify where
messages are moved (the Deleted Items Folder or the System Cleanup Folders)
but you do not have the possibility of specifying this in Audit mode. So
what does Messages Moved mean in the contex of an Audit run of Mailbox
...A rule that places a new email in a sub Folder doesnt get displayed
Create a folder; Create a rule that moves new mails to that folder; Happy
as larry. When a new mail arrives, outlook shows a blue numeric value next
to the folder to indicate unread messages.
However, if you add another folder to the folder created above, ie a sub
folder and create a rule to move new email, you have to have the tree fully
extended to be informed of a new email.
Is there a way to see if an new email has been sent to a sub folder without
having the tree list expanded?
What version of Outlook and what Service Pack level?
Milly Staples [MVP - Outloo...Exchange Server 2003 Hosting Provider
My company is looking to move from an inhouse Exchange
Server 2003 to a hosting provider. We would like to know
of any links of reviews of Exchange Server 2003 hosting
providers or any recommendations.
Thank You in advance,
Try this link
"Sam" <email@example.com> wrote in message
> My company is looking to move from an inhouse Exchange
> Server 2003 to a hosting provider. We would like to know
>...First Exchange Client and Exchange Server 2003
I have a customer that is running Exchange 5.5 on an NT
4.0 box and they have several stores that are running the
very first Exchange Client, not outlook but Exchange
Client. Does anyone know if this will work with Exchange
Server 2003? I know several functions of E2K3 server will
not work with the client such as cached mode and some
filtering options. What I would like to know if it will
work at all.
Yes, you can connect to a mailbox using the old Exchange Client. I would
advise, however, you/they don't open any of those mailboxes with a higher
version Outlook client and...Installing HQ Manager on a separate computer as HQ Server
Can you install HQ Manager and Administrator on a separate computer as HQ
Server? If you want to use your existing sql server to create the databases,
but manage from a different computer, how do you connect them?
Hello HNLuhar - actually that's the recommended setup - run HQ server on a
different machine than your database and other computers running HQ manager -
you connect the application using HQ administrator, which gets installed on
all computers - use this to point the executables (HQ manager, HQ server) to
the static IP address you assign the ma...Can't reprint packing slips
For some reason, nothing comes out when I try to reprint packing slips. I go
to Transactions>Sales>Print Sales Documents, then fill in all the appropriate
information - including checking the Reprint Previously Printed box. I get
the print dialog asking for the print destination, but when I click on 'OK',
What am I missing?
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
This may be a dumb question but......when in the process are you attempting
this? If the order has been in...Can't open in safe mode
My outlook is freezing on opening. I went to open using
Run and adding '/safe' to the command line. I get a
message saying it can't find the command. I tried in and
outside the quotes, as well as other /switches. Same
message. Will open without /switch, but that won't help
me fix the freeze problem.What to do next?
You're probably quoting it wrong then. It should look like this;
"C:\Program Files\Microsoft Office\Office11\Outlook.exe" /safe
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Create an Office XP...How can I disable outgoing email being sent as attachments?
When I send email I am being told from the person receiving it that it has
been sent as an attachment that they have to open to read. How do I disable
JERMAINE <JERMAINE @discussions.microsoft.com> wrote:
> When I send email I am being told from the person receiving it that
> it has been sent as an attachment that they have to open to read. How
> do I disable that feature?
Try sending your message in plain text.
...Can't logon after IP change
After an migration to a new ip subnet We can't logon to CRM with any user
After Authentication and display of the web interface we get a generic error
When using the deployment manager we get a specific message that
mscrmdervices is not responding and it shows the old IP address.
Is there a configuration file some where that tells the apps what IP the
MSCRMService is listening on?
I already checked the IIS site bindings and they are on the new IP.
If you are changing the server name/ip that CRM is on you also need to
update the registry of ...where can I find file cp561401.cab?
I am trying to install Office 2003 into a new laptop and it is looking fo
rfile CP 561401.CAB. I can't seem to find it on line. Where can I get it?
Cab files are on your Offoce CD.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"rutt" <firstname.lastname@example.org> wrote in message
>I am trying to install Office 2003 into a new laptop and it is looking fo
> rfile CP 561401.CAB. I can't seem to find it on line. Where can I g...Excel
If the high contrast setting is turned on you won't see the fill colour.
There's information in the following MSKB article:
OFF: Changes to Fill Colour and Fill Pattern Are Not Displayed
Excel FAQ, Tips & Book List
I'll hazard a guess.......more info would have been nice.
If this is a problem with all files with coloured cells, the Windows OS high
contrast setting may be turned on. There is information in the
following MSKB article:
OFF: Cha...Upload/Update files on a server
(sorry for the cross post as my post in WindowForm gets no reply yet).
I'm not sure if this is the right group to ask. Please let me know
where this question should go to.
I have a window program in which I would like my users to be able to
upload files to a centralized folder risde on a server. One way to do
this is to make that centralized folder a shared folder and grant
users rights to access their files on the server. However, my network
administrator would prefer my program to logon to the server with a
separate credential (local account to the server) to upda...Preview Pane in Outlook Web Access on 2003 exchange server
Is ther a way to globally set the default value for the reading pane to Off
for all folders under outlook web access?
eli silverman wrote:
> Is ther a way to globally set the default value for the reading pane
> to Off for all folders under outlook web access?
Microsoft Outlook Web Access 2003 Web Administration tool should be able to
Download details: Exchange 2003: Outlook Web Access Web Administration:
MSExchange...Rules Won't Stop Running
Somehow my rules got messed up. Every email is being sent
to a folder I created called 'SPAM'. I have deleted every
rule, but it didn't help. Thanks for the help. Here's my
Outlook 2002 SP3
Windows XP Pro, SP1, fully patched
Member of a Win2K server/Exchange 2000 domain
Neil <email@example.com> wrote:
> Somehow my rules got messed up. Every email is being sent
> to a folder I created called 'SPAM'. I have deleted every
> rule, but it didn't help. Thanks for the help. Here's my
> Outlook...why i can't see menu bar?
why I can't see menu bar in office 2007 specially (Access 2007)
Because there isn't one? Office 2007 uses a ribbon rather than menus.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"a" <firstname.lastname@example.org> wrote in message
> Thank you
> why I can't see menu bar in office 2007 specially (Access 2007)