Google Answers Logo
View Question
 
Q: MS Database-Fax Merge ( No Answer,   3 Comments )
Question  
Subject: MS Database-Fax Merge
Category: Computers > Software
Asked by: steveb-ga
List Price: $5.00
Posted: 19 Jun 2002 10:25 PDT
Expires: 26 Jun 2002 10:25 PDT
Question ID: 29248
I want to use MS Word XP (2002) to mail/fax merge form documents
delivered via  Microsoft Fax Service XP.   I have a database (NOT
Outlook contacts) of subscribers names and fax numbers to whom I want
to send a form letter.

 Ie.   Via Fax: [FaxNumber]        Dear [Name]……  etc.

I have reviewed MSKB articles to no avail.

Thanks!
 Steve
Answer  
There is no answer at this time.

Comments  
Subject: Re: MS Database-Fax Merge
From: taratr98-ga on 19 Jun 2002 14:30 PDT
 
If the database is an Access database, the solution is not too
difficult.  A working knowledge of MS Query is useful, but if you have
none, now is the time to learn!  If the data is not an access
database, it gets more tricky, but it is still possible.  I'm going to
operate under the assumption you're using an Acess Database for now.

(I'm working with Word 2000, so your dialogs/etc may be slightly
different.)

Step 1: Prepare the seed document
In Word, start with a blank document.  Select Tools->Mail Merge. 
Under section (1), click "Create" and choose "Form Letter."  Use the
current document.  Now choose the "Edit" button which appeared, and
select your document.  Now create your letter as usual.  Use regular
names, numbers, etc. or descriptions such as "FIRST_NAME" "LAST_NAME",
so forth.  When this is prepared, you can move to step 2.

Step 2: Gather your mail merge data
Select Tools->Mail Merge.  Under part (2), choose Get Data and say
"Open Data Source."  Browse to where your Access Database is and open
it.  (You may need to change the drop-down file type box to "Access
Databases" to see your database in the file browser.)  A new window
will pop up, containing the names of all tables in your database. 
Select the table that has the data you need, and click "OK".  Word
will inform you that you have no merge fields in your document.  Click
the "Edit Main Document" button, and you'll be sent back to your form
letter.

Step 3: Insert the merge fields
Merge Fields are the data from each Database record that will replace
"FIRST_NAME", "LAST_NAME", etc. in your form letter.  Look for the
Mail Merge toolbar.  (If you can't find it, choose
View->Toolbars->Mail Merge to bring it up.)  Click the "Insert Merge
Field" button, and it will pop down with all the entries in the table
you selected from step 2.  You can now insert these fields at will
into your document in place of the "FIRST_NAME" fields you had before.
 You can insert the same data multiple times -- if you want the first
name to appear at the top and bottom, insert the same field in both
places.  (When mail merge fields are inserted they look like
"<<FirstName>>").  Do this for every place where you need to in your
form letter.

Step 4: MERGE!
Now, on the merge toolbar, click "Merge...".  Choose to merge to a new
document.  (At this point, you can even which records you want to
merge, and a couple more options.)  Then click "Merge."  You will now
have a brand-new single document containing all of your merged
letters.

Now, this procedure will work for more than just MS Access databases. 
If you can't open your database file directly, the best solution may
be to EXPORT it into a text file.  If this is what you have to do, I
can write a detailed description of how to do it.

Hope this helps!
Subject: Re: MS Database-Fax Merge
From: steveb-ga on 20 Jun 2002 07:26 PDT
 
Thanks for the input, I should have explained more clearly.
I got that far, however that doesn't automate the faxing.
That generates one giant document, where I need to generate 300 or so,
then fax them to the appropriate numbers automatically.

Thanks again!
Subject: Re: MS Database-Fax Merge
From: chicgeek-ga on 21 Jun 2002 14:27 PDT
 
I've used WinFax Pro 10 to automatically send faxes, and it works very
nicely.

When WinFax is installed, you can include Word macros with it (in
WinFax message manager, choose Tools, Macro Installer).

Then you set up a 'normal' word merge, with a query from your access
database as the datasource.  It should include the main body of your
fax.

Then, instead of running the merge and creating one huge document, you
choose Tools, WinFax Merge.  You fill in the required fields (ie: 
First name, last name, and fax number) and run the merge.  It will
automatically dial out and send each individual fax.  A report is made
in the WinFax message manager that will show any faxes that couldn't
be sent.

I'm not too sure about how Microsoft Fax Service works, but this is
one way to solve your problem, that I've had success with!  Hope it
helps.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy