|
Mergefield issue and is merge limited to a certain number?
I have a database of customers in the form of an excel spreadsheet consisting
of 2707 entries. For some reason everything after 2705 are being ignored
within my mailmerge. Is Word (2007) limited to a certain number?
Secondly i have a label layed out in the following way.
<<Contact>>
<<Company>>
<<Address_1>>
<<Address_2>>
<<Add...
|
2 |
10/16/2008 2:12:17 PM |
|
|
Invoice No
Can I create Invoice Numbers in sequence in word for Mail merge...
|
2 |
10/16/2008 5:20:19 AM |
|
|
merging fields from Outlook Contacts
Hi-
My dev group has developed and addin for Outlook 07 that enables Outlook
'Contact'
fields to be merged into MS Word 07 templates. The addin works fine however
Word seems to be including a leading space for the second line in the
Outlook Contact BusinessAddress field.
This is an example of how the fields are setup in the Word Template:
<FullName>
<CompanyName>
<Bu...
|
3 |
10/15/2008 7:25:24 PM |
|
|
Watermark in mail merged labels
I'm in Word 2007, and need to generate hundreds of name badge labels.
I'd like to use a picture as a watermark on each label, and place the
bookmarks for the mail merge on top of the watermark.
So far, I've only been able to place the watermark on the entire page, but
not on each of the lables. The template I'm using is Avery 5392, 4" X 3"
label inserts, 2X6 on the page.
...
|
2 |
10/15/2008 7:22:51 PM |
|
|
How do I format a mergefield?
I have a table with a series of merge fields in a column.
I want to force the merge fields to always have 2 decimal places.
I'm using Word 2003...
|
8 |
10/15/2008 11:41:40 AM |
|
|
How to get the values for Comparison,CompareTo and TrueAutoText
I have a Document that is having many Field codes.
I would like to extract the following information from the if field.
{ if {MERGEFIELD Version} = "CustomerA" "contact abc@gmai.com"}
I tried using MailMergeField.Next.Code got the Condition, not able to get
other values
Dim doc As Document
Dim fld As MailMergeField
Set doc = ActiveDocument
For Each fld In doc.MailMerge....
|
3 |
10/14/2008 11:35:23 PM |
|
|
INCLUDETEXT putting both docs into merge
What have I doing wrong here? I want the merge to insert one document if you
answer "loan" and a different document if you answer "LOC" . I get an error
message "A field calcualtion error occurred in Record 1" and it inserts BOTH
documents.
Here's what I've done codes:
{ASK LoanOrLOC "Is this a Loan or a Line of Credit? (loan or LOC)" \o}{IF
{"ASK LoanOrLOC" } = "loan" ""{INCL...
|
4 |
10/14/2008 8:58:09 PM |
|
|
Word could not re-establish a DDE Connection to Microsoft Access
I am working with 19 school districts and over 100 schools. Every computer
can have different Microsoft Word and Microsoft Access installed.
I am getting the mesage:
Word could not re-establish a DDE Connection to Microsoft Access
When we get the funding we upgrade the oldest software and machines.
The system I am on now is SBS (Small Business Server) Word 2000 and Access
2002.
...
|
15 |
10/14/2008 2:41:46 PM |
|
|
Mail Merge with Labels
I have a custom made label that I am trying to merge with fields from an
Excel file. When Word 2007 asks me the label size, I don't know what to
choose from the list because my custom label is not listed of course. If I
skip the listed label sizes, Word does not recognize the merge as a label
merge - it shows it as a letter merge. If I pick any type of size, then Word
wipes out my cus...
|
3 |
10/14/2008 4:48:03 AM |
|
|
Can you send a mail merge to a large group WITH an attachment?
I want to do a mail merge with 400+ recipients. Is it possible to attach a
PDF file?...
|
15 |
10/13/2008 10:27:20 PM |
|
|
Mailmerge Fields appear Gray in Document
My mail merge command fields in word document looks like this
«First» «Last»
«Title»
«Company»
«Address1» «Adderss2»
«City», «ST» «Zip»
However, after merging with excel database, message appears saying that,
"Word found locked fields during update." How do I fix?
Also, the name and address information in merged document have gray
background, while rest of docu...
|
4 |
10/13/2008 1:25:54 AM |
|
|
mail merge -vertical orientation of data
In Word 2003 (Windows XP Pro OS) I was attempting to use mail merge for some
labels I am creating. When I did the Insert>Field, in the next dialog box I
selected Category > Mail Merge, then below that Field Names > MergeField
where I gave the field the header name which matched my data source (e.g.
first name) in the section titled Field Properties. Just to the right of
that ...
|
4 |
10/12/2008 10:16:53 PM |
|
|
Not enough memory to convert Excel in mail merge
I am trying to merge an Excel data file into Word and I keep getting the
message that it can't do this because there is not enough memory or disk
space. How much memory is needed? I have 85 GB available from a capacity of
232 GB on an iMac G5 with OSX. The word document is 28 KB and the Excel data
file is 2.7 MB. I have restarted my computer. There are no other
applications open. I...
|
2 |
10/12/2008 2:32:46 PM |
|
|
Initial zeros in zip codes getting dropped in Word mail merges
I'm doing mail merges in Word, using an Excel spreadsheet for the mailing
list. The zip code column in the spreadsheet is defined as zip code data and
the cells display the initial zero correctly (e.g., Natick, Mass. is 01760).
But in the mail merges, the zero gets dropped and the return address on the
letter prints as 1760. How can I make the initial zero print?
Along similar lines,...
|
2 |
10/12/2008 6:00:03 AM |
|
|
How do I print a list of mail merg recipients?
I sent application letters using mail merg. I wish to keep track of who has
responded and who I need to contact. To do this I need a list of the
contact's details which are held in the mail merg data file. How do I print
these details off?
I am using windows XP and Microsoft Word 2003....
|
3 |
10/10/2008 11:14:43 PM |
|
|
Add additional field delimiter choices when merging a text file.
We are merging a large text file full of legalese . These documents contain
paragraphs that could use any of the default field delimiters. Can one
expand or change this list of default field delimiters? Is so, how? If not,
any suggested work arounds?
We cannot merge from Excel or Access because the data contain more fields
than they can handle, i.e., > 255.
Thanks,
Al...
|
2 |
10/10/2008 6:40:16 PM |
|
|
Word 2007 mailmerge to outlook contacts
In Word 2007 I select the mailings tab. Than go to Select Recipients |
Select from Outlook Contacts I than get the error "Unable to obtain list of
tables from the data source." I am using Outlook 2007, Windows XP SP3,
Exchange 2007. I have checked my IE settings so Outlook is my default mail
client, I have also checked in Outlook contacts so the show in my address
book. Please help t...
|
5 |
10/10/2008 6:22:01 PM |
|
|
Mergefield Question
I have two mergefeld addresss, one called Vendor Address and the other is New
Address, where there is a new address in my excel sheet i want to use it, if
it is blank i want to use the Vendor address, is there a way I can do this?...
|
3 |
10/10/2008 1:40:01 PM |
|
|
MailMerge Doc Size
Is there a limit on how large a document can be to be sent in MailMerge? I'm
trying to send a 6 page document, and it is not going through. A smaller, one
page, doc goes through just fine. ...
|
5 |
10/10/2008 4:35:44 AM |
|
|
Mail Merge Dropping Leading Zeroes
Using Excel 2007 and Word 2007, I created a mail list in Excel formatting the
5-digit zipcodes as ZIPCODES and the 9-digit zipcodes as ZIPCODE+4. When I
previewed and printed the merged data, I saw the zipcodes with a leading zero
had the zero truncated (ie 02035 printed as 2035) and the 9-digit zipcode
printed as a 0. I temporarily resolved the problem by changing all 0-prefixed
zipcode...
|
4 |
10/9/2008 2:36:02 PM |
|
|
Mail Merge with Info on different lines.
I'm doing a mail merge with an Excel Database. Information about the
employee, his spouse and dependents is on separate lines. All members are
listed under the employees social security #. In the merge I need the
employees name on the first line, the spouse's name on the next line and
dependants' names on separate lines under that. How can I get the merge to
pick up the info on the n...
|
3 |
10/9/2008 7:15:42 AM |
|
|
2 sided mail merge
I have 200 letters to mail out. I have the mail merge done. I would like to
write my letter and have it print out on the back of every address sheet.
What I want is: the address on one side and the letter on the other side. I
have been printing the mail merge and then putting the paper back in the
printer to print the letter on the other side. Please tell me there is a
simpler/quicker wa...
|
3 |
10/9/2008 5:50:53 AM |
|
|
Print positioning on a mail merge
I am doing a mail merge with an excel spreadsheet. The spreadsheet contains
company names and addresses. There could be up to 3 address lines. I do not
want the blank address lines to print but I want everything below the address
to print on a certain line so that they do not display in a window envelope.
When there are address fields everything moves up thus displaying in the
window...
|
2 |
10/8/2008 11:16:36 PM |
|
|
Why do my labels print off center?
When I print labels, the labels don't match the gridlines in my document.
I'm using the "30 per page" setting, and checked all the dimensions, and even
aligned my printer, they still print incorrectly. ...
|
2 |
10/8/2008 7:57:41 PM |
|
|
Why does the date change from english to american in mail merge
I have been trying to do a mail merge from an excel document with dates in
but when the dates go into the word document they are in an amercan form ie
mm/dd/yy instead of dd/mm/yy can this be rectified...
|
2 |
10/8/2008 7:55:05 PM |