A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to insert pdf attachment with word email merge?



 
 
Thread Tools Display Modes
  #11  
Old April 2nd, 2008, 09:29 AM posted to microsoft.public.word.mailmerge.fields
Abdul[_2_]
external usenet poster
 
Posts: 22
Default How to insert pdf attachment with word email merge?

Thanks for your immediate response, I have followed your steps that you have
mentioned, but still not it's the same thing happening, could you please
explain in a simple steps? I am very new to macros.

-Abdul

"Doug Robbins - Word MVP" wrote:

This is the step that you missed:

"Then execute to a new document the mail merge that you want to send out by
email with the attachments and with the result of execution of that mail
merge on the screen, run a macro containing the following code."

The document that you created in your step 3 must be a mail merge main
document that has attached to it the same data source as you used to create
xyz.doc. You must then execute the merge of the step 3 document to a new
document. There is no need to save this document, but it must be the active
document when you 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

"Abdul" wrote in message
...
Let me explain what i did
1) I have created a seperate directory in a word document according to
your
instruction. I can see the result in the other page that shows all the
email
addresses and attachement path in the table and saved with a name
(xyz.doc),
2) I closed the file (xyz.doc).
3) Opened a new document file and typed with a message to send, also i
have
inlcuded your macro in this new document, when I try to run your macro, it
asked me a file to execute, i have choosen xyz.doc, then it prompted me to
enter a subject, i entered a subject and pressed OK, it had sent email
with
my outlook.
4) when opened a mail that i have sent, the first mail that contain
Message
with attachment, but the other all emails that contains only attachment
without Message.

Please tell me which step i missed out.

- Abdul

"Doug Robbins - Word MVP" wrote:

You are not running the macro when a document created by executing the
merge
that contains the message that is to be in the body of the emails to a
new
document is the active document.

Please read the instructions again and follow them exactly.

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

"Abdul" wrote in message
...
Hi

Your mail merge method works fine with attachemnt, but there is a
problem
in
body of the message, when you sent to 5 email IDs, the first person
only
get
the message in the body, but others can received only attachment
without
text
in their body of the email, can you please tell me how to do it?

Abdul

"Doug Robbins - Word MVP" wrote:

See response in your new thread.

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

"LyndieBee" wrote in message
...
I'm using the MergeWithAttachments procedure and followed all the
steps.
I
think I'm ALMOST there but am having a problem. (Microsoft Outlook
11.0
Object Library IS marked.) I'm using Office 2003, I've made and
saved
the
directory-type file with the email addresses and document name, I've
created
the letter-type merge with the appropriate info and fields. When I
run
the
macro, however, things go on and on and on!!! The 3 address that
I'm
expecting to see come by and I answer Yes to sending them (I'm doing
this
manually since there are only 3 in my test file.) But then it keeps
going
with Document 4, Document 5, Document 6, etc. I finally Ctrl+Break
to
get
the process to stop and get a macro error message. When I choose
debug,
this
is the part of the macro that is pointed to:

End With
Set oItem = Nothing
ActiveDocument.Close wdDoNotSaveChanges
Counter = Counter + 1
Wend

I copied and pasted from the article but have looked it over as well
to
be
sure I picked up everything. Any ideas?
-Lyndie

"Doug Robbins - Word MVP" wrote:

The procedure must be followed exactly for the process to be
successful
and
putting the code in a zip file would have no benefit.

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

"Søren Dalhoff" wrote in
message
...
Looking at the past of how many times the same answer has been
provided
http://..../MergeWithAttachments.htm. Maybe a review of the page
is
needed. A
solution could be to add a zip file containing the basic.

"Doug Robbins - Word MVP" 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

"Jim123" wrote in message
...
I trying attach a .pdf file with an email being mailed to a
list.
For
the
life of me I can't find where to insert the attachment file to
the
merge
email doc file. Using office 2007. Any help would be
appreciated.

Thanks















  #12  
Old April 2nd, 2008, 12:27 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default How to insert pdf attachment with word email merge?

It has nothing to do with macros. The document that is the active document
when you run the macro must have the same number of sections as there are
records in the data source and also records in the directory type mail merge
document.

How many sections does that document have?

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

"Abdul" wrote in message
...
Thanks for your immediate response, I have followed your steps that you
have
mentioned, but still not it's the same thing happening, could you please
explain in a simple steps? I am very new to macros.

-Abdul

"Doug Robbins - Word MVP" wrote:

This is the step that you missed:

"Then execute to a new document the mail merge that you want to send out
by
email with the attachments and with the result of execution of that mail
merge on the screen, run a macro containing the following code."

The document that you created in your step 3 must be a mail merge main
document that has attached to it the same data source as you used to
create
xyz.doc. You must then execute the merge of the step 3 document to a new
document. There is no need to save this document, but it must be the
active
document when you 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

"Abdul" wrote in message
...
Let me explain what i did
1) I have created a seperate directory in a word document according to
your
instruction. I can see the result in the other page that shows all the
email
addresses and attachement path in the table and saved with a name
(xyz.doc),
2) I closed the file (xyz.doc).
3) Opened a new document file and typed with a message to send, also i
have
inlcuded your macro in this new document, when I try to run your macro,
it
asked me a file to execute, i have choosen xyz.doc, then it prompted me
to
enter a subject, i entered a subject and pressed OK, it had sent email
with
my outlook.
4) when opened a mail that i have sent, the first mail that contain
Message
with attachment, but the other all emails that contains only attachment
without Message.

Please tell me which step i missed out.

- Abdul

"Doug Robbins - Word MVP" wrote:

You are not running the macro when a document created by executing the
merge
that contains the message that is to be in the body of the emails to a
new
document is the active document.

Please read the instructions again and follow them exactly.

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

"Abdul" wrote in message
...
Hi

Your mail merge method works fine with attachemnt, but there is a
problem
in
body of the message, when you sent to 5 email IDs, the first person
only
get
the message in the body, but others can received only attachment
without
text
in their body of the email, can you please tell me how to do it?

Abdul

"Doug Robbins - Word MVP" wrote:

See response in your new thread.

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

"LyndieBee" wrote in message
...
I'm using the MergeWithAttachments procedure and followed all the
steps.
I
think I'm ALMOST there but am having a problem. (Microsoft
Outlook
11.0
Object Library IS marked.) I'm using Office 2003, I've made and
saved
the
directory-type file with the email addresses and document name,
I've
created
the letter-type merge with the appropriate info and fields. When
I
run
the
macro, however, things go on and on and on!!! The 3 address that
I'm
expecting to see come by and I answer Yes to sending them (I'm
doing
this
manually since there are only 3 in my test file.) But then it
keeps
going
with Document 4, Document 5, Document 6, etc. I finally
Ctrl+Break
to
get
the process to stop and get a macro error message. When I choose
debug,
this
is the part of the macro that is pointed to:

End With
Set oItem = Nothing
ActiveDocument.Close wdDoNotSaveChanges
Counter = Counter + 1
Wend

I copied and pasted from the article but have looked it over as
well
to
be
sure I picked up everything. Any ideas?
-Lyndie

"Doug Robbins - Word MVP" wrote:

The procedure must be followed exactly for the process to be
successful
and
putting the code in a zip file would have no benefit.

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

"Søren Dalhoff" wrote in
message
...
Looking at the past of how many times the same answer has been
provided
http://..../MergeWithAttachments.htm. Maybe a review of the
page
is
needed. A
solution could be to add a zip file containing the basic.

"Doug Robbins - Word MVP" 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

"Jim123" wrote in message
...
I trying attach a .pdf file with an email being mailed to a
list.
For
the
life of me I can't find where to insert the attachment file
to
the
merge
email doc file. Using office 2007. Any help would be
appreciated.

Thanks

















 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.