[mso] Re: Word
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 17 Jun 2003 12:56:23 -0500
Well...if you mean that you've connected from Word to the DB via VBA, =
using
ADO...then you have to create a RecordSet of the groups...add in =
whatever
variables you require for each item, such as "get all contacts in
Illinois"...then, maybe use the name or an account number to enter in =
stuff
like "if name =3D Joe Blow, then do this...if name =3D Mary Smith, then =
do
that". This would all be worked into the VBA code. Once all the =
variables
are set, you would use EOF (end of file) to create a loop to say...Do =
Until
EOF (do a letter for each person in the RecordSet, adjusted to the =
following
variables, until you run out of names in the RecordSet.)
You'd obviously also want to add in Save letter with name, etc.
However, if you have a lot of name and lots of variables, this isn't the
most efficient way to do this. I'm sure there's a better way to do it =
via
direct Mail Merge by creating some SQL query or calling groups of names =
from
some field...such as numbering them for Letter 1, 2, 3, etc...with
personalized variables????
But sorry...I don't do mail merge that much, so I don't know the quick
answers to this one and don't currently have the time to spend =
researching
how it would work.
Sorry! Good luck!=20
Dian Chapman
Technical Consultant
& Microsoft MVP
Free Word Tips & Tricks eBook: http://www.mousetrax.com/books.html
Free Tutorial site: http://www.mousetrax.com/techpage.html
Free Support Ezine: http://www.mousetrax.com/techtrax/
=20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of Glenda Wells
Sent: Monday, June 16, 2003 2:46 PM
To: mso@xxxxxxxxxxxxx
Hi Dian.
I had already looked through your stuff but don't see quite what I'm =
looking
for. The document isn't a form as much as it is a letter.
The document is in Word. I've connected to a data source and can merge =
the
name and address information no problem.
Where I'm stuck now is trying to get the list of forms and their various
values. Some persons will have 2 forms, some 4, some 20. =3D20
the DB for this piece looks like this and this is what I want in my Word
doc.
Form Name Value 1 Value 2 Value 3
Log Form 2700 1325
900
Purchase Form 1100 902 1271
CHOP Form 2200 1500
1700
How do I do the next record thing? =3D20
/g
-----Original Message-----
From: Dian Chapman [mailto:dian@xxxxxxxxxxxxx]=3D20
Sent: Monday, June 16, 2003 3:30 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Word
Yes, that's how I would do it and I'd love to help, Glenda. But I'm =
=3D3D
guessing you want to do it FROM Access to Word and I've never done it =
that
way =3D3D and don't know Access VBA enough to know how to do it that =
way.
The way *I* would do it is simple for me...I would create a form in Word
with the VBA code I needed for whatever the "variables" are in the =3D3D
letter. Then I would connect to the DB via Word and ADO (Access Data
Object)...create a record set from the info I needed and then write some =
=3D3D
VBA that would decipher the variable in the fields I needed and run =3D =
a case
statement for whatever the answer would be.=3D3D20
So say I pull all the records with people who live in the City =3D3D
"chicago." I could then say, okay from this RecordSet, if the field =
"order"
says =3D3D "yes" then pull that record and write the letter THIS way. If =
the
field =3D3D "order" says no, write the letter this way. Or =3D yes, I =
could
include other =3D3D variables that pull the name and other fields and =
set up
the letter with fields to come out very customized.
I have a sample/demo on my web site for ADO. You can go to
www.mousetrax.com/techpage.html#autoforms and you'll find a series I did
called "Please fill out this form." The series takes a Word form newbie =
=3D3D
from start to DB connectivity. Lesson 5 is the DB article and has a =3D =
=3D3D
downloadable demo that contains a sample form connected to a sample DB =
that
you can =3D3D see how you can check the DB via the Word form by clicking =
an
ActiveX =3D3D control. Then you can fill out the form from the DB or =
fill out
the form first =3D3D and pass the new info back to the DB.
The VBA code is open in the Word form, =3D3D so you can see how to use =
ADO to
connect and use SQL to pull a RecordSet =3D3D and use VBA to fill out =
=3D the
form via form field bookmarks.
And if you want MORE to learn how to use Word forms/VBA better...my Word
AutoForms & VBA course is available at www.mousetrax.com/books.html.
Good luck!
Dian Chapman
Technical Consultant
& Microsoft MVP
Free Word Tips & Tricks eBook: http://www.mousetrax.com/books.html
Free Tutorial site: http://www.mousetrax.com/techpage.html
Free Support Ezine: http://www.mousetrax.com/techtrax/
=3D3D20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
=3D3D
Behalf Of Glenda Wells
Sent: Monday, June 16, 2003 9:51 AM
To: mso@xxxxxxxxxxxxx
Hi Word Gurus.
=3D3D20
I want to create a mail merge letter that pulls some data from an Access
database. Based on the value of that data, I'd like to change some of =
=3D =3D3D
the paragraphs. I suspect Bookmarks and If Then statements are the =
answer
=3D3D but not having ever used them, need some guidance. =3D3D20 Any =
suggestions
welcome. /g =3D3D20 =3D3D20
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
=3D3D
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to =3D3D
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will =
=3D3D
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, =
=3D =3D3D
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
=3D =3D3D
invitation with instructions. Once you are a member of the files group, =
you
can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=3D20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will =
also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to =
mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will =
also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
