|
Mail Merge Mailing List
I want to copy this list OR modify it a creat a second list....
|
3 |
6/11/2007 8:10:56 PM |
|
|
Using data from all worksheets within a workbook for mail merge
I am trying to merge data from all the worksheets in one Excel workbook into
a Word document using Office 2000. I have tried using the converter and
opening the workbook, but it will still only show the fields from the first
worksheet. Any help anyone can give would be greatly appreciated.
--
Scott...
|
3 |
6/11/2007 7:47:37 PM |
|
|
need to add more fields to data form
I am trying to add more fields to the data form of a mail merge data source i
already have in place (i have name, address, etc and want to add like the
email address and some other data fields.). Is there anyway to do this?...
|
3 |
6/11/2007 7:47:36 PM |
|
|
tab delimiter problem
I'm writing a macro which includes a mailmerge process. Even though my source
file is tab-delimited, I keep getting a prompt for what delimiter I want to
use. Any suggestions on how to avoid this? My code:
With ActiveDocument 'xx
.MailMerge.MainDocumentType = wdFormLetters
.MailMerge.OpenDataSource name:=strWorkFileWithPath,
ConfirmConversions:=False, ReadOnly:=False...
|
4 |
6/11/2007 7:47:35 PM |
|
|
Mail merge using calculation field in an IF field
Hello All,
I'm testing with Word 2003 and when I perform a mail merge that uses a
calculation field inside an IF field, the calculation field seems to become
unlinked in the merged document.
That is, if I have something like this in my mail merge main document ...
{ = 2+3 }
{ IF { MERGEFIELD "MyName" } = "Ed" "{ = 2+3 }" "" }
.... after the merge the first calculation is still a...
|
9 |
6/11/2007 12:24:01 PM |
|
|
Mail Merge issue
Hello,
I m trying to write the code for a mail merge that takes the data
from
sql server and I want to prompt the user with a textbox and then
query
the database what is the syntax for that?
Sub Macro1()
'
' Macro1 Macro
'
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\Documents and Settings\My Do...
|
2 |
6/11/2007 10:06:07 AM |
|
|
word 2007 mailing
I have office 2007 small business edition. When I trying to use mailing in
Word 2007 and select outlook as data source, word crashed, gone......
Don't why? Help please...
|
2 |
6/10/2007 10:49:28 PM |
|
|
email merge - several records should go to 1 address
I am trying to do an email merge to email authors about their articles. In
my data file, there is one record per article and sometimes an author will
have written several articles. If I do a straight email merge, the author
would get a different email for each article - but I want each author to
get just ONE email which would list all of their articles.
I have tried using the suggestions ...
|
3 |
6/10/2007 2:53:01 AM |
|
|
Merge and Sort - unexpected result
Hi, I am trying (with much frustration) to do a simple merge and sort to
labels in Word 2003. The merge is from an Outlook Contact List Folder. I
use the 'advanced' tab and set two simple rules
E-mail address 'is blank'
AND
User Field 1 is 'greater than' 2004.
The merge window brings me back the correct results with the correct entries
and all looks good.
However, I then click ok...
|
3 |
6/9/2007 4:37:01 PM |
|
|
Mail merge - labels
I am working with Excel 2003 and a large database. Part of what I am doing
involves makeing labels that include name and birthdate and SIN number.
After making my list with the birthdate formatted to dd-Apr-yyyy and sin 000
-000-000, when I go to Word to do labels, these two formats do not stay in
the column. They become dd/mm/yy and 000000000.
When I first started doing this, it was OK b...
|
2 |
6/9/2007 4:30:24 PM |
|
|
all page numbers became 1 after mail merge
after mail merge all the page number became 1.
I want the page is continous.
I tried delete all the page break by replacing "^b" with "".
but can't find any page break.
help me please....
|
9 |
6/9/2007 8:12:29 AM |
|
|
Not printing to correct tray
I have a user who is using mail merge to create envelopes. However when she
does the print and selects tray 1 (The tray with the envelopes) when the
print job arrives at the printer it is going to the default tray with 8 1/2 X
11 1/2 paper in tray 2. Any ideas on why it is selecting the default tray
instead of the tray 1. Also this is not an issue when she prints a single
envelope....
|
2 |
6/9/2007 5:30:24 AM |
|
|
Merge Picture Not Working
For the sake of my sanity, can someone please tell me what I'm doing
wrong? I'm using Word 2003.
I'm trying to create a directory with the person's picture beside
their personal information, so I'm using two columns - one for the
picture, one for the name,phone#,etc. What's happening is the textual
information is updating and showing each subsequent record in the
file, but the all the pict...
|
3 |
6/9/2007 5:23:54 AM |
|
|
Automating mail merge
Hi!
I apologize if this is answered in the forum, I have looked and can not find
an appropriate answer. I have 218ish xls files that I need to merge with a
word mail merge document and save the output .doc file with the same name.
i.e.
test1.xls
test2.xls
test3.xls
output to:
test1.doc
test2.doc
test3.doc
Any help would be appreciated as I have been unable to do this w...
|
4 |
6/8/2007 6:02:29 AM |
|
|
Word Mail Merge
What's the procedure for merging a manually constructed, properly coded list,
such as an inventory (column headings have the field names, as required) so
that the result is a formatted list (formatting is specified in the main
document). When I try to merge, I get a single entry, as if I were doing
envelopes. Using the same files, I used to be able to get a formatted
multi-page list. I'...
|
2 |
6/8/2007 4:52:19 AM |
|
|
mail merge
I have an excel spreadsheet with club members data on it. (name address,
city, state, phone, etc.) I want to add (export) that information into an
Outlook Adress book. How do I do that? Thanks...
|
2 |
6/8/2007 1:57:59 AM |
|
|
Calendars in form fields
In Word, is it possible to create a drop down menu showing a calendar from
which a date can be picked? eg on MS Project if you click on a date field a
drop down menu appears and from it a date in future months or past months can
be selected....
|
8 |
6/8/2007 1:55:57 AM |
|
|
Addressing an Envelope
Im having Trouble with MS WORD for Addressing an Envelope? Can you Help?
When I Print it does Print an Envelope but the Screen shows another blank
Page & Starts Printer Again? How do remove the Second Page?
Why Does it have a blank Page Below the Envelope Page Im uranger93sing?
Microsoft WORKS does Not do this...
|
2 |
6/8/2007 1:35:37 AM |
|
|
Mail Merge Duplicate Recipients at one address
I'm trying to set up a mail merge for envelopes for a mailout. In many
instances there is more than one person at the same address but not from one
family. For example, Joe Smith, Jane Doe, Mike Jones, Tom Smith all living
at one address. I want to have an envelope label that has all the names, and
the address on one envelope, so i don't have to send the same thing five
times to each ...
|
2 |
6/8/2007 1:32:31 AM |
|
|
Mailmerge plain textfile selects double-byte (Chinese) characterse
I'm trying to mailmerge a Word 2003 document (in Arial 12 Western
characterset - language Dutch) with a plain text file. For some reason the
converter seems to detect double-byte characters - which aren't there - and
changes the characterset to Chinese Traditional.
When using the same record in a truncated file (same information, but a lot
less records in the text file) the conversion is ...
|
2 |
6/7/2007 4:13:42 PM |
|
|
Mail Merge combines characters into one column
1 out of 3 times when using mail merge in creating letters, the output
produces my letters however the characters overlap each otherin one single
column. I can not recreate this problem every time, and I use different
sources including excel and out look and get the error in both....
|
2 |
6/7/2007 4:09:04 PM |
|
|
How do I find a merged document's spreadsheet?
I have a merged document but I can't find the spreadsheet I've merged with
this document. How can I find it?...
|
2 |
6/7/2007 3:50:41 PM |
|
|
date format changing in mail merge
When mail merging a word document through an Access database, the date format
field changes from UK to US. How do I prevent this?...
|
2 |
6/7/2007 3:48:44 PM |
|
|
Problem with Envelope and Addressee Region
OK, this one is new to me and I don't know what setting is messed up.
XP Pro SP2 with Office 2003 (V 11 Build 5604) I have the following in Word
as AddressLayout
{<PR_GIVEN_NAME> <PR_SURNAME> | <PR_DISPLAY_NAME>}
{<PR_COMPANY_NAME>
}{<PR_STREET_ADDRESS>}
{<PR_LOCALITY>}{, <PR_STATE_OR_PROVINCE> <PR_POSTAL_CODE>}
Now if the region for ...
|
3 |
6/7/2007 1:34:09 PM |
|
|
can i have word 2003 sent as an attachment with lotus notes
can i have word 2003 sent as an attachment with lotus notes?...
|
2 |
6/7/2007 12:16:14 PM |