Over 1 million tech questions and answers.

Mail merge Outlook contacts with word document?

Q: Mail merge Outlook contacts with word document?

We have several Word documents (PO's, Quotes, etc.) that currently are used with ACT! to do mail merge (only to import contact info to a single document). We are moving to Prophet (which works with Outlook) and want to continue using these documents. Office help says you have to have matching versions of Outlook/Word (we don't).
Is there a way to make Outlook 2003 merge contacts as needed into these Word documents without upgrading everyone to Word 2003?
Thanks.

RELEVANCY SCORE 200
Preferred Solution: Mail merge Outlook contacts with word document?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Mail merge Outlook contacts with word document?

If Office help says no, then so must I.

Read other 1 answers
RELEVANCY SCORE 118.8

So maybe it's late and I'm cranky, but I didn't see this thread already.

Microsoft Office 2000 - Win Me (unfortunately)

I'm trying to mail merge my Outlook Contacts/Address book into a printed document to carry between computers. It works great using "use address book" and looks fabulous if I do say so myself. The problem is that it skips many of my contacts. It doesn't matter if I sort or filter the records. It skips the same people and I don't see any similarities among the skipped records.

I'm open to suggestions because this is just weird.
 

A:Mail Merge Lost Outlook Contacts in Document

a-hawks:
I've considered your post, and can only think to test the doc on my PC. If that's an option for you, email to [email protected]. I'll see if it does the same here and, if so, why...
 

Read other 1 answers
RELEVANCY SCORE 94

Dear Sir,

Hi

I hope you will be fine. I need your help as I want to merge data on Proof of Delivery. My files are attached. Kindly guide me how to merge multiple records into lower part of document (table) as the upper part of document is not falls under Directory Merge. The key field is Patient ID. Kindly help.

Kind Regards
Shehbaz H.

A:Mail Merge Multiple Rows into One Document in Microsoft Word

I am really surprise to know that no expert available on this forum for reply. I have done some work but it is not corrected upto the mark. Screenshot by Lightshot

I need patient id wise breaking items into next pages. Is there anyone for help?

Read other 2 answers
RELEVANCY SCORE 93.2

Trying to perform mail merge using outlook contacts
 

Read other answers
RELEVANCY SCORE 93.2

Computer: Dell Inspiron 6000 with 1.5 GHz Pentium M processor and 2 GB of RAM.

Windows version: XP/Pro SP 3 (V. 5.1 Build 2600.xpsp.080413-21111 : SP 3)

Word version 2002.

I have 2 problems with using the Outlook version 2000 Mail Merge feature.

Problem 1:

I want to Mail Merge Outlook contacts into Mailing Labels. however, there is a field missing from the available fields after I complete the all the steps.

I tried this 2 ways:

1. All contacts in current view/All contact fields

2. All contacts in current view/Contact fields in current view--after adding the Categories field to the Current View

I also tried adding a user-defined field and then tried both choices above.

In all cases,the Categories field or user-defined field is missing from the available fields: missing from the Insert Merge Fields and missing from the Mail Merge Recipients dialog box.

Here is the sequence I use:

Open Outlook

Click on Contacts shortcut (or View/Go To/Contacts)

Tools/Mail Merge

Select All contacts in current view/All contact fields from the dialog box choices. Select Mailing Labels from the Document type drop down box.

Click OK

Click OK on the warning message: "Outlook has created a MailMerge document...."

In the Mail Merge Helper dialog box, click on Main Document/Setup

Select the label product/type from the Label Options dialog box. Click OK

Click on Data Source/Get Data/Use Address Book. Select Outlook Address Book. Note that the Categories field is not include... Read more

A:Missing field(s) in Outlook contacts using Outlook Mail Merge

I would export my contacts to an excel spreadsheet then run mail merge. You never know whats going on inside outlook...
 

Read other 1 answers
RELEVANCY SCORE 91.2

I hope someone out there has the answer as I have spent many hours trying to work this porblem through.

My outlook 2002 contacts when I transfer to mail merge there is an inconsistency with the details I have entered in the data. Like one will have the Mr and then it will miss a few then maybe decide to add it again there is no pattern happening. So when I attempt to enter say a 300 odd contacts mail merge I have to individually go through and alter and check each one. My outlook contacts data is filled out corectly with the Mr & Mrs (or whatever is applicable). At time it will say Dear Anna (not Dear Ms Cox) then on the next one it could say Dear Mr Williams - whereas all the data is filled out exactly the same. I hope this makes some sense it's driving me mad!!!!
 

A:moving outlook contacts data transfer to mail merge

I thought you could set up rules or conditions when you mail merged. So that if a particular field was blank, it would not be included.
 

Read other 1 answers
RELEVANCY SCORE 88.8

Windows XP Professional Service Pack 1 with office 2002 plus Outlook 2003 installed, Exchange 2003 is being used as the e-mail server.

When I do a mail merge from Word 2002 to e-mail for a mass e-mailing in Outlook 2003. The process completes but there are no e-mails sent from Outlook 2003. The e-mails that were merged are never recieved by the recipents that are being set to. Help.
 

Read other answers
RELEVANCY SCORE 88.4

Hi
I used Word 2007 for mail merge to send about 1000 mails to my prospects
After I click the Merge and Complete button, for every email it sends, outlook pops a warning
"Some program is trying to access to send email. If it is not ok, click deny and check your virus settings ..."

I am forced to click "Allow" for every mail, this is too much to take for the number of mails I am sending
Is there a way to disable this warning system when I am doing a mail merge

Kindly help

Thanks and regards
Sasi Sekar K
 

A:Word 2007 - Outlook Mail Merge Warning for every mail

Read other 6 answers
RELEVANCY SCORE 87.6

Can anyone advise me if there are limits anywhere to the number of e-mails I can send out simultaneously when using a mail merge to e-mail? I have set up and tested the mail merge and it all works fine, but I don't want to launch the real one only to get problems. I have a mailing list with 1,600 addresses, I'm using Outlook and Word 2011 for Mac to do this.
 

A:Mail merge to e-mail using Word / Outlook 2011 for Mac

One of the problems your going to face is getting labeled as a spammer. If your sending these internally it may not be a problem. The standard answer for this is to Outsource this if your sending over 100. Good decision not to launch the real one yet.

A detailed response to similar question in StackOverFlow
 

Read other 3 answers
RELEVANCY SCORE 87.2

When using a mail merge documnet in word and using Outlook Contact as a database the merge fields do not all match, The state = city and the zip code = state. I have match fields and saved format but the same issue occurs in a new document
 

Read other answers
RELEVANCY SCORE 86

Maybe the Office 2002 gurus out there can direct me to a solution to this pesky problem...
When I try a mail merge to make mailing labels with Word 2002, I always use my Outlook contacts for the data.

However, Word always gives me an error message that says that Outlook is not configured as the defualt mail client. It instructs me to make the changes in Outlook and to try again.

I've been in Outlooks Tools menu, as the help files tell me, and have checked the settings, and made sure the box is checked to configure Outlook as the defualt email program, but Word behaves the same.

Any suggestion?

Thanks,
Ken C.
Chino Hills, CA
 

A:Problem getting Word to use Outlook for Mail Merge

Try this, go to contol panel, click on internet options and on the program tab set Outlook as the default email program.
 

Read other 2 answers
RELEVANCY SCORE 86

We started by creating a Mailing Label template using the Mailing Label
Wizard in Word. The fields we set up were:
First Name
Last Name
Company
Street Address
City
State/Province
Postal Code
Then we went to Outlook and chose View by Category. We then highlighted all names in the category we wanted to merge. Then we tried to merge using
these commands:

Tools
Mail Merge
Only Selected Contacts
All Contact Fields
Existing Document - (We browsed to the Word template we had set up)
OK

This opened up a Word screen as asked us if we wanted to Merge now which we clicked on and selected Merge in the next screen too.
Upon selecting Merge the second time, an "Invalid Merge Field" screen opened
up with these options:

This merge field is used in the main document, but it does not exist in the
data source: State/Province
Postal Code

Options were to Remove Field (which we don't want to do) or
Replace with a valid merge field from data source.

If we selected the second option we could enter State and ZIPPostal Code but had to do this for EVERY label (30 times) and then it would work, but we
couldn't figure out how to change our template to read this way, because
when we tried to do that it reverted back to the standard fields in Word
which are not recognized in Outlook.

In other words when we did step 2 and entered the fields in the create labels template box and editing the fields in that step they converted back to standard fields.
Any ideas appreciated. Thanks.... Read more

A:Word 2000 Mail Merge with Outlook

Easiest when merging with Outlook:
Copy all your contacts to a new contacts folder.
Expert the contacts to an Excel file.
Merge to the Excel file.
 

Read other 3 answers
RELEVANCY SCORE 86

I am trying to do a selected mail merge and ever time I get to the part we I select the files that I in my contacts it is looking at personal folder/Sent Items/Conflict. It will not allow me to select where my pst's are.
 

A:Mail Merge Word 2002 with Outlook

Read other 7 answers
RELEVANCY SCORE 85.2

I have windows 7 & office 2007. I am attempting to create an email merge. I have tried to do so starting with first with outlook (which takes me to word) which failed in sending, and then starting with word (which takes me to outlook and then back to word) and also failed in sending. I have followed all instructions to a T (as provided by help in both programs as well as microsoft help online).

What am I missing? Is there some connection between the 2 programs that needs to be set up first?

Read other answers
RELEVANCY SCORE 84.4

This fixes the problem of having word show an empty address book from Outlook Contact folder when doing a mail/merge in Word.

1. I went to Outlook, clicked on Tools, then Email Accounts, then View or Change Existing Directories or Address Books

2. I then highlighted Outlook Address Book and clicked on Change

3. I then removed each address book listed, clicked on close, clicked on finish.

4. I then went to each Contacts Folder and right mouse clicked and selected the Properties option.

5. I then clicked on the Outlook Address Book tab

6. I put a check mark in the "Show this folder as an email address book"

Prior to all this each contact folder already had this checked. So God only knows why this issue existed but it did.

After doing these 6 steps I went to do a mail merge in word and selected the Contact Folder that had been showing up empty before. It no longer was empty.
 

A:Solved: Issue with Word mail merge with Outlook 2003

Just a tip: if you want to mark a thread solved, use the Thread Tools at the top of the page instead of double-posting and changing the title. Go ahead and mark your original thread solved, a mod will probably delete this one.

Glad you got your problem sorted.

chris.
 

Read other 2 answers
RELEVANCY SCORE 84.4

I have recently upgraded to Office 2010 (from 07) and I perform a lot a mail merges. I have come across a few issues with this feature within 2010 and wondered if anyone has a solution. I am obviously running Windows 7.

Issue 1 - When performing the mail merge to emails (HTML), Word 2010 doesn't seem to recognise my IMAP email account, which is set as default in Outlook 10 it uses one of my other pop email accounts.
Is there any way to set my IMAP account as the default for mail merging?

Issue 2 - Once I have completed the email merge I then need to create them as a PDF, which in 2007 worked fine but the Acrobat addin in Word 10 doesn't do anything. (I do have Acrobat 8 prof installed as well) I have done a little research and can see that this is a problem but I need a solution to fix.
Otherwise I'll be reduced to uninstalling and re-install 2007!

Anyone with solutions please let me know.
 

A:Email Mail Merge Issue - Word & Outlook 2010

Hi welcome to the forum,
Have you tried the macro to save As pdf file of print to the adobe pdf printer?
 

Read other 1 answers
RELEVANCY SCORE 84

Failure Of Sending Word Doccument To Mail Recipient. What Could
Be Wrong??:: :
 

A:Cannot E-mail Outlook Word Document

Duplicate closed, please continue this here: http://forums.techguy.org/web-email/483690-outlook-problem.html
 

Read other 1 answers
RELEVANCY SCORE 83.2

Hi....
I'm using word 2010.
I have a Mailmerge document (actually a company letter with header and footer, used by a package called "Cash4Windows" [C4W]). This document usually has the recipients name and address etc. inserted by C4W.
The document is a template - "xxx.dotx".
What I want to do is strip out the Mailmerge fields and save the document as a normal Word 2010 document, 'cos the User wants to have a blank standard company document available.
I've spent a long time fiddling with the Header and Footer to get just what the User wanted, and I know i could just cut-n-paste the Header and Footer into a new document, then save it as "xxx.docx", but when I looked on various help sites the normal method in Word 2010 seems to be
on the ribbon tab
Select Mailings
Select "Start Mail Merge"
Select "Normal Word Document"
then save the Word document.
I've tried this and it has absolutely no effect, as when I close and reopen Word and select the previously saved document, I still get the "Opening the document will run the following SQL command" splash screen!
I've tried saving the "normalised" document with various different extensions, but nothing seems to get rid of the SQL.
I've also tried opening the VBA editor (Alt+F11) to see if I can find the SQL, thinking that if I can delete the SQL it might cause Word to avoid the prompt, but I can't even find the SQL!!!
I know I'... Read more

Read other answers
RELEVANCY SCORE 82.4

I'm using Office 2003. I went through the steps of doing a mail merge from word. I selected the Outlook contact folder I wanted to use and it shows no contacts in it. However, there are plenty of contacts in that folder. So I tried another contact folder and it worked just fine. Any suggestion on this one folder?

Thanks.
 

A:Solved: Word mail merge shows empty outlook contact folder

Right-click that Contacts folder and hit Properties. Go to the Outlook Address Book tab and make sure it's checked to be seen as email address book.
 

Read other 3 answers
RELEVANCY SCORE 76.4

I have done typing over the Internet for years. My regular computer is in being fixed and they have given me a loaner. The only strange thing about it is that when I used my own disk to load Word 2003 on the loaner computer, it came up with its own product code - you know those letters and numbers you have to put in -- anyway, I tried to enter my own, but it would not work. I had to use the ones that automatically came up. I don't know how they got there. The only thing I can think of is that the previous owner of the computer had loaded Word and that this was his product code!

Anyway, my work requires the use of templates that are merge documents. I have to install a certain SQL file in C:\WINDOWS\Temp. The file is there. I have checked. But when I open a document it says its looking for the SQL file in C:\WINDOWS\Temp -- but it can't find it.

I have tried and tried all morning - emailing the company back and forth in the UK and it just will not work. I am completely baffled. The file is there - the path is correct and yet it says Word cannot find it.

Does anyone have any suggestions? The only thing I can think of is that the previous owner - the owner of that product code - had some kind of administrative blocking on the computer.

Anyway, I am not making money and would like to figure it out so appreciate any help.
 

A:Word 2003 merge document problem

Hi Purley,

How did you get the SQL file into ...temp?

You need to have the SQL file point to a data source; the SQL is just a filter against a data source somewhere else and that connection needs to be established first.

Is the source database on another Server e.g. at the Company you are doing work for?

You should contact the company's IT admin to make sure you have connectivity.

lol
Hew
 

Read other 2 answers
RELEVANCY SCORE 76

How can one make a mail-merge document undeletable, but still have it merge (with an Access query)?

Have tried setting the "read-only" property. MS Help on the subject of "read-only" says initially "To prevent unauthorized changes OR DELETION"... but you can delete a read-only document any time you want.

So the question is: Is there a way to make a document undeletable except by password? And if you impose a password on it, will it work as a merge document?
 

A:Make mail-merge document undeletable

No, Don. But this can be done by rights on the server folder in which the file is stored.

The thing is...you should make it a template. Then, File-New to access it. That way, it is less likely to be deleted...
 

Read other 1 answers
RELEVANCY SCORE 75.6

Hi guys,

So here's what I'm trying to do. Basically I need to create a word document report from data in an access database. The access database basically contains risk items for different entities. So, the report will contain all the risk items for one specific entity and a summary.

What I want to be able to do is enter all this information into the database and then automatically generate the report. The database is basically setup, including the queries I need. I just don't know how get the information over to word in the way need.

The main problem is that I need a summary section that lists the number and types of risks found above, and then the details of each individual risk below. So a very simplified example:

Report for ENTITY 1.

Summary
1 High Risk
2 Medium Risks
6 Low Risks

Detailed Information
Risk 1: RISK 1's NAME
Severity: High
Infomation: This is the information about risk 1.

Risk 2: RISK 2's NAME
Severity: Medium
Information This is the information about risk 2.

...

I know that this is not a standard "mail merge", but I thought it might be possible using VBA. I have used a (very) little VBA, but I am willing to learn more. I just need a push in the right direction as to where I might get the information I need. Several other things I would like to be able to do (but could sacrifice if necessary) are pulling images stored as OLE objects in the access db into the report for each risk and being able to control the backg... Read more

A:Access/Excel merge to complex Word document

Read other 16 answers
RELEVANCY SCORE 75.6

I have an excel file with over 2000 names that I need to make a word merge document out of. I copied and pasted the information from excel into word 2000. I put it all in tables so that it would be separated by the fileds so that I could sort it alphabetical by city and state. But when I go to make the merge document, I already had a letter to merge the names and addresses into, it will not merge. What have I not done, or still need to do? Can someone help me please. I missed my deadline 2 days ago.
 

A:Excel Spreadsheet to Merge Document in Word 2000

Read other 7 answers
RELEVANCY SCORE 75.6

Hi,

I've been given the task of finding software which will enable a customer contact list to be maintained and be accessible anywhere by multi users, this contact list should then be available to create email mail shots as well os postal mail shots.

I can find software that will maintain a database online, and I see mail merge in Microsoft but I can't seem to find anything that will bring both together and online to enable the multi user, multi locations.
Any ideas?

Thanks in advance

K
 

A:Database, Contacts, Mail Merge Online Software

Access does both database and Mail Merge using VBA, Word and or Reports, but I don't know much about the "Web" based part. I have never actually worked on one on the web.
 

Read other 2 answers
RELEVANCY SCORE 74.8

Looking for some assistance to see if what I am asking is even possible in excel. I have data in excel(158 lines) that I need to put into a form letter through a mail merge(158 individual letters). Once the mail merge is complete the form letter will need to be email to multiple contacts and CC'd. I was wondering if there was a way to create a macro to complete the mail merge, open outlook, send to multiple contacts and CC for all 158 lines or individual letters? Its hard to explain and hoping my request makes sense

Thanks in advance
 

Read other answers
RELEVANCY SCORE 74.8

Is there a way to merge the outlook contacts of different people? People in my office have each accumulated their own business contacts but would like to share info to be more efficient. Is there a way to create a master list within Outlook that everyone can have access to?

A:Merge Outlook Contacts of different users

If each user Exports to a .pst file by name (eg: GeorgeSmith.pst) then you could Import that to another networked computer.

I think.

http://www.online-tech-tips.com/ms-o...look-contacts/

Read other 5 answers
RELEVANCY SCORE 74

I have MS Office Enterprise 2007 (Word/Outlook), and I want to do a Mail Merge including the contacts inside a customized form(s) called "Company Contacts" hosted on Exchange Server 2003. I can do a Mail Merge from my local contacts, as well as the contacts from another mailbox I have access to. However, the Mail Merge fails to pick up the Contacts/customized forms in the Public Folders. I copied the "Company Contacts" file to my mailbox, and tried removing the Sharing Permissions so I am left as owner. I tried doing the Mail Merge after that, but it didn't get picked up by Word 07. I tried exporting the "Company Contacts" file as a .pst file, and attaching it to my Outlook 07 client, and then tried to do the Mail Merge again, but this also failed. Any ideas how I can accomplish this? Thank you
 

Read other answers
RELEVANCY SCORE 73.6

Hi, I am really hoping someone can help.

I am working on a MS Word mail merge document (whose format I do control). I need to populate a table on my document that lists the Fund #, Name and Value for up to 7 funds (3 columns and up to 7 rows). However, they do not want to have any empty rows in the table - if there are only 3 funds in the datasource, only 3 rows should show in the table. I thought there would be a way to use a bookmark to do this, but I haven't been able to figure it out.

Please help,
 

A:Solved: Show/Hide rows in a table on a Mail Merge document

Read other 16 answers
RELEVANCY SCORE 73.2

Hi All,

I am trying to do an e-mail merge from a database that is saved on my hard drive.

According to the help files in WORD 2000, I should be able to do this, similar to sending form letters, only e-mail instead.

I can get everything set up and working, right up to the Merge dialog box, but all I have to select for Merge To, is 'New Document,' or 'Printer.' According to the WORD 2000 help files, there should be an option called 'Electronic Mail.' There is not, and I don't know why. I am apparently missing something, but I can't figure it out.

Any help or ideas will be appreciated. Any thoughts as to what else I may run into--difficulty wise--would be appreciated also.

Thank you.

Clayton
 

A:WORD 2000, e-mail merge, missing 'Electronic Mail'

Read other 9 answers
RELEVANCY SCORE 73.2

I would like to use Word 2007 Mail Merge to compose and send email messages. My email client is Windows Live Mail. I do not have Outlook. I do not need to access my WLM Contacts list. The email addresses I want to send messages to are in a column of the Word table that I am using as the Mail Merge data source. I have gone through all of the steps of a Mail Merge, including writing the email message, inserting data fields into it, and selecting recipients. The last step is to finish, merge, and send messages. I click on that step and nothing happens - no error message appears but no messages are sent. Any advice? It's possible this can't be done, but I am hoping it can.

--Jim--

Read other answers
RELEVANCY SCORE 73.2

I'm using Word 2010 on a Win 7 machine. I'm having problems with mail merge in that when the merge is complete and I click on "OK" once the mail dialog has been completed, nothing happens. My e-mail client does not open up, nor do I see any messages in the outbox. This used to work just fine with Windows Live Mail and Word 2007. I then installed Word 2010 and it does not work now. Any suggestions from anybody? Any assistance would be MUCH appreciated. Microsoft is no help - impossible to contact.
 

A:Solved: Word 2010 e-mail Mail Merge Problem

Word and Outlook have to be same version.
 

Read other 1 answers
RELEVANCY SCORE 72.8

I have email addresses stored for a Windows Mail Merge docx. and now want to use the email addresses for each entry.How can this email data be exported for use in Windows Live Mail as a Folder in my 'Contacts'?All assistance gratefully accepted in advance. Many thanks
Using OS: 64 bit MS7
 

A:Word Mail Merge emails to Live Mail

Read other 13 answers
RELEVANCY SCORE 70.8

I'm having some trouble printing a mail merge document from Word 97. Here are the details:

1. The document is formatted such that 3 form letters can fit on a single 8.5X11 piece of paper (each form letter is 3.6 inches tall, thus I want to print three on a single sheet of paper and will later cut it into thirds).

2. Each form letter has text and a graphic common to each letter (thus a "form" letter) and fields of unique data imported using the Mail Merge option on the TOOLS menu.

I am able to get the merge to occur, however it results with a single form letter per page, hence two-thirds of each printed page is wasted space. If I delete the page-break that appears on each page, I am able to get all three form letters on a single page, however I end up losing some of the formatting graphics.

Can anyone offer some suggestions of how to proceed?

Thanks
 

A:Using Mail Merge in Word

You must have the *doc* set up 3 times on the sheet. On the first you will have your first merge field.

On the 2nd, in FRONT of the first merge field, you must have a Word field "next record"

On the 3rd, same thing...

Suggestion: Right-click, Format picture and set text wrapping to INLINE WITH TEXT.

Hope this helps. If not, email data (change names if you like, and I only need four or five records) and merge doc as is to:

[email protected]
 

Read other 3 answers
RELEVANCY SCORE 70.8

Hey Guys,

I have an end user who is needing to set up word 2007 mail merge. She is drawing her list of recipients from our SQL server database. She is needing to place up to nine names into a 3x3 table, with one name per cell. Our problem is that some of the schools she is doing this for don't have nine people. So not all nine cells are filled. Now the problem this causes is that when one page doesn't fill all of the cells word starts grabbing names that are supposed to be on the next page (school) and using them to fill the partially filled chart. This is a huge problem because each page is a different school with different Board members. So I need to figure out a way to separate the charts so that each page's chart is filled according to the School name that is pulled from the database. She is currently having to do a separate merge for each school, we have 56 different schools. And it is an extreme hassle for her. If you have any suggestions please let me know. Also if you need me to clarify anything, please send me a message.

Thanks
 

A:Mail Merge in word 07

Name Name Name
Name Name Name
Name Name Name

It's going to look similar to that, but there is going to be a chart surrounding it. and each Name is a different board member. however some schools dont have 9 board members, and word is currently pulling the names from the next school on the list in order to fill all 9 cells. How do i Prevent it for doing this without having to do a new mail merge for each school?
 

Read other 2 answers
RELEVANCY SCORE 70.8

I develop an application that does mail merges with Word. It runs fine on Win2K and XP and with Office 97 up to 2003.

I am now running on Vista Business and Office 2K7. when I do a mail merge, I sometimes get an extra window like this:

Sometimes I can't even close this extra window. Any help appreciated!
 

A:Word 2K7 mail merge

Read other 8 answers
RELEVANCY SCORE 70.8

I am currently using an older printer to merge 3.5" x 8.5" card stock from a FoxPro database. The older printer has a swinging door style manual feed and that's how I print the merge. I am interested in buying a newer printer, but most of them have small manual feed slots which only take one card at a time. I tried resizing the tray and changing the default paper source in Word and the printer settings, but the printer still wants the card from manual feed. Am I missing something? Thanks.
 

A:MS Word Mail Merge

swaters said:

I am currently using an older printer to merge 3.5" x 8.5" card stock from a FoxPro database. The older printer has a swinging door style manual feed and that's how I print the merge. I am interested in buying a newer printer, but most of them have small manual feed slots which only take one card at a time. I tried resizing the tray and changing the default paper source in Word and the printer settings, but the printer still wants the card from manual feed. Am I missing something? Thanks.Click to expand...

Just a little thing:
When creating mail merge, MSWord automatically puts option "Manual" in "Tray" (Don't ask me why!); change it to "Default Tray (Auto Select)". Only withdraw is that You'll have to create new main merge document.
 

Read other 1 answers
RELEVANCY SCORE 70.8

i am trying to do a mail merge using the data in excel; i have done mail merge before and never had any problem until today ; but it's an odd problem tho; for some reason, word doesnt read the column for job title, and when i try to play around with the fields, it gives unpredictable and not logical result; i never had this problem before and dont know if anyone else has the same experience

the format should be

full name
job title
company
address 1, address 2
city, state zip

and for some reason it wouldnt pickup the job title field data, and when i try to put 2 job title fields , it omits the full name!!!,etc.... very weird
 

A:please help with mail merge in word

Read other 6 answers
RELEVANCY SCORE 70.8

I want to use a spreadsheet for the records in the merge. I would like to use one of the columns to specify how many times that particular record should be printed. Is that possible?

I also want a number on each document that auto-increments each time that document is printed.
 

Read other answers
RELEVANCY SCORE 70.8

Hi,

I would like to set up a word mail merge the following:

If field OPTION1, OPTION2 and OPTION3 are al three empty, I would like to show the text "no options available" in any other case I would like to display these options.

I was thinking it would be something like this.
{IF<<OPTION1>>AND<<OPTION2>>AND<<OPTION3>>="" "No options available" <<OPTION1>><<OPTION2>><<OPTION3>>}

Unfortunately that doesn't work.
The problem is likely the AND selector. I haven't found any documentation of how to use AND selection in Word.

Any ideas? Help would be greatly appreciated.
 

A:Word Mail Merge with IF and AND

Read other 6 answers
RELEVANCY SCORE 70.8

What is the quickest way to create a mail merge in Word 97.
 

A:Word 97 Mail Merge

Some pointers:

I personally prefer using Excel as my data source (get data, change files of type to Excel). The mail merge helper will actually use a Word table as the data source (create data source) if you follow through the steps.

Regardless, your column headings in the data source need to be in row 1 and the first record of data must be in row 2.

Follow the steps in the mail merge helper. Generally, you'll use "active document" when prompted, except when performing the actual merge--use new document.

When you've put the codes into the letter, labels, etc., I suggest testing it (use the <<abc>> button on the mail merge toolbar), and then saving it as a template. Close it, hit file-new whenever you want to use that merged letter, label, etc.

Recognize that you're creating two files. The data source (put "data" into the name somewhere) and the coded file (put "merge" in the name somewhere).

Check here, if you can. 2000 and 97 are virtually the same when it comes to mail merge: http://support.microsoft.com/servicedesks/Webcasts/WC110200/wcblurb110200.asp?

Let me know if you run into problems or need more help.
 

Read other 2 answers
RELEVANCY SCORE 70

I have a list of records that will be merged from either an Excel worksheet or an Access database. The ID Number field repeats for multiple records but I would like the merged document to show the ID field once but list all records with that ID as on the same document page(s). When the ID number changes, then the next group of records are merged under that ID. Can this be done?
 

A:Mail Merge in Word 2003

No.
Sorry, but this is a huge shortcoming of Word.
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg
 

Read other 1 answers
RELEVANCY SCORE 70

Hi,

I have an access db that has .bmp files linked by SIS ID. I would like to merge the .bmp into a mail merge with Word 07.

I have never successfully been able to do this but thought I would try again. I have the word doc setup with a text box that I want the pic to merge into.

The SIS ID always shows up but not the .bmp.

Any ideas?

Thanks so much!
 

A:Access DB with .bmp/Mail Merge to Word 07

Can you post a copy of the Word Doc and a Bmp file?
I have never used mail merge in word, but I could try using VBA to do it.
 

Read other 1 answers
RELEVANCY SCORE 70

I'm trying to build a database to use just the labels option of the "mail merge" feature of WORD.
However, in my home edition of XP, I don't have excel. So, to create a database of companies, addresses and towns I was going to use a WORD table to become my database for mail merge to "draw" from.
When I went to create mailing labels from this document (a WORD table) I got an error message that says Microsoft Works does not recognize this database.

Also, I tried to enter each address singly to create a single label, when I went to adjust the column and row it would not let me, hence creating typed text over and over on the same mailing label(?). Help?

Can someone advise me on how to create approx. 300 different mailing labels.

Thank you very much,
 

A:Word/Mail merge/Windows XP

"Microsoft Works"??

What are you really using? Word or WORKS?

Use the TAB key to get to the next table cell in labels in Word, but not sure how to help if it turns out you're using Works.

Anyway, to answer your last question, let me know exactly what program we're running here and what version. See Help-About...
 

Read other 2 answers
RELEVANCY SCORE 70

I work for a management company, so we use Office 2003 (Basic Edition) for a whole bunch of stuff. My question has to do with the Mail Merge option in MS Word. I type all the leases for my company, so being able to use the Mail Merge would be awesome. I am not very computer literate, and was wondering if anyone knows a good site for a tutorial, or if they know how to use the Mail Merge option. Any help would be greatly appreciated. Thanks a lot.

A:Help With Word 2003 Mail Merge

Check the Microsoft Office website: Use mail merge for mass mailings and more.

Read other 1 answers
RELEVANCY SCORE 70

Using Windows 98, trying to do Excel to Word mail merge.
Workbook name
Main.xls
Worksheet names:
Board
CLEC_Affliates
ISP_Affliates
MCC

I have named cell ranges on each of the sheets, and would like to use that information selectively for a variety of mail merges in Word. When doing the merge though, my only choice for Data source, is entire spreadsheet...and my "named" ranges do not show up? Any advice...named ranges are named in following manner:
Board='Board'!$A1!Bx17 etc
Any help would be appreciated, please cc the email to
[email protected] as I will be working on this tonite at home too.
Thanks
Victoria
 

A:Excel/Word Mail Merge

Dear TSGF: No one ever answered my post, so I assume, as is always dangerous, that no one knew the answer. However, I figured it out even though it is not intuitively obvious from the MS standpoint! Here's the answer to my own question"

If you do not have Excel ODBC Drivers, Please install them in this way :

1) Click on Start --> Settings --> Control Panel

2) Select 'Data Sources (ODBC)' and press Enter key.

3) Goto 'System DSN' tab (3rd tab out of 7 tabs) in the "ODBC Data Source Administrator" dialog box.

4) Click on ADD.

5) Select 'Driver do Microsoft Excel (*.xls)' from select driver list box.

6) Click on Finish

Now you will see 'ODBC Microsoft Excel Setup' dialog box.

7) Type a name in 'Data Source Name' and click OK.

Now, Microsoft Excel ODBC Drivers are installed onto your system.

NOTE : You must install Excel ODBC Drivers prior to using mail merge facility.The Microsoft Excel ODBC driver must already be installed.

NOTE: In the Select Table dialog box, you will see all the tables in the workbook, not just the ones from the first sheet.

To connect to Excel using ODBC, follow these steps:

1) From the Get Data list, click Open Data Source.

2) Locate and select the Microsoft Excel file. In the Open Data Source dialog box, make sure that the Select Method check box is selected.

3) Click Open.

4) In the Confirm Data source dialog box, select "Excel Files via ODBC (*.xls)... Read more

Read other 1 answers
RELEVANCY SCORE 70

Been having a problem with editing the recipient list in mail merge. When I go to save the edited list, I get one of two errors- a "read only" error if saving to a network drive, or a "insufficient permission" if saving to a local drive.

I've been able to duplicate this problem on multiple machines, with multiple files in both the .doc and docx. format. The data files are tables in Word, I have not tried duplicating the issue with Excel or Access datasources.

Of course, I have made sure the data files are not actually read only...

Thanks,

Michael
 

Read other answers