|
Not all the data from my data source appears in my merged documen
I am using Excel as my data source to create a mail merge document in word.
Howerver, on merging the document I find that not all the data from a
particular cell is in the document. Is there a set ceiling on the number of
characters that are a field is set to recognize. In other words, why isn't
all the data be displayed in my merged document?
HELP!!!!!!!...
|
1 |
5/29/2007 4:13:01 PM |
|
|
exclude empty lines in office 2k3
Hi,
I was using an option in WORD97 that removed empty lines after compiling a
new mail merge document.
I can't find it in office 2003, there is some help on empty lines, but it
seems much less ellegant, as
it requires to mark the new paragraph character as hidden, then disable
its printing, it's not WYSIWIG.
Any ideas?
--
gacek...
|
2 |
5/29/2007 1:38:07 PM |
|
|
Word 2000 - Mail Merge/labels
Hello ... I am creating mailing labels using the Mail Merge feature of
Word. All works fine except when I don't have a full page of labels i.e.
some are already used. I know when you do a single label (Not through Mail
merge) you can specify where you want to print it on the page, (row and
column) but cannot see that option when doing a merge with the source coming
from an external f...
|
3 |
5/29/2007 4:25:38 AM |
|
|
mailmerge insert merge fields
How to toggle between mailmerge merge fileds menu and word document?...
|
5 |
5/29/2007 4:03:03 AM |
|
|
Mail Merge
Using WORD 2003 and Windows XP SP2 Pro. I have a main document and a
secondary document, which is an inventory, and any additions into the
document are entered manually. After all the Windows updates, the procedure
seems to have changed, and I am no longer able to merge the documents. What's
the procedure now, given an existing main document and an existing secondary
document with coded...
|
2 |
5/28/2007 5:41:43 PM |
|
|
Help! Mail merge faxes a document for each person to all numbers!
Damm Microsoft. I am so sick of their software! Manual is no help.
Doesn't even have what I have for options on screen.
Anyway, here is the problem. I have tried this with a Brother mfc
420cn networked fax/printer/copier/scanner and a notebook with a modem
and xp and fax service enabled.
Used word to do a mail merge but when it goes through the faxing it
faxes all right but faxes all doc...
|
3 |
5/28/2007 10:03:55 AM |
|
|
Section numbers greater than 999
After a mailmerge in Word 2003 to a new document I would like to print range
batches using the 'pxsx' string. A four-section document merged with anything
more than 250 addresses results in a Status Bar display of 'Page x Section
***'. Can the Section Number display be increased to 4 digits ?
--
WAR...
|
2 |
5/27/2007 4:37:53 AM |
|
|
Recipient Filters
I am completing a label merge with the recipient list in Excel. I edit the
list based on my criteria using the Advanced filters. I get the proper data,
however as soon as I go to preview my labels or complete the merge, Word
somehow adds more filters to my criteria & the wrong amount of data is placed
on my labels.
I have started from a new document as well have copied & pasted my dat...
|
3 |
5/26/2007 12:51:01 AM |
|
|
Choosing starting label
I can have a single address label printed from Word (manual address entry or
select from Contacts) and be able to specify the 'starting' row and column.
The nice thing of this feature is that I can use the same sheet over and over
until all the labels are used up. I can start at the top or bottom also!
Does anyone know how to specify the starting point for a 'label' mailmerge
with mul...
|
6 |
5/25/2007 11:23:53 PM |
|
|
Unable to use "enter" key
I'm working with a data application which uses MS Word and mail merge for
letters. My database is Microsoft SQL server.
If I open Word directly (just normal word-processing), everything works fine.
When I type information into my database, the mail merge function works
excellent as long as I do not use the “enter†key. If I use the enter key
when imputing data, I receive the foll...
|
8 |
5/25/2007 8:36:35 PM |
|
|
Document formatting email
How do I keep the formatting of a document that I am using as the body
of an email?
Can I use a PDF file as the body of an email, if so how?
The recipeint must see the document immediately upon opening the email
so sending the document as an attachment is not option.
Thanks for you help
Nancy
--
Nancy Tucker...
|
2 |
5/25/2007 7:49:45 PM |
|
|
Greeting Line Problems in Word 2007
I am doing a small mail merge using a word doc and an excel spreadsheet as my
data source. The first and last names are separate columns in the
spreadsheet. When I create the address block, it properly aligns the first
and last name. When I try to to the greeting line, I specify the foramt as
Dear Mr. 'Lastname' but word refuses to just use the last name. It will
constantly overwrite...
|
7 |
5/25/2007 6:28:30 PM |
|
|
Editing recipients by filtering
When I restrict the recipients I want in my mail merge using the Filter
button in the Edit Recipients dialog box, the recipients I want are
displayed. However, when I view the merged documents, there are a lot more
records that I had in the dialog box. When I return to the dialog box and
click the Filter button again, my criteria has changed, lines of AND and OR
criteria have been adde...
|
3 |
5/25/2007 5:43:03 PM |
|
|
Edit Recipients & Blank Fields
I am using Word to generate labels from an Excel datasource which I have done
successfully before.
This time I would like to filter about 5,000 records to print only customers
in County Durham with a Yes in the Catalogue column and a blank entry under
the Account No. column.
I can edit to show only County Durham customers and County Durham customers
with a Yes, but when I try and filter ...
|
4 |
5/25/2007 5:30:11 PM |
|
|
lable grid lines
I was working in a very long document with many format variations. I now
have tried to use the Mail Merge Lable maker and the lines that show the
boundries for the lables do not show. A blank page just comes up. I have
tried to compair settings on other computers but am at a loss as to how to
correct this problem. Please help as I use the lable maker a lot....
|
2 |
5/25/2007 5:05:25 PM |
|
|
labels using macros
Hi All,
I have a very peculiar requirement. There is a set template in word which
has details of drwg no, desc, item qty etc. which I have to pick up and
arrange it as labels:
Project Desc :
Item Qty:
Components:
The problem they are in a set format . I have to create a macro which when
used can create the label tags automatically by any user filling the form.
Any help in the ...
|
7 |
5/25/2007 3:04:18 PM |
|
|
Mail Merge
I have created a mailmerge using data from a query in access 2000. In the
past I have just be able to open the word document and press the merge
command and the letters are created with the data from the access query. For
some reason now when I try to open the word document I get an error message
saying "Can't find Data Source" and when I try to navigate to the query the
document won't...
|
6 |
5/25/2007 2:16:17 PM |
|
|
Problem restoring to normal document
After I merge the data, I click the "main document setup" icon and select
"normal word document", the field codes are not going away. This used to
work prior to applying SP2 to Office 2003. I have downloaded all office
updates and patches and the issue still exists. Help!...
|
2 |
5/25/2007 2:00:23 PM |
|
|
Labels
Is there anyone to import a .txt file into a label template without having to
do much formatting?...
|
3 |
5/25/2007 5:08:52 AM |
|
|
Mail Merge Field-Format Incorrect
I have a simple letter with a few fields pulling from an excel spreadsheet.
The cell is formatted as currency but when it is inserted into my letter, it
reverts to just numbers. I cannot figure out how to make the format of the
mail merge field be currency.
Help....
|
2 |
5/24/2007 9:21:26 PM |
|
|
Outlook Fields not showing up in Mail Merge
In outlook, I have Full Name Entries and Job Title Entries. For the Full
name I used Display name to get the Full Name to show up in the Mail Merge.
However, I cannot get Job Title to show up in Mail Merge. Title is the
Courtesy Title, which shows up in both the Address and Database forms. Job
Title will not. Is there FieldName for Job Title that I'm not using
correctly?
...
|
2 |
5/24/2007 6:07:11 PM |
|
|
Limited access to whole database using automergefield
I have a large spreadsheet of reading score data for a school. I want to
merge scores to one document. I had to confirm conversion to get data to
merge correctly. I am now limited to only 77 columns of my data. Why won't it
allow me to use whole spreadsheet....
|
2 |
5/24/2007 6:05:13 PM |
|
|
Insert image conditionally
I was on http://word.mvps.org/FAQS/MailMerge/CreateAMailMerge.htm where
there is some info on conditionally inserting an image into a document.
Unfortunately, I am not having much success with what it says should work.
Specifically, it says use something like this:
{ IF { MERGEFIELD FirstName } <> "" { INCLUDEPICTURE "C:\\Temp\\Logo.tif" \d
\* MERGEFORMAT } "" }
But it will no...
|
6 |
5/24/2007 2:21:29 PM |
|
|
How to send emails from different address in word
i have a mail merge that i am sending a message out to a couple hundred
people, and i want to send it through a seperate email address than my
default email address. is there a way to manually enter the email address to
send from?...
|
2 |
5/24/2007 8:25:34 AM |
|
|
Merge to Email From: Field
Hi All,
Im trying to create a merge to email from an excel file, all is working fine
except that I have no way to define a Custom From: Field. I dont want the
emails to be replied to my personal email I want them to reply to my
company's catch all email.
Normally when sending an email I add it to the from: field as I have
permission to send as the selected user. But there seems no wa...
|
9 |
5/23/2007 5:46:52 PM |