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...How to display a field from a different table in a list box?
I'm trying to create this flow action without sucess:
I've a form with a combo box (with a list of values) and a list box.
What I want is to select a value from the combo and display in the listbox,
one colunm of one specific table.
This is possible to do?
> I've a form with a combo box (with a list of values) and a list box.
> What I want is to select a value from the combo and display in the listbox,
> one colunm of one specific table.
> This is possible to do?
Yes, take a look at the RowSource property of the ListBox.
mfG...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 ...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...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...publisher flyer printing
I created a flyer in publisher in the "envelope DL" format. Because it's
small, I'd like to print it 3 times on a sheet of paper. It won't let me
select that option and prints it only once across the page.
Since it is only 3, I would copy the entire (grouped) thing and paste it 3
times onto another file you have opened with a blank standard size page.
(Watch out for your printer limitations on area it actually prints!)
> I created a flyer in publisher in the "envelope DL" format. Because it's
> small, I'd...displayed email address
I have my own dot co dot uk domain. I want this to appear in the
"from" field in sent messages. At the moment I'm stuck with my ISP
address. I've changed the " reply to" address in options but that does
not change the "from" display.
Can someone help?
Trev (Milnrow, UK)
You set the address when you create / modify the mail account. I assume you
created an account with your domain settings? Presumably your domain has a
"Trev" <firstname.lastname@example.org> wrote in message
news:a4e0p5tmrn1h...Help! Printing Shared Calendar Crashes Outlook
Outlook 2003, latest patches running on XP Pro SP2 latest patches in a SBS /
Exchange 2003 environment (all patched to the max). When any delegate to
particular user's shared calendar attempts to print the calendar, Outlook
crashes: white window, Outlook.exe using 100% of CPU. Eventually Outlook
comes back and prints many pages of rubbish. Not printer-specific, not
workstation specific. Is there something wrong with that user's mailbox?
How can I fix, please?
A possible cause is if the delegate is trying to print the Daily Style which
includes task items. Try...MacDolt file
I am taking a college class and need to prepare a problem using a MacDolt
file. I have searched my excel to see if I have this file and can not find it.
Can you please tell me how to find it for XP or how to download it from
Thank you for any help from anyone.
...Word 2000 and Outlook 2007 conflict
We decided to upgrade one of our computers to Outlook 2007. We are still using Word 2000. Now when ever I open Word it will not close. Now it is interferring with my shut down mode. Any ideas?
EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks # 6
<Jeneal McKinley> wrote in message
> We decided to upgrade one of our computers to Outlook 2007. We are still
> using Word 2...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...hello everybody.. question about .CSV files.. 05-13-10
i have a excel .CSV file that Gmail generated for me with my contacts in..
what i want to do is function that go over all the contacts emails one by
one and deletes all missformated addresses that cannot be use to send email
for them.. somthing like :
if (the cell's text is not an valid email address)
delete the cell ;
to be honest i dont know much about excel so i need somthing from
thank you all very much..
The trick being.............how will Excel know the cell's text is not a
valid email address.
Did you have some format in mind that...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...Display an HTML page
I'm looking for a way in VC++/MFC to display an HTML
file. It's a simple help file (1 page) so I don't want to
enable the complete help system, just display this page
when the Help button is clicked. (This is a simple dialog-
Thanks for your help.
"Kevin" <email@example.com> schrieb im Newsbeitrag
> I'm looking for a way in VC++/MFC to display an HTML
> file. It's a simple help file (1 page) so I don't want to
> enable the complete help system, just display this ...Inking Feature for Microsoft Word for Mac
Operating System: Mac OS X 10.6 (Snow Leopard)
I have recently purchased a MacBook Pro, and I am trying to get used to the software differences between Mac and PC. On my PC, I was an avid user of the inking features in OneNote and Word. (They allowed me to take notes and draw diagrams in class with my Wacom Tablet.) Is there any software for Mac that offers the inking and drawing features of OneNote for PC?
It's a feature of OS X, not the individual apps. When you install a
compatible tablet, Ink will be available in System Preferences. See Mac Hel...Adobe issues
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 ...Show a CHM file
Is is possible to get a CHM file displayed inside a CHtmlView? When I do
Navigate2("filename"), the window shows 'page not found' and opens the file
download standard dialog. If I press 'open' the correct file opens, but in
an external window! I want to show the CHM file inside my application in the
window I have created for the job - is CHtmlView the wrong class to use?
...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
...Print a 2-sided document in Excel for a 3-ring binder?
How do I print a 2-sided document in Excel for a 3-ring binder? I have tried
everything I can think of, but the margins on the backside are identical to
the margins on the front and that doesn't work. The right margin on the back
needs to be like the left margin on the front in order to punch holes in the
document. Any help you can give would be great! I cannot be the only one
who needs to know how to do this.
You would normally set that option on the printer functions, File>Print>click
Properties next to printer name.
&...Sheet moves at print time, loos fine at preview
When I preview the spread sheet the vertical relationship between the
spreadsheet and the header looks fine, no space,
but after I print it there is extra space between the header and the
What causes this? What am doing wrong?
Check your left margin to see if all the row numbers are sequential.
You may have accidentally decreased the row height on row 2 and yo
can't see the space in print preview, but it's there when you print.
If that's the case, select the whole row, right click and select Ro
Height to adjust the height
---------...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...Excel file is opened twice
I have Excel 97-SR2(m)on a Windows NT4 Sp6a workstation.
Everytime I open an specific workbook this is opened twice.
This file is located in a network folder. No macros in the
Any idea about why this behaviour?.
If one has :1 at the end and the other has :2 at the end, then what has happened is that either
intentionally or unintentionally, someone has used the feature Window / New Window which will
allow you to see two copies of the same workbook at the same time (Can be very useful sometimes as
you can tile the windows). When a file is saved in this mode it wil...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 ...