Merge to word???
I have a contract database that allow me to query data from the database and
merge it to word file. The code below seem to work OK except that It does
export the whole contract information to excel first and then doing the
Is there a way to only limite the export to just one record (preferable a
select record by contract number) to excel before doing the merge?
Private Sub Command26_Click()
Dim Stg As String
Dim strDocName As String
Dim appWord As Word.Application
Dim docWord As Word.Document
Dim strFilePath As String
DoCmd.OutputTo acOutputQuery, "rptCo...Right Click to Autofill cells in 2003
In 97 to 2002 it was possible to right click when using Autofill to copy the
cells down rather than continuing the sequence. in 2003 i just get a pretty
red line (what purpose does this serve?). Does anyone know if I can get
back the old functionality?
I have that functionality in Excel 2003 as well, maybe you have installed an
add-in? In any case if you hold down ctrl while using the left click copy
down it will also copy as opposed to fill a series
> Hello All,
> In 97 to 2002 it was possi...Printing an address in letter
I am trying to print a confirmation letter with an address in the body of the
report. The address may or may not have an Address2 line. How can I
eliminate the space if the Address2 line is blank? Also, can I use an "IF"
to edit the printing of zero values?
Depends on what you mean about the address being in the body of the report.
If there is no label with the address or any text around it then use
Properties to set click on the text box (es) in Design view and set Can Grow
and Can Shrink to yes.
Do the same for the Section that contains the address by clicking ...Outlook 2003/Lotus Notes Issue
I have been having this outgoing problem with receiving emails from Lotus
Notes. It seems to only be a problem when I got replies from a Lotus Notes
system. When I open up the reply, the only think I see in Outlook 2003 is my
original message and nothing else.
I have tried changing the format to HTML, Rich Text, Text, etc and still get
Are you using Outlook Connector for Domino?
"frequent_flyer" <firstname.lastname@example.org> wrote in message
> Hi All,
> I have been...Fix Publisher printing failure
I hope the deficiency in Publisher 2003, referred to in the following
exchange of posts, will be remedied promptly. Or is it just a turf war
between Microsoft and HP, conducted at both your customers' expense??
The text of the earlier posts follows:
#1: I am trying to print a brochure with a four-way bleed. I set up for
borderless printing on glossy brochure paper, but the program keeps
defaulting to regular 8.5X11" letter paper and leaving a 3/4" white border.
In 'page setup' under printer properties, I call for 8.5X11" borderless
paper size, bor...With Microsoft FAX Nearly One Minute Delay between Using Print
With Windows Messaging and Microsoft Fax under Win 98 SE, when I
printed a document to Microsoft Fax, the fax wizard would start a few
seconds after I said print.
I installed Outlook 2000. With it, there seems to be a consistent
nearly one minute delay between when I say print and the fax wizard
If Outlook is running, there is no delay.
The osa9.exe program doesn't make any difference.
Needless to say, this is an annoyance, having to go through two steps,
start Outlook and then print, rather than simply printing.
Does anyone know of a way to make Outlook 2000 work like Messag...Time/Date stamp in Outlook 2003 msgs.
My friend with 2003 has reported another oddity to me
which is that the time & date stamp on her messages seems
not to have changed with daylight savings time (i.e. they
are 1 hour behind). She says the system clock did
My question--does Outlook really have anything to do with
the time/date stamp or is this just a function of the mail
Los Angeles, CA
Check calendar options
"Stephen Porter" <email@example.com> wrote in message
news:MPG.1ae37d24b618934c98969a@m...Printing string from string table inside for loop?
#define IDS_STR1 _T("Str1");
#define IDS_STR2 _T("Str2");
#define IDS_STR3 _T("Str3");
#define IDS_STR4 _T("Str4");
#define IDS_STR5 _T("Str5");
for(int i = 0; i < 5; i++)
I am looking for the logic that can be used to print those strings
inside the "for" loop.
Any help is welcome.
The #define's are put into place as part of the pre-compilation process,
thats why they are also called pre-processor directive. So, you can not use
a variable with a symbol defined ...Need to print all address lines on a 1099 form
In Great Plains Version 10, on the vendor card, under the address button, you
are able to enter 3 lines of address information. However, when printing
1099's, only the first 2 lines of address information will print on the form.
Since we utilize all 3 address lines, we had many 1099 forms returned as
undeliverable this past year. According to our partner, Microsoft indicated
that, currently, there is no way to print the third line of information.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for ...Opening Word Attachment
Weird problem here...All office programs seem to function
well just have some minor issues opening files. Example:
In Outlook, trying to open a Word attachment, if I open
the message and then try to open the attachment from
there, it says "cannot find the file specified", but if I
have word open already, then do the same exact thing, it
opens. I have this problem also with Explorer. I can
browse my hard drive and network and find anything, but
cannot open it directly from Explorer. I have to open the
application that I am using and then open the file through
the Open Fi...copy an access report to word
I want to export an Access report to Outlook email or MS Word.
Right-click the table name > click Export... > select Rich Text Format as
your Save as type: > Enter the file name if necessary > click Export
> I want to export an Access report to Outlook email or MS Word.
...Outlook 2003 CRM Toolbar
When we click "New Record" on the CRM Toolbar and choose "New Contact" it
takes us to our Contact form in our old Public Contact datasbase in Exchange.
How can I globally change this for all our users so in brings up the CRM
The best way to do this is to customize the ISV config file for the Outlook
client and add a new button to do this.
The button you are referring to can open the CRM contact web form, but you
have to change each individual user's setting to do this. If you want to do
this, select the CRM > Options menu. On the Syn...FrontPage 2003 on windows 7 64 bit
FrontPage 2003 on Windows 7 , Following Issues
1. SAVE AS… error - not enough memory ( memory is there)
2. Unable to Insert IMAGE From File - FrontPage fades
3.Other sporadic issues - error messages while opening or publishing
Tried the below steps : ( it works fine on Windows XP ) ( few of them are
Removed temporary files, removed cmdui.prf, removed *.web
Checked in Windows Safe mode
removed FrontPage addins
Installed latest updates for FrontPage ( Sp3)
checked FrontPage server Extensions - they are fine
Uninstalled and reinstalled...Outlook 2003 Font Changes When Replying Plain Text
Outlook 2003 is exhibiting a strange behavior when replying to plain
text messages. After clicking the "Reply" button, the message appears
in the Arial font. In about two to three minutes, the font suddenly
changes to Courier which is the correct font.
Why is it taking so long for the font to change?
...como colocar a folha deitada no word?
por exemplo eu quero fazer uma convocatória e em vez de escrever com a folha
A4 em pe queria escrever com a folha A4 deitada.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"daniel" <firstname.lastname@example.org> wrote in message
> por exemplo eu quero fazer uma convocatória e em vez de escrever com a
> A4 em pe queria escrever com a folha A4 deitada.
Na...Using Excel 2000 as Data source for Word 2000 document
Problem using Mail Merge using Word 2000 & Excel 2000.
After numerous problems - Word failed to connect to Data Souce file then it
would & then it wouldn't and so on - reasons which are unknown!
The 106 records in 19 fields from the Excel Data Source are only
transferring the information for the first 104 records.
I am looking to add further records but obviously need to overcome this
Obvious, perhaps, but are you certain that the records are in consecutive
rows & no vacant columns separating the fields of data? Does the data range
contain any Merge...Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...Outlook 2003 -receiving multiple copies of messages
SBS2003 server, mail comes from ISP "CATCH_ALL pop box)
WinXP Pro OutLook 2003 Clients (All fully service packed up)
I send a message from an external source, be it hotmail or home account or
even from another company to say 3 people at our company.
email@example.com, firstname.lastname@example.org, email@example.com. they all get the same
message 3 times. If I try this from within the company they only get the
Any ideas would be very welcome.
Thanx in advance of any help.
> The setup.
> SBS2003 server, mail comes from ISP "CATCH_ALL...Outlook 2003 Suggest Names feature stops working
I've run into a problem with one of our Outlook 2003 installations. On
this particular PC (XP SP2), the Suggest Names feature has
spontaneously "forgotten" all of the email addresses in it's cache.
It's like all of the email addresses are somehow deleted. The feature
is still turned on in Tools, Options, Email Options, Adv Email Options.
And any email addresses the user puts in after this problem occurs are
remembered, but Outlook doesn't remember any from the day before or
The user hasn't been mucking around with his settings, and this has
hap...formatting is incorrect when viewing in different zoom except for 75%
Here's a strange one for you guys... I'm using Office XP and
currently working on a couple of excel spreadsheets. When I have the
zoom set to 75% everything looks correct, exactly like the print out.
However if I change my zoom to anything else besides 75% some of the
text goes over to the next column. It's pretty irrarting sometimes
becuase if I have it set to 100% I'd usually spend time playing with
the column width to get everything to fit and in acctuality I don't
have to becuase it looks correct when printed out and when in 75%
zoom. Any ideas?
This sounds like a ...ms pos 1.2 weird word jumble
Store Operations Manager was not working, so I did a repair install.
After the repair, the wrong phrases were in the wrong spot. For example,
instead of cancel it says "category code" and instead of file it says
"Filter:" Does anyone has an idea how to fix this?
I took a screenshot of the home screen so you can see the weirdness for
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Account...Drawing and paper are same, but all doesn't print
I created a project on 8 1/2 x 11 landscape paper. In print preview it shows
all of my project on one page of paper (just as I laid it out when creating
the project) and also shows a picture of the drawing paper and printer paper
being the same (overlapping each other exactly). When I try to print my
project only the bottom of my project prints out...nothing else (just one
page...it doesn't print out the top half).
sounds like it may be one of those 'known bug, apply visio service packs and
update printer drivers'.
"tjsmags" <tjsmags@discussi...Signature option disappears when using word as e-mail editor
I've got a weird problem. When I try to use word as my e-mail editor, I lose
the ability to add signature. As soon as I check the box to use word as my
e-mail editor, the signatures buttons are greyed out.
Jeff Brooks-Manas wrote:
> I've got a weird problem. When I try to use word as my e-mail editor,
> I lose the ability to add signature. As soon as I check the box to
> use word as my e-mail editor, the signatures buttons are greyed out.
> Any advice?
The signature option within ...Exchange 2003 MTA pooling
Is it possible to setup Exchange 2003 to perform pooling when sending
messages out via X.400? So for example, if I have 4 X.400 connectors
with the same address space that go to different external MTAs, can I
set the cost to 1 on all the connectors and Exchange will decide which
connector to use?
What are you connecting to on the remote side - Routing Groups within the
same Org or external MTAs to external messaging systems?
If it's the former (connecting Routing Groups), no true load-balancing
(assume that's what you mean by "pooling") is performed between X.400
Conne...Printing BLANK report for current form
I am trying to print a report for a current form which has just been
However, unless I leave the current form and return to it, the report
Here is the code:
Private Sub PrintVoucherSingle_Click()
'Print current record
If IsNull(Me!CertNumber) Then
MsgBox "Please select a valid record", _
DoCmd.OpenReport "rptlIndividualTaxiCertificates", , , _
"CertNumber = " & Me!CertNumber
What have ...