|
Using Mail Merge Data Source
When using word mail merge to create my datasource, (its not done in a table,
excel or access, buth through mail merge). Is there a total number of
records it can hold.
I'm up to about 500 and am unsure of the total number I can put in....
|
2 |
11/6/2008 7:32:23 PM |
|
|
Mailmerge - Replace fields and formatting
Hello everyone,
I'm trying to help a user with a mail merge I believe was originally done in
Word 2000; current user has 2002 with Excel 2002. It seems I have 2
different problems:
1) There are 4 "percent" fields, percent1 - percent4. Looks to me like
percent1 has been used for all 4, so I need to change the last 3 fields. In
Step 4 of the merge I've been clicking on "More items" and ...
|
2 |
11/6/2008 7:25:35 PM |
|
|
page numbering problem
I have a mail which is two pages long and merges however after the first two
pages on the merge document (Which are fine) every 2nd page has
Page 2 of 643
I have checked the original document for any insert page fields and tried
finding Page 2 of 643 in the document to remove them. But no joy.
Can anyone explain what I have done wrong on the mailmerge to get it to show
Page 2 of ...
|
2 |
11/6/2008 7:20:47 PM |
|
|
Mail Merge runs, but, nothing in Outlook
To those who can help!!!
I have used my Word 2002 to run outlook emails for each record in a
database.
Recently, it has stopped working.
My merge runs great, but, outlook does not get the emails in the outbox.
JMAC out
...
|
1 |
11/6/2008 5:31:52 PM |
|
|
Word 2007 mail merge for catagory listing, not listing in the return of the data.
I have followed this article http://support.microsoft.com/kb/294686/
to the letter. I have re-created their example with an Excel
spreadsheet and have used my own. In either case I cannot get the
result to sort the data with a heading and sub information. Each
record continues to show up on its own page (without the use of a
forced page break).
The code, straight out of the KB article:
...
|
3 |
11/6/2008 11:42:01 AM |
|
|
Mail merge rearranges columns in Access
I am making a mail merge document (Word) with Access as my data source. When
I click on the mail merge button in the Word document and go to edit recipent
list the columns listed there are in a different arrangement than my data
source. Why? and How can I get them to arrange in the correct order.
IE: Business name should be the first column in the list and it appears
toward the end.
...
|
2 |
11/5/2008 8:39:42 PM |
|
|
Why do addresses for Japan print upside down
The list of addresses I've typed include many for Japan which print upside
down. The country prints as a first line, the city second down to the persons
name which is last. All other address come out fine with the exception of
Germany and those are minor - Germany come out with the Company name first
and the persons name on the second line instead of the reverse.
Any ideas of what I can...
|
2 |
11/5/2008 7:28:40 PM |
|
|
Mail merge and catagory lists
I have followed this article http://support.microsoft.com/kb/294686/ to the
letter. I have re-created their example with an Excel spreadsheet and have
used my own. In either case I cannot get the result to sort the data with a
heading and sub information. Each record continues to show up on its own page
(without the use of a forced page break).
The code, straight out of the KB article:
...
|
2 |
11/5/2008 7:27:44 PM |
|
|
Mail Merge Print Preview
I have 65 labels to print. They all printed, however I can only see the
first page on my print preview and at the bottom it says 1/1 (not 1/3) and
cannot preview anything beyond page 1. As I mentioned, all 3 pages did
print, however. What can I do to preview ALL prior to printing? Thank you....
|
2 |
11/5/2008 1:48:29 PM |
|
|
Logo doesn't appear in merged document
I'm trying to merge a Word 2007 document with data from Access; the logo
displays perfectly in the original document, however when I merge it, only a
placeholder appears, with a red cross in the corner. I've tried inserting
other pictures and then merging the document, with the same result - so the
problem should be with the document. Any idea why the merged picture is not
displaying? Th...
|
1 |
11/5/2008 12:08:06 AM |
|
|
2000-2003 Merge Problem
I have a user who just upgraded from Word 2000 to Word 2003. She has a merge
file that uses a query from an Access 2000 database as the data source. The
data source comes into Word correctly, and she can do her merge. She has a
problem, though, when she only wants to merge certain records (e.g., only a
certain city). I
t appears that she now has to open the mail merge recipients scr...
|
5 |
11/4/2008 9:10:06 PM |
|
|
can i save individual pages from merged document
Hello,
I just merged a 2 page word document... and i am trying to save them
individually... I have a total of 200 docs that need to be separated and
saved in their own names.. is this possible?
Thanks!...
|
2 |
11/4/2008 7:44:40 PM |
|
|
SQL problem
I have a mail merge with word and ms access. When I was at my other office
our server had my my document folder on a redir on the server out there. Now
I'm in another office and the files are both on the t: drive of the server.
I have no problem opening the files. But the person that now prints out the
labels gets the sql message and when he says yes the it comes up with another
box ...
|
2 |
11/4/2008 5:41:51 PM |
|
|
Binary Operation in INCLUDEPICTURE Field
Hello,
I'm trying to initiate a Mail Merge in Word 2007 from an Access 2007
database. In this database, there is an Image column which is actually just
an integer. I'm using it as a Flag to indicate which of the 8 images are
actually stored for a particular record. The path creation is rather simple,
Static_Path\<<ID>>-<<Flag_Bit>>.jpg.
So, in access, I would n...
|
7 |
11/4/2008 7:49:07 AM |
|
|
Extra pages in a mail merge
I have a mail merge packet for lack of a better term. It is a list of
documents that i use to deal with individual cases. Every packet will include
certain forms and then based on the case extra forms are added with an if
statement.
{If {MERGEFIELD Extraneous}= "True" {INCLUDE TEXT "lists a file name"}}
This works fine. Problem is that if Extraneous is not "True" all i get is a
blank ...
|
2 |
11/4/2008 1:40:46 AM |
|
|
Word 2007 merge
I am pulling data from an data source. I want to display data along the line
of company and then the employees the work for the company. I have no problem
pulling the data, only displaying it.
Top half of the page shows company bottom half all the associate employees.
My question revolves around the NEXT or NEXT IF fields. If I use NEXT the my
merge shows company XYZ and the associated...
|
3 |
11/3/2008 10:06:05 PM |
|
|
mail merge directory creating page breaks
Hi,
I am trying to create a handout for a poster session that includes titles
and authors for each poster listed on a single page. The data is in Excel
2007 and I am using Word 2007 to do the merge. I have tried using the
Directory merge, but it keeps inserting a page break between each record. I
can't get them all on the same page. Can anyone help? I've tried saving the
source data a...
|
2 |
11/3/2008 6:59:21 PM |
|
|
Print mail merge in same position
I want to print membership cards.
I have the mail merge done and the mail merge is correct on the set up
position.
When I merge the second card details move around the page.
Regardless of the size of the text so I know that the text isn't rolling
onto the next line down. there appears no reason why it moves around, and
there's no pattern to wher it positions it....
|
2 |
11/2/2008 7:11:40 PM |
|
|
Email Mail Merge w/ Attachment Problems
Hello,
I am using the article submitted by Doug Robbins to send an email with an
attachment; however, I am running into a problem. I know I must be doing
something wrong but I can't figure out what it is. Can someone please help?
Here are the steps I've completed. I am using Microsoft 2003 for Outlook and
Word.
1. Selected Microsoft Outlook 11.0 Object Library under Tools-Reference...
|
9 |
11/2/2008 6:07:19 AM |
|
|
Run-time error '24': Bad parameter
We have a program that is not merging with word 2007. when we try to merge we
have to allow word to be open and then we get a run time error 24, bad
parameter error. the title is a microsoft visual basic. is there anything we
can do. we just installed Office 2007 and this error started popping up. It
worked previously with Office 2003. I'm using a pc with Windows XP
Professional on it....
|
2 |
11/2/2008 6:03:37 AM |
|
|
"Delivery point barcode" option grayed out in LABELS.
I'm printing address labels from Word 2003 and need delivery point bar codes
and need to print a full page of same label. The option, for some reason, is
grayed out whether I create the label from LABELS or via MailMerge. I could
find no information in MS knowledge base. Tutorials do not address this
problem and troubleshooting sections don't have a category for this. I'm
using Windows...
|
4 |
11/1/2008 11:45:42 PM |
|
|
hard return
I can't seem to remove a hard return in my mail merge letter. I have 3
fields: name, address, and then city, state, zip. There is a hard return
between name and address that will not come out. Can someone please tell me
how I can fix this? There are no hard return markers that would indicate a
need to remove something. Thanks for your help....
|
2 |
11/1/2008 11:42:54 PM |
|
|
Date Format Problems
I have several date fields on a merge document, merging from Excel,and have
used
FieldName \@ "MM-dd-yyyy"
but the result is the excel storage format ex = 39098 should be 01-16-2007...
|
3 |
11/1/2008 11:40:59 PM |
|
|
CustomLabels
Hello,
In C#, I'd like to know how I can iterate through the CustomLabels object to
get the customer label names. Any sample of code is apprieciated. Thanks!...
|
1 |
11/1/2008 8:42:01 PM |
|
|
More Mailmerge Problems
I'm running under XP SP2 and have recently upgraded from WORD2000 to WORD2007.
For a considerable period of time, I've successfully used WORD2000 mailmerge
to produce address labels (21 per A4 sheet) using a .txt file as my
datasource.
Under WORD2000, a simple setup procedure ensured that certain datasource
records could be precluded from the final merged document (eg if Field4 =
"C"...
|
2 |
11/1/2008 9:47:28 AM |