|
WORD mail merge: Insert column heading when table field changes?
I am trying to make a directory much like a dictionary would be set up. When
the first letter of the word changes I want to put a heading in the column of
words with just the first letter of the words after that. I am importing
from Excel all the cells I would need including a field with just the first
letter....
|
3 |
10/28/2008 3:23:48 AM |
|
|
Printing only envelopes with Mail merge /no letters included
I am trying to do a mail merge & print envelopes but I keep getting what
appears to be letters included in the printing. Every 3rd one is an
envelope, how do I eliminate the letters & get just envelopes. ...
|
4 |
10/28/2008 12:13:51 AM |
|
|
editing recipient list in 2003 Word mail merge
I am trying to use 2003 Word to merge mail with 2003 Access Database. When I
try and edit the recipient list, I should be able to re-order the receipient
list by clicking on the heading, which is not happening. In addition, the
arrow next to the column heading is not working either. No idead what I have
done wrong! Thanks
--
Angela...
|
2 |
10/28/2008 12:08:48 AM |
|
|
Using mailmerge functionality for non-mailing uses...
I'm trying to figure out how I can use the data from an Excel spreadsheet to
feed several different Word docs, for purposes not related to a mailing (just
trying to save on data entry). I'd like it so that when I enter a the name
of an item in my spreadsheet, the item name also appears in a specified place
in each of two different Word docs. Possible? Been poking around without
much ...
|
2 |
10/27/2008 11:49:01 PM |
|
|
formatting
After exporting some of my contacts from my database into an Excel file, I am
ready to merge in Word. So I do the normal addressblock after matching up all
of the fields. But I cannot figure out how to change the order of the block.
I mean I want the person's title under their name, but the title isn't even
included when I insert the block even after I match the field. I also want to
ins...
|
3 |
10/27/2008 7:31:19 PM |
|
|
Word 2007 - How To Edit a Main Document
I have inherited some Word templates (2003 format, .dot files) that
try to open a .txt file and perform a merge when the file is opened.
They present the following message when the template is opened, either
when opening the template within Word in File - Open or when creating
a new document based on the template:
Opening this document will run the following SQL command:
SELECT * FROM c:...
|
2 |
10/27/2008 7:16:04 PM |
|
|
Ho do I control the length of a mergefield
Hi,
I am runing a basic mailmerge using an excel spreadsheet. one of the
mergefields has some instances that are over 43 words long. When this happens
the merged field in the final document is truncated at 43 words. How do I
control the length of the mergefield to allow all of the words to be
displayed?
Thanks,
Matt...
|
6 |
10/27/2008 3:54:49 PM |
|
|
Fonts
Hi,
Am trying to create a coversheet and save it with the extension pcl....that
is woking fine. My problem is how can I tell what is a "native printer fonts"
in Word 2003.
Thank you ...
|
1 |
10/27/2008 1:03:01 PM |
|
|
Office 2003 mailmerge only produces 1 letter instead of 2 or more
Having installed Office 2003 on another PC I would like to revisit a
problem I have reported before. The following code processes all letter
merge requests, starting with the deletion of the contents of
MergeTable, which provides the merge data, and the running of Access
2003 queries to load what is required: -
Sub OpenWordDoc(strDocName As String, strLetterDescription As String,
strFormName A...
|
9 |
10/27/2008 9:14:08 AM |
|
|
Save formatted mailing label for address/phone directory
I have to create an address/phone directory several times a year. Each one
has the same layout and fields, but different information. I have been going
to Tools/Mail Merge and starting from scratch everytime. I've saved the
label format, but all that gives me is the size of the label. I still have
to reinsert and relayout the fields every time. I would like to save a label
somehow w...
|
4 |
10/26/2008 5:51:41 AM |
|
|
label printing problems
Help!! I'm having a lot of trouble printing labels. The formatting is correct
and prints correctly on plain paper, but when I try to print on the sheet of
labels the text prints about 1cm too high. I can't seem to change it no
matter what I do. I'm using Word 2003 and partners P21 labels.
Any help you could give would be greatly appreciated as printer and computer
will be thrown out of ...
|
3 |
10/25/2008 7:51:46 PM |
|
|
How can I mail merge labels so that the same name repeats across .
I am creating a mailmerge of student first and last names on a label. I
would like to create each row of labels with the same student's name going
across. My sheet has 4 labels across - i.e. Mary Jones Mary Jones Mary
Jones Mary Jones
and then another name repeat across for the second row, and so on. Is there
any way to do this?
Thank you!...
|
3 |
10/25/2008 6:24:29 AM |
|
|
How to send each document as a separate print job in Word?
How to send mail merge document as a separate print job in Word? Any help
will be greatly appreciate.
Thanks,
Kbrad32
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-mailmerge/200810/1
...
|
10 |
10/24/2008 7:44:13 PM |
|
|
Add someone in cc
I like to make a malmerge and add someone in cc - Is this possible?...
|
2 |
10/24/2008 7:38:02 PM |
|
|
mail merge and document file
I am having issues with the mail merge pulling in the wrong excel data. In
the mail merge menu I browse for and select a 2009 file. When the mail merge
automatically opens the file in excel it opens the correct file, 2009.
However when it gets to the step of selecting a named or cell range I select
I am getting a range for the 2008 file and not the 2009 file.
Does anyone have any i...
|
16 |
10/24/2008 5:55:07 PM |
|
|
Mailmerge with attachment - body only visible in first e-mail send
Hi
I used Doug Robbins macro to make a mailmerge with attachments.
However the problem I have is that the active document only appears as body
in the first e-mail send out.
The other mails have the attachment, but no text in the mail.
What do I do wrong?
--
Thanks
Cees...
|
4 |
10/24/2008 1:19:00 PM |
|
|
Problem with merging from excel to word....
I have a personnel spreadsheet that requires to be merged with people's
contracts, to do manually would take forever so have begun to merge the
documents which has been really quick.
This has worked fine for name, address etc and then I decided to merge job
titles as none of these will be generic and would be easier in long run to do
so.
I have exactly the same spreadsheet for each b...
|
7 |
10/24/2008 11:29:10 AM |
|
|
Using custom label format in word
Why can I not get my custom label format to work with word 2003? It is a
very frustrating problem. Everything looks like it works unti you see that
the format is not what you selected. Please help..........
|
2 |
10/24/2008 5:49:33 AM |
|
|
Custom label fromat in mailmerge
What is the deal with using a custom label layout in mailmerge. I select it
but it does not come up correctly. Why?...
|
2 |
10/24/2008 5:46:34 AM |
|
|
Using a custom label format in mailmerge office 2003
When I select my custom label format in office 2003 in a mailmerge it does
not come up properly. It just ignores the layout and uses something else.
Why? It worked great in office 97. Am I doing something wrong? Please
help. Very frustrating.
Greg
...
|
2 |
10/24/2008 5:45:42 AM |
|
|
Inserting a chart in a mailmerge letter
I am trying to insert a chart in my letter that I am also trying to
mailmerge. I have an excel spreadsheat of scores that I want to chart for my
student's parents. I do I or can I create a chart specific to each childs
scores in mailmerge....
|
2 |
10/24/2008 3:33:10 AM |
|
|
Can Word stop during the course of a merge to add additional data
I'm totally reaching for the ultimate but in a "novice" level.....
I have a database table that is available to merge into a word document
letter that is used by staff. Depending upon the circumstances behind the
letter, the counselors will choose which row of data from the table the want
to merge. This all takes place when they are in word. However, now they
want to know that if the...
|
4 |
10/24/2008 2:21:55 AM |
|
|
Need help with selective merge
I'm running a merge document and putting values into a table. I can put the
merge fields into the table just fine. Here's the problem: I have 3 fields
which may or may not have data in them, and the client doesn't want any empty
rows. Is there a way to format a row so it compresses down to nothing if the
mergefield is blank. Or a second approach would be to put the second field
into the...
|
8 |
10/23/2008 10:00:01 PM |
|
|
Word/Access 2007 Mail Merge Question
I have a couple issues with a mail merge that I need to get resolved. I have
a Access 2007 database that uses shared-level password. I have created a
dialog form that allows the user to enter a application number and select the
letter they wish to print from a drip down box. The problem is that when the
word document opens I get "Error has occured: Not a valid password" then the
Data Lin...
|
3 |
10/23/2008 6:38:13 PM |
|
|
Mail merge running in circles
I am using Word 2003 SP3. When I open a mail merge document, I get the
message "Opening this document will run the following SQL command...Select *
from C:\test\Test data.txt......Data from your database will be placed in the
document. Do you want to continue?...I click Yes and get the message Test
Data.doc is a mail merge main document. Word cannot find its data source
C:\...\test data....
|
5 |
10/23/2008 6:38:03 PM |