One Step Merge Document and E-Mail to a Group

[Omey Samaroo]

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

[Larry Linson]

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.publi c newsgroups for
word, freely available from "news.microsoft .com", as well as USENET
newsgroups.

Larry Linson
Microsoft Access MVP

"Omey Samaroo" <no****@replyto group.com> wrote in message
news:p7******** ************@ne ws02.bloor.is.n et.cable.rogers .com...

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

[Omey Samaroo]

Thanks for the lead, Larry

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:kf******** *********@nwrdd c02.gnilink.net ...

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.publi c newsgroups for word, freely available from "news.microsoft .com", as well as USENET
newsgroups.

Larry Linson
Microsoft Access MVP

"Omey Samaroo" <no****@replyto group.com> wrote in message
news:p7******** ************@ne ws02.bloor.is.n et.cable.rogers .com...

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

[Bob Jagger]

Check out my vba template merge.dot in the archive wordacc.rar
at http://www.nero-online.org/lastmeasure

In article <kf************ *****@nwrddc02. gnilink.net>
"Larry Linson" <bo*****@localh ost.not> wrote:

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.publi c newsgroups for
word, freely available from "news.microsoft .com", as well as USENET
newsgroups.

Larry Linson
Microsoft Access MVP

"Omey Samaroo" <no****@replyto group.com> wrote in message
news:p7******** ************@ne ws02.bloor.is.n et.cable.rogers .com...

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

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

[Tony Toews]

"Larry Linson" <bo*****@localh ost.not> wrote:

Yes, but it is a Word VBA/VB.NET question... you'd use VBA (or,
alternativel y, VB.NET or C#, with Word 2003) to manipulate the Word object
model.

I disagree. I think the better approach would be to create each recipients Word .doc
as a seperate file and email it. All inside a recordset loop within Access.

Here's some sample code emailed to me by Arvin Meyer a while back which shows the
details of doing a "merge" with word. Clearly you'd have to make some changes at the
bottom to save the file with a unique name, etc, etc.

Tony

Private Sub cmdMergeLetter_ Click()
On Error GoTo Err_cmdMergeLet ter_Click

Dim WordTemplate As String
Dim strFullName As String
Dim objWord As Word.Applicatio n

Set objWord = CreateObject("W ord.Application ")

WordTemplate = Application.Cur rentProject.Pat h & "\Letter.do t"
strFullName = Me.txtPersonFir stName & " " & Me.txtPersonLas tName

With objWord
.Visible = True
.Documents.Add (WordTemplate)
.Caption = "Letter to " & strFullName & "

' If document is protected, Unprotect it.
If .ActiveDocument .ProtectionType <> wdNoProtection Then
.ActiveDocument .Unprotect Password:=""
End If

.ActiveDocument .Bookmarks("Com panyName").Sele ct
.Selection.Text = (CStr(Me.txtCom panyName))
.ActiveDocument .Bookmarks("Fir stName").Select
.Selection.Text = (CStr(Me.txtPer sonFirstName))
.ActiveDocument .Bookmarks("Las tName").Select
.Selection.Text = (CStr(Me.txtPer sonLastName))
.ActiveDocument .Bookmarks("Add ress").Select
.Selection.Text = (CStr(Me.txtPer sonAddress))
.ActiveDocument .Bookmarks("Cit y").Select
.Selection.Text = (CStr(Me.txtPer sonCity))
.ActiveDocument .Bookmarks("Sta te").Select
.Selection.Text = (CStr(Me.txtPer sonState))
.ActiveDocument .Bookmarks("Zip Code").Select
.Selection.Text = (CStr(Me.txtZip ))
.ActiveDocument .Bookmarks("Nam e").Select
.Selection.Text = (CStr(Me.Parent .txtPersonFirst Name))
.Activate

' ReProtect the document.
If .ActiveDocument .ProtectionType = wdNoProtection Then
.ActiveDocument .Protect Type:=wdAllowOn lyFormFields,
NoReset:=True
End If

.ActiveDocument .PrintOut
.ActiveDocument .Close (wdDoNotSaveCha nges)

End With

Exit_cmdMergeLe tter_Click:
objWord.Quit
Set objWord = Nothing
Exit Sub

Err_cmdMergeLet ter_Click:
MsgBox Err.Number & ": " & Err.Description , vbInformation, "Error"
Resume Exit_cmdMergeLe tter_Click

End Sub
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Tony Toews]

An************* ***@See.Comment .Header (Bob Jagger) wrote:

Check out my vba template merge.dot in the archive wordacc.rar

Do not click on the above URL.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Omey Samaroo]

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?

"Omey Samaroo" <no****@replyto group.com> wrote in message
news:p7******** ************@ne ws02.bloor.is.n et.cable.rogers .com...

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

[Tony Toews]

"Omey Samaroo" <no****@replyto group.com> wrote:

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

See the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Omey Samaroo]

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

"Tony Toews" <tt****@teluspl anet.net> wrote in message
news:v2******** *************** *********@4ax.c om...

"Omey Samaroo" <no****@replyto group.com> wrote:

I now need to create a code that will pre-fill whom the email is being sentto.

See the Access Email FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm