|
3up cards
I have tried your suggestion of creating a label for 3 up cards, and using
next record. Here is what I get
page 1 has address 1,2,3
page 2 has address 2,3 4
page 3 has address 3,4,5
at this rate I will have 3 cards for each record...
|
2 |
12/1/2008 7:20:26 PM |
|
|
Mailmerge not working anymore
I have been using Office 2000 with XP for several years. I have some
mailmerges where I am using Word in conjunction with Excel and it has worked
successfully until recently. Now, when I open the form, I get a message that
says "Waiting for Microsoft Excel to Accept DDE Commands" and hangs. Excel
has opened with an empty Book1. For a couple of weeks I could get it to work
by running ...
|
2 |
11/30/2008 5:09:02 AM |
|
|
data merge and SET field command
I have to maintain 30 different Word documents that contain in various names
and phone numbers of contacts personnel (a single document may reference the
same person's name multiple times). Currently when a contact name changes I
have to try and remember which Word documents need to be updated, as well as
where and how many times within the documents the change needs to be made.
Done man...
|
2 |
11/29/2008 11:51:47 PM |
|
|
Address labels - Creating new recipients in a merged document
1. I wish to expand my recipients list in address labels merged document?
I do not want to retype the whole thing again - just add the new ones.
2. I need to have the same individual recipients printed in groups of 10.
I could not find procedure? Please advise.
------------------
Vista - Word 2003 - Avery Label J8651 [65/A4sheet]...
|
5 |
11/29/2008 5:30:16 AM |
|
|
Only 1 record per label sheet?
I am mail merging from excel file, and from outlook contacts, onto an avery
label sheet, but I get only one record per sheet in the top left corner. What
is the process for using the complete label sheet with the 20-25 address
label stickers on it?...
|
3 |
11/28/2008 8:58:12 PM |
|
|
Date import using numerical abbreviations - 1st, 2nd, 3rd etc.
I might be too optimistic in trying to achieve this, but is it possible to
format a mailmerged date in Word to include the abbreviations *st, *rd and
*nd, showing 1st December 2008, for example?
Thank you,
...
|
3 |
11/28/2008 8:49:01 PM |
|
|
mail merge times from excel into word
I formatted the cells in Excel with h:mm BUT when I mail merge into Word it
comes out as h:mm:ss AM. I don't want the seconds or the AM or PM. Can
anyone tell me where I've gone wrong. It's driving me mad so any feedback
will be great...
|
3 |
11/28/2008 7:27:55 PM |
|
|
Currency Format in Excel Won't Merge in New Document
When I use the mail merge from an existing excel document it does not
transfer numbers that are listed in a currency format. For example the excel
spreadsheet has a row that may say $1,000.50 and when it goes into the mail
merge document it says 1000.50. How can I get the numbers to be correspond
correctly to the excel sheet?
...
|
2 |
11/28/2008 7:21:43 PM |
|
|
Mailmerge with a csv file
I'm using Word 2007 to mailmerge a previously created document with a csv
file. When I try, I get:-
XXXXXXXX.docx is a mail merge main document. Word cannot find its data
source, Y:\xxxx_data.csv.
Note the filename is exactly 16 characters long and always the same name.
And when I click "Find Data Source...", I can locate the csv file,
but selecting it only gives me the same dialog ag...
|
10 |
11/28/2008 10:26:59 AM |
|
|
Comparison problem w/SkipIf
Word/Xl '03
The merge data in xl is formatted as General and is in the form of ####-###.
I want the record(s) to be skipped if the value is less than a specific value, for ex
Skipif field is < "1000-999"
The merge doesn't seem to recognize > or < operators (only =).
I tried changing the format in xl to Text (and re-entered the value) - no effect.
What am I missing?
--
Regards
...
|
3 |
11/27/2008 11:37:16 PM |
|
|
using mail merge from Excel cuts off after 70 records
I have an Excel file with 75 records but when I try to mail merge it in Word
it cuts off after 70 records. If I sort the fiel so the missing records are
at the beginning it does the same thing - the last 5 records are omitted in
the mail merge. Any idea why please? I'm using Office 2007.
Thank you....
|
2 |
11/27/2008 9:40:41 PM |
|
|
IncludePicture merge set height of image and retain aspect ration
Hi All
Been searching for this and I am getting confused with the different
responses (Frames, Tables, Labels).
I have a merge document that occasionally throughout has IncludePicture for
Logo's and Signatures. These will vary in size subject to the company whose
logo is being used.
I wish to be able to specify a fixed optimum height and then have Word adjust
the width based upon the ...
|
2 |
11/27/2008 7:31:48 PM |
|
|
Mailmerge datasource has double quotes
I need to merge from a datasource that uses double quotes " as a field
delimiter, using word 2003. It has always worked before, but now, I can't
select the " as a delimiter. It's a pain in the neck - is there anything I
can do?...
|
2 |
11/27/2008 5:24:36 PM |
|
|
want an error alert in mail merge
hi,
when i mail merge using doc as my external source i made a field constant
using " if then else" from the 'insert word field ' tool.My result was
working fine.
requirement:
when i enter a replacement text other than what i had mentioned in the "if
then else " case i should get an error as we get in excel("data.. validation
.. show errors ).But its not prompting me for errors ...ple...
|
2 |
11/27/2008 12:51:47 PM |
|
|
How do I get the merge fields to not print gray
Office 2003 professional
I created a standard word document with merge fields from an access database.
The merge fields appear with a gray shading. When I print preview they still
show gray and when I print the gray shading prints.
The setting in Tools/options/view/field shading is set to never.
This is not a form; just a document.
Office 2000 does not show the shading but that is at a...
|
11 |
11/27/2008 3:14:00 AM |
|
|
mailmerge and margins
I have a 2-page letter that I will be printing onto a letterhead. I have over
600 recipients. How do I lower the top margin on the 2nd page of each letter?
I cannot figure it out....
|
2 |
11/26/2008 11:53:42 PM |
|
|
Losing MainDocumentType on Open()
Hey guys, I have a mail merge document that is set to Directory for the Main
Document Type. If I close it and manually reopen it, it stays as a
"Directory" document, but if I open it through automation (i.e.
oWord.Documents.Open("C:\SomeDirectory\SomeDirectoryDocument.doc")) the
oWord.ActiveDocument.MailMerge.MainDocumentType = -1 as soon as you do the
Open() command and then it gets set...
|
9 |
11/26/2008 11:10:03 PM |
|
|
Finish/Merge; only half records of linked file actually merge?
I have just printed a mail out using word.
The selected recipients total is 1204 records, which all appear in Preview
Results, however when I Finish and Merge ALL only 602 records work. (Exactly
half)
Upon investigating the file I noticed that each alternate record has not
worked.
There must be a simple reason for this.
Please assist me - My goal is now to recover the remaining ...
|
3 |
11/26/2008 9:19:01 PM |
|
|
Ability to Use Word Mail Merge to Email Multiple Recipients
This has likely been suggested numerous times but I would like to add my to
emphasize the importance of this function.
One serious functionality that is lacking from Word mail merge is the
ability to send a record in a merged document by email to multiple email
addresses.
For example, it is very important to be able to send out an identical email
to a client that has multiple email ...
|
4 |
11/26/2008 7:30:35 PM |
|
|
Word Mail Merge with xml
Hello All,
Im interested in getting data out of one of our databases using XML/XSLT
into word. Does anyone know if it is possible to do this with word, and how I
can achieve this. I can't use odbc as the odbc seems very unstable with my db.
Any help/hints tips would be great.
Kindest regards
...
|
3 |
11/26/2008 7:27:17 PM |
|
|
Retaining "FileName" field after merging document
In my primary document I have a "filename" field code in the footer. After I
complete the merge, the field code becomes static. Is there a way to keep
the field code in the footer?...
|
4 |
11/26/2008 9:21:02 AM |
|
|
hmentsâ€_skipping_files?
I am having trouble with the Mail Merge to E-mail with Attachments VB Script
written by Doug Robbins located here:
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
My problem is that when I run the macro only the final file in my table of
attachments gets included in the sent emails. At first I thought it was
likely to be a problem with either my file names or the file ty...
|
4 |
11/26/2008 6:59:28 AM |
|
|
Word 2007 merge with 2 different data sources
I am a new Word 2007 user. I have 1 word document that needs to pull in data
from 2 different Excel 2007 files. Is this possible to do? Currently, I am
combining the 2 Excel files and then conducting my merge process.
Any recommendations?...
|
2 |
11/26/2008 4:27:04 AM |
|
|
how do I get rid of grey highlighting in fields?
Having spent ages compiling an address book and creating mailing labels from
it, I can't get the grey highlighting in the fields to disappear. I don't
want these when I print the labels....
|
2 |
11/26/2008 4:26:36 AM |
|
|
Names of labels in "Options"
Previously the name of the label, such as "Ready Index 5-tab", appeared in
the list of labels as you scrolled up or down when choosing your lable
option. Not the case anymore. Only the label NUMBER shows. If you don't
know the specific product number, the only way to see the name of the label
is to use the up and down arrows and then the name of the label appears in
the information ab...
|
2 |
11/25/2008 10:50:13 PM |