One Step Merge Document and E-Mail to a Group

One Step Merge Document and E-Mail to a Group

Post by Omey Samar » Tue, 16 Dec 2003 08:12:21


Dear Access Gurus,

What I would like to do is create a word document that merges some fields in
a query. The next step is to have the document e-mailed to a group of users.
What I have done so far is create the query and merged the document. All I
need to do is press the merge button while in the word document and it is
done. I would like to create a button that opens the specific word
document,and merge it in one step and e-mail it to a group of users in the
next step.

Is this possible ...?
Any suggestions/ideas that I can experiment with ?

Omey
 
 
 

One Step Merge Document and E-Mail to a Group

Post by Larry Lin » Tue, 16 Dec 2003 08:20:48

Yes, but it is a Word VBA/VB.NET question... you'd use VBA (or,
alternatively, VB.NET or C#, with Word 2003) to manipulate the Word object
model. Perhaps someone here may have an answer, but that would only be by
chance. You'd stand a better chance of getting your answer in a newsgroup
devoted to Microsoft Word. There are several microsoft.public newsgroups for
word, freely available from "news.microsoft.com", as well as USENET
newsgroups.

Larry Linson
Microsoft Access MVP



in
users.

 
 
 

One Step Merge Document and E-Mail to a Group

Post by Omey Samar » Tue, 16 Dec 2003 08:23:46

Thanks for the lead, Larry



for


fields
I
is
the
 
 
 

One Step Merge Document and E-Mail to a Group

Post by Anonymous- » Tue, 16 Dec 2003 09:37:51

Check out my vba template merge.dot in the archive wordacc.rar
at http://www.yqcomputer.com/



In article <kf6Db.10503$ XXXX@XXXXX.COM >




-=-
This message was posted via two or more anonymous remailing services.
 
 
 

One Step Merge Document and E-Mail to a Group

Post by Omey Samar » Sat, 20 Dec 2003 10:10:41

Okay, this is what worked for me in case anyone finds it helpful :
(1)Created the word document
(2) Merged the fields in Access
(3) Created a macro in Word that merges, saves and then e-mails the document
(4) Saved the Macro as AutoOpen
(5)Created a shortcut of the word document, and changed the properties to
open the specific document (Properties > Target)
(6)Created a Macro - RunApp and copied and placed the target line from the
shortcut of the document file.
(7)Created a button that opens the Access Macro, which does all that I need,
package the file, save it and email the document.

I now need to create a code that will pre-fill whom the email is being sent
to.
Any ideas anyone?



in
users.
 
 
 

One Step Merge Document and E-Mail to a Group

Post by Omey Samar » Mon, 22 Dec 2003 04:06:37

Thank you Tony. I will bookmark your site as there seems to be some
"goodies" there.
I will repost if I need further help.
Cheers and "Happy Holidays"

Omey




sent