Where do I start, and how do I find the basic information, needed to get
started building custom reports in Peachtree Accounting using VBA or
Charles L. Phillips
Visit here and ask that same question:
MS Excel MVP
"Charles L. Phillips" <email@example.com> wrote in message
> Where do I start, and how do I find the basic information, needed to
> started building custom reports in Peachtree Accounting using VBA or
is it a feature in money to not allow financial
institutions statements that have the header of investment
to download into retirement 401k and 403b accounts
downloaded into money 2004.
...using Outlook on local machine with domain user account
I have a small network running with w2k domain.
Client computers run under w2k pro and have Office 2000 installed.
* When I log on locally (with administrative privileges) Outlook works fine.
* When I log on to the domain (using any domain user account) Outlook does
* When I add a domain user account to local administrators group and log on
to the domain Outlook works fine.
How to make Outlook working when domain user account is used (without
administrative privileges on local machine) or I must use an account that has
administrative privileges on local machine to run Outlook?
...Outlook email password always requested
I use MS Outlook 2002 SP3 in Vista. The email password is asked for every
time. Is there a fix for this?
A known issue - see http://www.outlook-tips.net/howto/vista.htm
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, James Truelove asked:
| I use MS Outlook 2002 SP3 in Vista. The email password is asked for
| every time. Is there a fix for this?
"Milly Staples [MVP - Outlook]" <What@ever> wr...Missing Text in emails replied to via Lotus Notes
I use Outlook 2003 to create emails. Using either plain
text or html format, when I send the email to a colleague
who uses Lotus Notes, and they hit reply to the email type
their response. I do not receive or read any of their text
in the incoming mail in Outlook. If I use an alternative
Email client such as Pegasus, I can read their text. What
can I do to fix this, how can I get the missing text back
from within Outlook, without getting them to re-create a
new email with their response?
I think that I have solved this.
I think that when the option to remove blank lines is
Ou...How can i change this VBA project According to Indian Numeric
I got a VBA project from MCServices, But problem is How i should modify this
to display This Numeric Value like -
It should display in text = Twenty Five Lac Fifty One Thousand Five Hundred
Twenty Five Rs and Thirty Five Paise.
I m sending Herewith my VBA project. Pls change necessary and help me.
Rao Ratan Singh
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = &...How do I change the format of how my active cell in Excel is view.
I sometimes have trouble locating which cell is active in my Excel worksheet.
I would like to be able to change it to something other than just a heavy
Here is one way that highlights the row and column of the activecell.
Private Sub WorkSheet_SelectionChange(ByVal Target As Range)
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 35
.FormatConditions.Add T...Allow a contact to use its Account's addresses
Since contacts associated to an Account all use the same addresses, allow a
contact to use its Account's addresses
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=9c809...format changes on pivot table although preserve formatting is che.
Post the question the body of the message, subject lines get truncated
"Aannd" <Aannd@discussions.microsoft.com> wrote in message
...Signature format changes in replies with Outlook 2007
We are using Outlook 2007 and are finding that our signatures will sometimes
change font and spacing in reply messages. Is there a way to fix this?
...Varied Account Balances
This is in reference to my Checking Acount set up in Money 2004
When I look at my Account List, Account Register and Cash Flow, all three
have a different current balance. My assumption would be that all would be
the same as the Account Register drives the Cash Flow.
Any suggestions on the discrepancies?
Account list will show the balance of the account with all future
transactions as seen in the account register included. Account register
shows the individual items with the rolling balance. The final figure should
match the account list. Cash flow starting figure will be today'...fonts are changing and text disappears
when i open outlook 2003 all my maps on the left side of the screen are
looking well and normal. But after a wile the font changed or a piece of the
name/text disappear. Very stange i think. When i close outlook and turn it
back on, everyting is back to normal but not for long.
...Changing Free/Busy Publishing Time
I wanted to change our publishing time from two months to 12 months. In
order to do this I implimented a group policy that changed this time.
The group policy seems to be effective in changing that value, however
when it comes to scheduling meetings, only two months are visible. The
only way I have found to rectify this is to run Outlook with a
/cleanfreebusy switch once. However, it doesn't seem practical to do
this across a large number of users. Is there any way I can do this
server side to acheive the same effect?
On 28 Jul 2006 09:40:46 -0700, JamesSKemp@gmail.com wrote:
&...Not getting all my emails
computer with XP and OE crashed. Have W7 now... downloaded windows live...
can send and recieve but not getting all of my emails... (have other accounts
set up with same email address.. am getting emails there but not all in W7).
Have a Pop3 account. Never any problems with OE... don't understand why I
recieve some emails and not others... some emails I send and people reply to
I am not getting either. Any help would be appreciated.
Are these actual different accounts, or different e-mail addresses that
are aliases for the same Inbox? How are they set up? (i.e. rules moving t...My Account Settings, Icons, Files are "Missing"
Recently, I booted up and discovered that my personalized icons (under
my account) had disappeared from the desktop. The Account Name is
"Gilxxx" but my data is under "Curxxx"
When I looked closer, I was able to see the directory structure in my
"Documents and Settings" folders, but none of the files.
The files are there, however, as I can play MP3s in Windows Media
Player (and they are in my My Music directory). And, when I tried to add
new desktop icons to "re-create" my old desktop, Windows tells me that a
shortcut with that name alread...Changing Fonts
Using Publisher 2003 with Office SP2.
I have installed 3 new fonts (.ttf files) through Control Panel - Fonts -
Install New Font and they now appear in the list in Control Panel - Fonts. I
want to use these fonts in a publisher document. How do I get the new fonts
to appear in my list of fonts in publisher? Publisher has been reopened since
installing the new fonts and I have also restarted.
Any help would be great! Thank you!
> Using Publisher 2003 with Office SP2.
> I have installed 3 new fonts (.ttf files) through Control Panel -
> Fonts - Install New Font and the...Where have my emails gone?
we are in the process of merging with a new parent company and
currently have two mail boxes setup in Outlook. I copied some mails from
one mail box to the other and they have left the original mailbox but do not
appear in the new one. However, I can find the messages by using a Search
Folder. Apparently, the messages are in a folder called IPM_SUBTREE. What
I have a problem with receiving email from a certain domain, I can receive
email from one user at that domain but not from any other user, there ISP is
telling them that it is on our side that it is being blocked, we have
nortons doing filtering but the emails are not even gettting to the filters,
we can receive email from everybody else with no problem, we have exchnge
2000, could this be a DNS issue or is it coming from there ISP that is
hosting there email, we can receive email from other domains that there ISP
is hosting with no problem.
...CRM Email 12-29-03
I have successfully installed the email router, and i was
able to send emails from crm and successfully receive them
(both to company domain and outside clients).
I have noticed though:
1. when i send email activity to CRM users
(CRMEmailEnabled attribute assigned), they do not receive
this in their queue - actually the application should
generate another activity appending CRMxxxx to the subject
line which doesn't happen in this case
2. Internal mails (company domain)
We can not send emails to CRM. I have followed the steps
in the guide, created a queue...everything and i am still...Changing Information
Using Excel and Access 2003 on an XP SP2 machine.
Is there a way to produce a pie chart from an Access query when you will not
always have the same fields return results to be plotted? (In case that was
as clear as mud to you as it was to me, I'll try to explain.)
I know how to return reqults from a query to a spreadsheet and produce a
chart from there. What has me stumped is what to do when the fields change.
For instance, I'm trying to produce a pie chart that will show how many of
several different categories of data occur. However, depending on what
transpires during a repor...domain added then removed from exchange but emails still route to exchange ?
Was wondering if someone can explain this:
added external domainA to accepted domains
added domainA mail address to users mailbox
(mx was not changed)
sent email from mailbox/account/domainB (hosted on exchange server) to
domainA , arrived in users mailbox on exchange as expected
removed domainA from accepted domains
removed domainA email address from users mailbox
to domainA , arrived in users mailbox on exchange as expected, arrived in
users mailbox, this was not expected.
When using Outlook (domainB exchange accounts) and entering the email
address user@domainA.co...How do I set the worksheet to save before closing?
When there is a change in a worksheet and I try to close it, a message asks
me whether I want to save the worksheet or not? How do I turn on this
notification before closing the sheet?
Open your workbook. Hit Alt+F11 or Tools-->Macro-->Visual basic editor
(VBE). On the left, double-click ThisWorkbook. Paste the following code into
the ThisWorkbook code window. Hit the Save diskette at top-left. Close the
VBE. Make a change to the workbook, and close it to test. Was the change
saved? Should be. :)
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save...List servers and their DNS server settings
I am trying to get a list of server names and their primary and secondary
DNS server settings.
If I try the following command:
get-wmiobject Win32_networkadapterconfiguration -computername "servername |
select name, DNSServerSearchOrder
It would give me the specific servername and its dns addresses.
I know have a list of computernames which I would like to list out and their
DNSserversearchorder settings (DNS settings)
I tried putting the list of computernames in a text file by using
get-qadcomputer | export-csv C:\computername.txt -notype
Then I used the get-con...Multiple Exchange Servers and Email Router
When installing CRM 4 Email Router in an environment with 2 Exchange servers,
where do I need to install the Email Router?
it is not requirement in CRM 4.0 to install the exchange router on
exchange. All you need to do is to choose the exchange server name
while configuring the router .
I myself had installed the router on CRM server.
..."Remove access" to certain accounts in CRM 4.0
Is there a way in CRM 4.0 to remove access from specific accounts for
Accounts they would otherwise have access to? I'm only talking about a very
specific subset of the regular accounts in the business unit for which the
Anyone have any experience with that?
The simplest way is to move this accounts "VIP accounts?" into another
business unit and set the access rights accordingly. Or you can use the team
"Adam Pinilla" wrote:
> Is there a way in CRM 4.0 to remove access from specific accounts for...