|
Word 2003 Envelopes and Labels fails to insert address into envelo
I have used the Outlook 2003 contacts and/or address book entries to address
and then print individual envelopes in Word 2003 via "Tools>Letters and
Mailings>Envelopes and Labels..." for years. Just recently this technique
fails to actually insert the desired address into an "envelope." Up until
the moment that I click on the desired address within the "Contacts" file
(while both...
|
4 |
6/27/2007 9:11:04 PM |
|
|
Import from Access 2007 Query
When I try to do a mail merge using an Access 2007 Query that contains
parameters, the import fails. I get a dialogue box in word (2007) titled
"ODBC Microsoft Access Driver Login Failed" with the information "Could not
find file 'blah, blah, blah.mdb' contained in the body of the dialogue box.
The file referenced in the
dialogue box IS NOT the database I'm pulling the data from. I migr...
|
6 |
6/27/2007 9:03:59 PM |
|
|
Can merge fields be locked?
I created three merge forms - all linked to the same data source - that our
people have been using full-time for the past week. At least once each day
this week I've had to "correct" their forms. One of the reasons has been that
they inadvertently type over a field after forgetting to put that field's
information in the data source file.
Is there any way to "lock" the merge fields so t...
|
3 |
6/27/2007 7:08:01 PM |
|
|
Mailmerge directory (unique record with sub groups)
I am trying to merge based on an excel spreadsheet - I need to show several
records for one category on one page (if this was access it would be record
and subset), but can't find out how to tie records to one page/one unique
set. HELP!!
Have used <<next record>>for the subset data, but this then scrolls over
page after page ...
|
2 |
6/27/2007 2:24:48 PM |
|
|
MS Access Database via DDE Not connecting
I have a problem somewhat different from that posted by Laura on June 12,
2007. A friend of mine (systems engineer) created a complex database for me
to use in my business using Access 2000 with documents created in Word 2000.
Very complex queries refine the data for individual legal documents created
in Word. We have two front end databases with one data container, the latter
being in a...
|
4 |
6/27/2007 1:46:03 PM |
|
|
Print a full page of labels for each person
I am trying to print a full page of the same labels for each person. My data
source is Excel. So far I can only come up with having 20 (a full page) of
occurances of the same person in the spreadsheet. I have 100's of people. Is
there a way of having the merge print a full page for each person without
working in the datasource?
Thanks,
--
Rich W...
|
5 |
6/27/2007 1:30:03 PM |
|
|
Maximum number of characters in a word merge field
This is probabaly an easy one for you guys but its driving me crazy.
I have a word merge supplied by excel, some of teh excel cells have quite a
lot of information (upwards of 200 characters), some of the text contained
therein merges where in other sections with the same length the text is cut
off. WHY?
When i tested it it all worked fine, now it does not I can't work out why.
Anty...
|
4 |
6/27/2007 12:38:15 PM |
|
|
Next Record If Question (Word 2003)
It is my understanding that inserting the Next Record If statement in a mail
merge would allow me to only merge records that meet the criteia I set . I
do not seem to be able to make this work. (Next Record If = Chicago should
only return records with Chicago in the city field)
I can use the Skip Record If command to restrict merged records to whatever
criteria I choose. I am using t...
|
2 |
6/27/2007 8:12:20 AM |
|
|
AddressLayout not working
In Word 2007, I have a Quick Parts entry defined for AddressLayout, just like
I've been using for years in Word 2003. However, the Insert Address function
from Outlook contacts, to insert a single address into a Word document, does
not follow this format until after I insert the AddressLayout quick part into
the document then delete it. Until I do that extra step, I only get the
defaul...
|
10 |
6/27/2007 6:03:48 AM |
|
|
mail merge in word 03 using outlook contacts
i am trying to setup the mail merge using the contacts from outlook and when
i try to add recipients it says unable to find source code. i then try to
browse for the contacts but i have no idea where to find them on my computer?
can anyone help???
thanks...
|
2 |
6/27/2007 5:53:26 AM |
|
|
merging two data source files
Hello,
I have created a data source file for a mail merge using the mail merge
wizard. The file is saved as a .mdb file. I would like to have both myself
and another person enter data into the source file by giving each of us an
identical copy of it. But then I would like to combine the two so that there
is one master list with all the recipients. I know the easiest way would
prob...
|
2 |
6/26/2007 7:55:48 PM |
|
|
Charactor Limits on Mail Merge from Excel
Does anyone know what the maximum charactor limits to a field from a mail
merge is in Word. I have several fields I am bring into Word from Excel 03
and they exceed 2000 charactors. If so is their a work around to this
charactor limit?...
|
2 |
6/26/2007 7:51:01 PM |
|
|
Mailmerge: remove blank lines created by carriage return in datas.
I want to print some mailing labels but I have blank lines in the address
fields that are created from carriage returns in the datasource.
How do I stop these blank lines displaying on my labels?...
|
4 |
6/26/2007 5:16:00 PM |
|
|
a directory?
I was just musing what is the difference , in mail merging atmosphere,
between a Directory and a document?
One is asked to begin mail merging by selecting either a letter or label etc
or a directory.
even when the merged directory is saved it gets a doc extension.what are
the uses of such directory?
thanks.
...
|
10 |
6/26/2007 2:35:54 PM |
|
|
mail merge
Thanks for helping me as I am a beginner with mail merge.
I have an Access database with information regarding perennial plants. I
need to print labels for each one of the plants. My problem is that I can't
figure out the mail merge to print more than one label at times. let's say
I have plant "A" with a quantity of 20, I want to mail merge to print 20
labels of Plant "A" as well as car...
|
10 |
6/26/2007 8:43:28 AM |
|
|
How to suppress the blank lines while mering fields in Word docume
I'm using a Word OCX control to display document, and need toggle the
document display between merged and unmerged status, the VBA code seems as
below:
.mailmerge.opendatasourece(...)
.mailmerge.suppressblanklines = true
if ...
.mailmerge.viewmergefieldcodes = true
else
.mailmerge.viewmergefieldcodes = false
end if
After the above scripts run, I fou...
|
2 |
6/26/2007 8:33:56 AM |
|
|
I get MAPI folder or address book not found error in mail merge
I get "MAPI folder or address book not found" when trying to do a mail merge.
I have VISTA with MS Office 2007 using outlook 2007 and word 2007....
|
2 |
6/26/2007 8:32:35 AM |
|
|
mail merge does not print where it should
I bought a new printer today - a HP c4280. I need to print invitations and
my old ink jet couldn't deal with the paper. Anyway - the mail merge looks
perfect in Word (2003). But it prints near the top of the envelope, instead
of in the center where I have it.
I think the merge is correct because I tried it in my older ink jet and also
a laser printer - even though the quality ...
|
1 |
6/26/2007 4:51:00 AM |
|
|
help provided is little too short for printing on 1 sheet
Mr. Robbins responded with a perfect solution to my question of printing two
merged letters on One sheet of paper so as to be more economical. Thanks for
it.
but,
after going through and following your advise I found that the two merged
letters printed on one sheet alright. absolutely perfect.
The hitch is: on first sheet two letters are printed, say for students A and
B each.
BUT, ...
|
2 |
6/25/2007 4:27:25 PM |
|
|
URGENT:Is it possible to replace data character with another chara
(Apologies if this is a common question. I've looked all through the Help
file, knowledge base and discussion groups and haven't found the right
combination of words to find anything useful... even if it's to say that what
I want isn't possible.)
In the data source, telephone numbers are in text format separated by dots
(for example, 555.123.4567). The requester wants to replace the dot...
|
3 |
6/25/2007 4:23:00 PM |
|
|
print multiple pages after mail merge on a single sheet of paper
Hello!. After merging 100 students' name and data in to a small 5 line
document that is to be posted to parents of each student, it is uneconomical
to print it. I want to print TWO merged pages on a single sheet of A4 size
paper.so that it is more economical to the authorities.
Please show me the way.
Thanks a lot.
Kindly send a copy of the reply to "hirendra7158@yahoo.co.in" also.
Many ...
|
9 |
6/25/2007 4:13:45 PM |
|
|
Word 2007, label mailmerge alignment
When I use the mailmerge for labels in Word 2007 the default format for the
labels is "Normal" with double spaced lines in the addresses. This causes
some addresses to be cut off, unless I decrease the font down to 9, which is
too small. If I "select all", and then choose "Normal, no spacing" the
addresses jump up to the left corner in each label. This causes problems
with alignment ...
|
3 |
6/25/2007 3:24:00 PM |
|
|
Mail Merge: If ... then ... else
I understand that I can use this function to check a field in my merge data,
and insert one or another text string into my Word document. What I'd like
to do is use a field in my merge data to direct which of two merge fields to
print. Is there a way to implement something like:
If [FIELD1] is Empty then [FIELD2] else [FIELD3] ?...
|
7 |
6/25/2007 2:25:01 PM |
|
|
mailmerge with VBA using ACCESS 2000
Hello,
This is my routine code:
> Public Sub fmailmerge(myskey As String)
> Dim objWord As Word.Document
> Dim strMergeDoc, str, str2 As String
> Dim mystudy As Variant
>
>
> Set objWord = GetObject(strMergeDoc, "Word.Document")
> objWord.Application.Visible = False
> objWord.MailMerge.OpenDataSource
> "\\fserver-xp\fshare\Pidu\StudysDocuments\EpiPne...
|
2 |
6/25/2007 8:43:10 AM |
|
|
merge field problem
I do all things for merge from excel yet when it comes to insert fields it
comes up automerge 0,1,2,3. Instead of the fields I asked for. When typing
this I just thought maybe I think i tried it data field include headers cells
in excel sheet Exampel row 3 is the headers in excel so when I select in word
I select F4:I7 this is small area till I get it to work. Need to get data
fields to ...
|
4 |
6/24/2007 7:53:01 PM |