I have an SQL database that is queried. I use these queries to mail merge in
word - with the output going to Outlook - so that each individual email is
sent to the individual for whom it's intended. The only problem is that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in message
...
I have an SQL database that is queried. I use these queries to mail merge
in
word - with the output going to Outlook - so that each individual email is
sent to the individual for whom it's intended. The only problem is that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

The article refers to a "clickyes" utility at express.com. I couldn't find
this utility at their site. Additionally, I see in another post on the same
subject matter that someone had problems after installing that utility. They,
like me are using Office 2003. Is the utility still available, and is it okay
to use/run with Office 2003 and the mail merge/email with attachments
process? Or will it mess up the process like described in "Email merge, how
do I work around the security feature?", posted by Jaloway.

"Doug Robbins" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in message
...
I have an SQL database that is queried. I use these queries to mail merge
in
word - with the output going to Outlook - so that each individual email is
sent to the individual for whom it's intended. The only problem is that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

Just tried to follow instructions you wrote "Mail Merge to E-mail with
Attachments.
I created the macro, but it was my first. I simply copied and pasted the
info from your articleinto the visual basic editor so as to avoid typos, then
added the macro to the tool bar. But I get following error message when I run
the macro:
Compile Error:
User-defined type not defined.
Then the macro editor is opened and the following is highlighted:
(The middle line is highlighted - I've included a line before and after to
identify)

Dim bStarted As Boolean

Dim oOutlookApp As Outlook.Application

Dim oItem As Outlook.MailItem
Since I've copied and pasted, I don't know how it is in the macro. I think
it may have been in the course of when and where to run the macro. I had no
trouble creating the directory merge, and then using it as the source for my
data in the email merge. But I have tried running this macro at every step in
the process of creating the email merge and I get the same error message. The
end resut is an email merge that does exactly as it should - but there is
only a reference to the attachment in the email - no real attachment.

"Doug Robbins" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in message
...
I have an SQL database that is queried. I use these queries to mail merge
in
word - with the output going to Outlook - so that each individual email is
sent to the individual for whom it's intended. The only problem is that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

The Express Click Yes is now available from
http://www.contextmagic.com/express-clickyes/

Almost certainly the error that you are getting is because you did not set
the reference to the Outlook Object Library as it mentions that you must do
in the Preparations part of the article.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Mmiller" wrote in message
...
Just tried to follow instructions you wrote "Mail Merge to E-mail with
Attachments.
I created the macro, but it was my first. I simply copied and pasted the
info from your articleinto the visual basic editor so as to avoid typos,
then
added the macro to the tool bar. But I get following error message when I
run
the macro:
Compile Error:
User-defined type not defined.
Then the macro editor is opened and the following is highlighted:
(The middle line is highlighted - I've included a line before and after to
identify)

Dim bStarted As Boolean

Dim oOutlookApp As Outlook.Application

Dim oItem As Outlook.MailItem
Since I've copied and pasted, I don't know how it is in the macro. I think
it may have been in the course of when and where to run the macro. I had
no
trouble creating the directory merge, and then using it as the source for
my
data in the email merge. But I have tried running this macro at every step
in
the process of creating the email merge and I get the same error message.
The
end resut is an email merge that does exactly as it should - but there is
only a reference to the attachment in the email - no real attachment.

"Doug Robbins" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in message
...
I have an SQL database that is queried. I use these queries to mail
merge
in
word - with the output going to Outlook - so that each individual email
is
sent to the individual for whom it's intended. The only problem is
that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

Thanks Doug.
Did that- but had the wrong one checked. Got that fixed and yes, the macro
performs without any error message. But the whole process is still not
working right.
If I hit the macro key before the very last step of merging the document
with electronic mail, then the resulting merge has none of the email message
I created in the body of the document. The body of the email is completely
blank. In addition to the field for the attachment, I also chose a name field
when creating/executing this mail merge. None of the manually created message
or the field information showed up. If I wait and hit the macro key after the
last step of merging to electronic mail, then the office program/merge
creates the emails as it would without the macro. The email has all the body
elements, but only a drive path, file name reference to the attachment. No
actual attachment. Hitting the macro after this step has a whole new set of
emails generated again, but they are like the first scenario -blank. Only the
address and subject line are carrying over. Can you identify what I've done
wrong or left out?
I'm trying hard! :-)

"Doug Robbins" wrote:

The Express Click Yes is now available from
http://www.contextmagic.com/express-clickyes/

Almost certainly the error that you are getting is because you did not set
the reference to the Outlook Object Library as it mentions that you must do
in the Preparations part of the article.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Mmiller" wrote in message
...
Just tried to follow instructions you wrote "Mail Merge to E-mail with
Attachments.
I created the macro, but it was my first. I simply copied and pasted the
info from your articleinto the visual basic editor so as to avoid typos,
then
added the macro to the tool bar. But I get following error message when I
run
the macro:
Compile Error:
User-defined type not defined.
Then the macro editor is opened and the following is highlighted:
(The middle line is highlighted - I've included a line before and after to
identify)

Dim bStarted As Boolean

Dim oOutlookApp As Outlook.Application

Dim oItem As Outlook.MailItem
Since I've copied and pasted, I don't know how it is in the macro. I think
it may have been in the course of when and where to run the macro. I had
no
trouble creating the directory merge, and then using it as the source for
my
data in the email merge. But I have tried running this macro at every step
in
the process of creating the email merge and I get the same error message.
The
end resut is an email merge that does exactly as it should - but there is
only a reference to the attachment in the email - no real attachment.

"Doug Robbins" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in message
...
I have an SQL database that is queried. I use these queries to mail
merge
in
word - with the output going to Outlook - so that each individual email
is
sent to the individual for whom it's intended. The only problem is
that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

Re-read the instructions. They say quite clearly that the merge must be
executed to a new document and they do not say anything amount merging to
electronic mail.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Mmiller" wrote in message
...
Thanks Doug.
Did that- but had the wrong one checked. Got that fixed and yes, the macro
performs without any error message. But the whole process is still not
working right.
If I hit the macro key before the very last step of merging the document
with electronic mail, then the resulting merge has none of the email
message
I created in the body of the document. The body of the email is completely
blank. In addition to the field for the attachment, I also chose a name
field
when creating/executing this mail merge. None of the manually created
message
or the field information showed up. If I wait and hit the macro key after
the
last step of merging to electronic mail, then the office program/merge
creates the emails as it would without the macro. The email has all the
body
elements, but only a drive path, file name reference to the attachment. No
actual attachment. Hitting the macro after this step has a whole new set
of
emails generated again, but they are like the first scenario -blank. Only
the
address and subject line are carrying over. Can you identify what I've
done
wrong or left out?
I'm trying hard! :-)

"Doug Robbins" wrote:

The Express Click Yes is now available from
http://www.contextmagic.com/express-clickyes/

Almost certainly the error that you are getting is because you did not
set
the reference to the Outlook Object Library as it mentions that you must
do
in the Preparations part of the article.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Mmiller" wrote in message
...
Just tried to follow instructions you wrote "Mail Merge to E-mail with
Attachments.
I created the macro, but it was my first. I simply copied and pasted
the
info from your articleinto the visual basic editor so as to avoid
typos,
then
added the macro to the tool bar. But I get following error message when
I
run
the macro:
Compile Error:
User-defined type not defined.
Then the macro editor is opened and the following is highlighted:
(The middle line is highlighted - I've included a line before and after
to
identify)

Dim bStarted As Boolean

Dim oOutlookApp As Outlook.Application

Dim oItem As Outlook.MailItem
Since I've copied and pasted, I don't know how it is in the macro. I
think
it may have been in the course of when and where to run the macro. I
had
no
trouble creating the directory merge, and then using it as the source
for
my
data in the email merge. But I have tried running this macro at every
step
in
the process of creating the email merge and I get the same error
message.
The
end resut is an email merge that does exactly as it should - but there
is
only a reference to the attachment in the email - no real attachment.

"Doug Robbins" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in
message
...
I have an SQL database that is queried. I use these queries to mail
merge
in
word - with the output going to Outlook - so that each individual
email
is
sent to the individual for whom it's intended. The only problem is
that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

[Bradley Elder]

Hey Doug!

Is there a way to do this in 2007?

"Doug Robbins" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in message
...
I have an SQL database that is queried. I use these queries to mail merge
in
word - with the output going to Outlook - so that each individual email is
sent to the individual for whom it's intended. The only problem is that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???

[Peter Jamieson]

What happens differently in 2007?

As far as I know, there is no new facility in Word 2007 that will do it for
you.

Peter Jamieson

"Bradley Elder" wrote in message
...
Hey Doug!

Is there a way to do this in 2007?

"Doug Robbins" wrote:

See the article "Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Lily@Insight" wrote in message
...
I have an SQL database that is queried. I use these queries to mail
merge
in
word - with the output going to Outlook - so that each individual email
is
sent to the individual for whom it's intended. The only problem is
that I
want to also include a PDF attachment.

Is this at all possible? Or am I dreaming???