I have created a template in word which I call through a VB script from
excel. The excel data is populated in the word every time I run this script.
Everything works fine and the data get populated.
I have a header in the template which is represents one of the fields in the
excel sheet. The header shows the correct linked value for the first 10 pages
but then on shows the variable name instead of the value. I have no idea why
it does that?
can someone help
The code is as follows:
For iCurrentRow = 1 To iLastRow
If ActiveSheet.Range("B" & iCurrentRow...HELP! HTML Emails with mailto: forms in send data as an attachment!!
I am a developer and I have a windows service which uses a database to send
The emails are in HTML format.
Some of them have <FORM action="mailto:[an email address]"
in, so that data input into the emails form can be emailed to a specific
This works fine with Outlook Express in that when the address in the
the form gets an email, they see the forms data in plain text, (as they
HOWEVER! If someone with Outlook (2002) fills out the form and sends it the
email has the form data as an a...Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange
2003 on a new domain. This was performed with the exmerge
utility in a 2 step process. Now there are 2 issues with
1) When a user types a recipient name into the address
field, the name autocompletes as normal. But when the mail
is sent, a message returns saying it is undeliverable.
However, if the user goes into the Contacts folder and
from there selects the same user to send a message to, it
2) If a user shares a calendar, specifying the user with
whom to share and the level of permissions, all users in ...Editing Chart Data Table
I have a bar chart with 2 different series of data (Item
cost in $, and % of total volume delivered). I want to
create a data table under the chart, but have it only show
the values for the volume delivered and not the item
cost. Is there a way to exclude data from the data
...Drop-Down Menus in Data Entry Form?
I have a drop-down menu containing the months of the year in my
spreadsheet. I want to train people to enter data using the data entry
form (Data --> Form). Is there any way to make this drop-down menu
appear in the data entry form?
You could create a macro that displays the data|form dialog.
But when would you want to run that macro?
When the workbook opens?
When the worksheet is activated?
Only when the user wants to see it?
The line of code could be as simple as:
> I have a drop-down menu containing...Taskbar issue
I'm hoping someone can help me with this long-standing problem with both XP
and Vista on separate laptops and every computer I've had (except I think
Win98). I'm thinking there may be no solution, but what it's worth a try.
With both of my machines, I have the taskbar (as well as other toolbars) set
out to maximum size - typically half the screen - and to auto hide. (This
makes a great program and file launcher)
The issue is that the operating system decides it wants open the taskbar on
its own from time to time on its own. Various things prompt this, ma...'access data on web'
With prior versions of Money, synching w/ the web would (apparently) simply
copy data from the Money file to a page behind your login at MSN.
I appears that has changed.
It looks like MSN is itself going out and downloading information from
financial institutions and then that information is updating my Money file.
What is actually happening when I elect to make my data accessible on the
web? I just want to have my Money stuff copy to my MSN login...is that
IF you don't enable transaction download from an FI that is only accessible
via a "third party" (Yodlee ...DST issue
I entered the catalog item:
<Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" />
and confirmed that the device has the registry key:
HKLM\Software\Microsoft\Clock\AutoDST = 1
But the device still does not automatically adjust for DST. I set the
timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one
minute...and the time changed to 2:00AM instead of 3:00AM.
What am I missing?
which OS version are you using? have you updated it with the relevant qfes
which deal with the changing in DST starting day?
-...Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can
recieve it using Outlook. There error says that Outlook was unable to access
the SMTP server. I cannot access my email at HOME through the web email. What
I can do is send/recieve email using Outlook Express AND I can access my
email through my web email client outside my home. My ISP (SBC) says its not
them and I'm somewhat inclined to agree with them? They say I could have a
corrupted kernel32.dll file. I have turned off my Norton, deleted my account
and set up a new one and re-installed XP professiona...Data Validation #2
Basically there are three categories from which the user can selec
Eg Issues Sub-issues Services-issues
- servicing - assessing - delay in assessing
- call centre - misquote
- information - website (no entry required)
I would like the sub-issues and services-issues to depandant on th
issue first chosen, thus limiting the selection on the subissue an
servicing-issues drop down. Is this possible in Exce
Message posted from http://www.ExcelForum.com
check out Debra Dalgleish's site espe...Extender Install Issues
GP 8.0 Extender install - I'm encountering the following:
*Login to GP brings up screen: "Great Plains Extender needs to finish
installing. This may take a few minutes". It has an OK button and clicking
on this gets you into GP but it comes up everytime. How can we stop this
from popping up all the time.
*When creating a new Extender Window and I get select the Form, I get the
following error: "A remove range operation on table
'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or
function zDP_EXT40101L_1 has too many arguments spec...Data Source of Pivot table
if i create a Pivot table with the Wizard in Excel 2000 and have my data in
a ACCESS 97 table,
where can i see the explicit Path and name of the database and the table
that are concerned.
if the place of the database changes, is it possible to write this change
directly into to excel-File
via VBA to tell him, that the refresh has to be taken from a different
maybe the access-table-name could be changed also, on the bassis, that the
structure stays the same.
Thanks for helping
...Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to
be able to use some of the tables and subtables as a sort of checklist for
the audits. The table/subtable structure is as follows:
I decided to create a report that will output that data. However, the report
is only outputting information if there are ProgramRequirements already
entered for a given ProgramArea. Is there a way to get it to output the
ProgramArea and ProgramRequirement even if blank? Or am I going about th...using excel form to input data into access
Is it posible to use an excel spreadsheet to enter data into access?
please reply to group
You can link access to Excel. But why? before going any further, explain
the reason why you would want to do this. Let us evaluate what your needs
Access Forms are much better for data entry, for a number of reason, than
Excel. What would you use acces for then if your data is being entered and
stored in Excel? Explain some more so we can guide you better.
Hope this helps,
> Is it posible to use an excel spreadsheet to enter data into acces...How to get data from Beta to BCM Trial
I have the trial and now have lost all my BCM data. I was getting the
following until I deleted the BCM portion that was being loaded.
Outlook 2007 trial small business. On start up I get three error messages
that data entered in the beta cannot be opened in the contact mgr. So I say
ok to all and Outlook opens. When I click on the business contact mgr folder
under all mail items I get the above error message.
How do I get all my data back?
I also can't get anyone to respond so I am putting this everywhere!
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are
unable to send documents to PDF from GP - the PDF option remains grayed out.
We have folowed the KB articles that are available, no success. Do we need to
install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe
9? Thank you for any assistance..
I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0
It is working succesfully.
> We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...Issue with formula is Pivot table
I have the following formula in a pivot table:
First to the issues that I am experiencing. First, the formula wa
originally added as the one below but then updated to the formula abov
to correctly reflect what I was trying to accomplish.
This issue is the original formula appears in the very first cell o
the pivot table and then periodically through out the column. So, yo
see ...Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users,
Starting over the last two weeks (possibly after an update on the
Exchange server), all of my users are starting to encounter the same
issue when using Outlook Web Access (using IE6 on XP Pro systems). We
have images in our signature block, and now when someone replies using
Webmail to an e-mail originally sent via Outlook 2003, a login prompt
appears for each image in the e-mail. Every time you cancel the login
box, a red x image box appears, until all of the images that should be
there are represented by the red x boxes. For the record, this has
w...Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a
webpage it returns an error stating that the the "item could not be
created". Outlook 2000/Windows 2000
...No data return from a sub-query causes an error message
I have a sub-query which counts the number of referrals received [Date Received]. The user then enters the criteria of the time period between [start date] and [end date] and the locality [Town]. There are 9 different localities. When the query is run and there have been no referrals in a particular locality, the table appears as column headings with no data. The query that this links into (as do several other sub-queries) then also returns no data.
How can I get the first sub-query to return data for each of the different localities, with 0 if there have been no referrals?
If someone ca...Update Issues
Has anyone experienced any problems with XP Pro updates sent in Feb.? My
Lenovo T61p has performed flawlessly for 2+years but suddenly started turning
off and now stays on but freezes-up. I can’t detect a virus and seems like
the Feb. updates are all that has changed.
I plan to uninstall them….between freeze-ups, unless someone has a better
>Has anyone experienced any problems with XP Pro updates sent in Feb.? My
>Lenovo T61p has performed flawlessly for 2+years but suddenly started turning
>off and now stays on but freezes-up. I can�t detect a ...~ issue
I am currently using Outlook Express 6 and have noticed
that for the second time (did a format the first time
thinking I had a virus!) that when I have downloaded the
330994 April 2003, Security update for Outlook Express 6
SP1 that anytime I make a change to my address book and
reboot I get an icon on my desktop that is named "~" and
it basically is my entire address book. Has anyone else
experienced this problem and how do I remedy it? Thank you
for any help! Sue
In reviewing the Outlook Express newsgroups, this is reported as a known
issue w/ no fix from Microsoft (report...Plot Line in data table
I have a table of data
8 9 10 11 12 13 14 15
1.00 28 32 35 40 47 59 71 82
1.50 42 47 53 60 71 88 106 123
2.00 56 63 70 80 94 115 141 184
2.50 70 79 83 100 115 147 176 206
3.00 84 95 105 120 141 176 212 247
3.50 98 111 125 140 165 206 247 288
4.00 112 128 140 160 188 235 282 329
4.50 126 142 158 180 212 265 317 370
5.00 140 158 175 201 236 294 353 411
5.50 154 174 193 221 259 323 388 452
6.00 168 189 211 241 283 353 423 493
I want to be able to plot a line through this for a specific value. Is this
possible. eg if i wa...Multiple Outlook Mailboxes issues with 3.0
I have a large number of users who have more than one outlook mailboxes, When
I open an email from one of the addtional mailboxes, I get an error message
that tells me "Only Items in the default Outlook store can be promoted to
Microsoft CRM." Does anyone know if this can be worked around??
...Chart with mixed annual/5 year data
I'm doing a simple line chart where several data series are on an
annual basis but one has figures only for every fifth year. I entered
the fifth-year numbers in a column alongside the annual data and left
blank cells in between. When I added that series to the chart it shows
up in the Source Data window and in the legend on the chart, but no
data points are in the chart. I'm sure I'm doing something stupid here,
but does anyone know how to fix this? Thanks!