I am trying to send out a mass email from a spreadsheet and want to do a few
things.

I need to be able to add attachments and I also want to put together a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can email it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured out how to
add a hyperlink to add my .pdf brochure, but what I want to do is add an
attachment that is customized to there information. Any help on this would
be great. Thanks

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
"Gregg Ross" Gregg wrote in message
...
I am trying to send out a mass email from a spreadsheet and want to do a
few
things.

I need to be able to add attachments and I also want to put together a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can email it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured out how
to
add a hyperlink to add my .pdf brochure, but what I want to do is add an
attachment that is customized to there information. Any help on this
would
be great. Thanks

Doug, I appreciate your response. I already attempted to view that file and
I got confused as soon as I tried to create a Directory Merge as I didn't see
how to add an attachment there nor did I see a table being created. So I am
confused, is there anything you could help me with so I can understand better
on how to accomplish this.
"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
"Gregg Ross" Gregg wrote in message
...
I am trying to send out a mass email from a spreadsheet and want to do a
few
things.

I need to be able to add attachments and I also want to put together a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can email it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured out how
to
add a hyperlink to add my .pdf brochure, but what I want to do is add an
attachment that is customized to there information. Any help on this
would
be great. Thanks

You need to read the article very carefully and follow each step exactly.
If there is a separate attachment for each record, then the filenames of
those attachments need to be in a field in the datasource.

There are examples of how you need to setup the Directory mailmerge main
document and the result that you should get when you execute that merge in
the Setup portion 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
"Gregg Ross" wrote in message
...
Doug, I appreciate your response. I already attempted to view that file
and
I got confused as soon as I tried to create a Directory Merge as I didn't
see
how to add an attachment there nor did I see a table being created. So I
am
confused, is there anything you could help me with so I can understand
better
on how to accomplish this.
"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
"Gregg Ross" Gregg wrote in message
...
I am trying to send out a mass email from a spreadsheet and want to do a
few
things.

I need to be able to add attachments and I also want to put together a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can email
it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured out
how
to
add a hyperlink to add my .pdf brochure, but what I want to do is add
an
attachment that is customized to there information. Any help on this
would
be great. Thanks

Dear Doug, I had used your VBA code, but one problem I am facing is that
only attachemnt is been forward and not the content, I want to send the
attachements with the content (body text), can u pls tell me where I am
wrong ?

Doug Robbins Wrote:
You need to read the article very carefully and follow each step
exactly.
If there is a separate attachment for each record, then the filenames
of
those attachments need to be in a field in the datasource.

There are examples of how you need to setup the Directory mailmerge
main
document and the result that you should get when you execute that merge
in
the Setup portion 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
"Gregg Ross" wrote in message
...
Doug, I appreciate your response. I already attempted to view that
file
and
I got confused as soon as I tried to create a Directory Merge as I
didn't
see
how to add an attachment there nor did I see a table being created.
So I
am
confused, is there anything you could help me with so I can
understand
better
on how to accomplish this.
"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
"Gregg Ross" Gregg wrote in message
...
I am trying to send out a mass email from a spreadsheet and want to do
a
few
things.

I need to be able to add attachments and I also want to put together
a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can
email
it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured
out
how
to
add a hyperlink to add my .pdf brochure, but what I want to do is
add
an
attachment that is customized to there information. Any help on
this
would
be great. Thanks





--
SUNTEJ

I would like to discuss paid services with you. email me


"Doug Robbins" wrote:

You need to read the article very carefully and follow each step exactly.
If there is a separate attachment for each record, then the filenames of
those attachments need to be in a field in the datasource.

There are examples of how you need to setup the Directory mailmerge main
document and the result that you should get when you execute that merge in
the Setup portion 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
"Gregg Ross" wrote in message
...
Doug, I appreciate your response. I already attempted to view that file
and
I got confused as soon as I tried to create a Directory Merge as I didn't
see
how to add an attachment there nor did I see a table being created. So I
am
confused, is there anything you could help me with so I can understand
better
on how to accomplish this.
"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
"Gregg Ross" Gregg wrote in message
...
I am trying to send out a mass email from a spreadsheet and want to do a
few
things.

I need to be able to add attachments and I also want to put together a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can email
it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured out
how
to
add a hyperlink to add my .pdf brochure, but what I want to do is add
an
attachment that is customized to there information. Any help on this
would
be great. Thanks

You need to execute to a new document the mail merge that you want to be
contained in the body of the email and with the result of the execution of
that mail merge on the screen, run the macro.

--
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

"SUNTEJ" wrote in message
...

Dear Doug, I had used your VBA code, but one problem I am facing is that
only attachemnt is been forward and not the content, I want to send the
attachements with the content (body text), can u pls tell me where I am
wrong ?

Doug Robbins Wrote:
You need to read the article very carefully and follow each step
exactly.
If there is a separate attachment for each record, then the filenames
of
those attachments need to be in a field in the datasource.

There are examples of how you need to setup the Directory mailmerge
main
document and the result that you should get when you execute that merge
in
the Setup portion 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
"Gregg Ross" wrote in message
...
Doug, I appreciate your response. I already attempted to view that
file
and
I got confused as soon as I tried to create a Directory Merge as I
didn't
see
how to add an attachment there nor did I see a table being created.
So I
am
confused, is there anything you could help me with so I can
understand
better
on how to accomplish this.
"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
"Gregg Ross" Gregg wrote in message
...
I am trying to send out a mass email from a spreadsheet and want to do
a
few
things.

I need to be able to add attachments and I also want to put together
a
"Response Form" in which they click on the form in the email and it
automatically inserts there info into certain fields and they can
email
it
back and if they can't email it back then they can fax it.

I am already able to do a mass email merge and I recently figured
out
how
to
add a hyperlink to add my .pdf brochure, but what I want to do is
add
an
attachment that is customized to there information. Any help on
this
would
be great. Thanks





--
SUNTEJ