Mail Merge from data in excel to word document.



  • 1. How to change path to mailmerge excel data source?
    Hi all, I have a word mailmerge document that is linked to an excel data source. Everytime the excel data is updated, a VBA macro starts the mailmerge process to create the output document. My problem now is that different users have to use this from different locations so the even though the relative path between the excel sheet and the word document is the same, the absolute path differs because of different localizations and drive names. I am now looking for a way how to make this location-independent. I tried the OpenDataSource method from the macro but then I get asked to select which sheet to use. Are there other ways that work with DDE? I can not create ODBC datasources on each system. It should work with at least Word XP / Word 2002 if possible also Word 2000. Best regards, Reiner Buehl.
  • 2. Mail Merge is extremly slow in WIndows XP....
    I have a letter in Word that I merge with a Database in Excel on a daily base. The database has thousands of records. Before Windows XP I could find a record in a matter of seconds and merge my letter. Now it takes minutes to find the record. I could type the informtion faster. However, that defeats the purpose of the mail merge. I have tried moving the data to a Word document and merge it fron there, but it makes no difference. Does any one know why this has happened and how it can be fixed?
  • 3. Mail merge keeps asking for data source
    I have created a word document in word 2000 for mail merge. This datasource points to a query in MS Access 2000. In Access 2000 i have written code to open the word document. This worked perfectly in the 97 version. When i hit the button to open the document, it keeps asking me for a datasource name. The datasource already exists. I don't know why it does this? Any suggestions?
  • 4. No Images Received in Email Merge
    I have a html word doc. with a few scattered pics for an bulk email to my customers. When I send it directly out of word to my personal email it opens perfectly with images and all, but when I send it out as a mail merge, it disregards the images and sends text only. Any help would be greatly appreciated!! David

Mail Merge from data in excel to word document.

Postby S2Fycmll » Fri, 11 Nov 2005 00:02:01 GMT

I have an excel database which I am trying to merge into a letter.  However 
where I have used a date and formatted the cells correctly for English date 
in excel they change to American in the word document.  I have also used a 
funtion to show day of the week and this changes to a date.  Can anyone help. 

Re: Mail Merge from data in excel to word document.

Postby Anne Troy » Fri, 11 Nov 2005 00:47:02 GMT

Try this, Karrie:
Anne Troy

Similar Threads:

1.Mail Merge from inside word document using excel data file

We are using XP, and Office XP and unable to do a mail merge from inside 
Word. The data file is an Excel spreadsheet. When going to Tools/Letters & 
Mailings/Mail Merge/Use existing list
A box pops up which says "Data Link Properties" with tabs for "Provider, 
Connection, Advanced, & All".
If I do test connnection, it fails with the error "Test connection failed 
because of an error in initializing provider. Catastrophic Failure" 
If we do not run the test and try to continue to the mail merge, Word 
crashes and restarts. Either way we do not get a mail merge.

I'm thinking it has to do with the provider settings. I have tried to change 
this and I have managed to get a connection but when make any further 
attempts to continue - I only get an error message or the merge screen leaves.

2.insert Excel data into Word Mail Merge document

I have a Word document set up for Mail Merge, and I'm trying to incorporate 
data from Excel into the merged document. 

I'm developing a Bid Manual, and I'm creating 45 individual bid specs.  Each 
merged record needs to have its own unique (table/list/data--whatever way I 
can get it into Word!)---this data is currently residing in 45 cell ranges (4 
columns each, varying number of rows) in an Excel spreadsheet.

Oh, and I'm trying to make this process as automated as possible, since the 
end users of this project will have minimum skills in Word or Excel.

I've tried all kinds of macros, links, etc. and I'm not getting 
anywhere....anyone have any ideas???

3.Word 2000 mail merge created documents also opens Excel data sourc

The separate documents I created using Mail Merge are opening with the Excel 
data source.  How do I stop this from happening?

4.Word 2000 Mail Merge: Word found no mail merge fields

Hello everybody,

As the subject says, I am trying to create a form letter in Word 2000
from an Excel 2000 spreadsheet, but when I try to to open the data
source, I get the following error: "Word found no mail merge fields in
your main document".  How do I create mail merge fields?  Can anybody
help me?

Thanks in advance.

5.How do you do a mail merge for a mailing list from a word document

I have been trying for 2 days to mail merge a mailing label list.  Nothing 
seems to work.  I am using a word document for the source and seem to be 
following all the directions, but it just dosen't work.

6. Mail merge hang, MS Word 2000 mail merge to MS Excel

7. Mail merge problem when filtering data from Excel data source

8. Merging Excel Data to an E-mail Document

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 6 guest