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  

NO CODE - mail merge to Outlook with attachment with CC



 
 
Thread Tools Display Modes
  #1  
Old January 21st, 2005, 05:23 PM
GillianHG
external usenet poster
 
Posts: n/a
Default NO CODE - mail merge to Outlook with attachment with CC

Hi - I've been reading posts here regarding mail merging to Outlook with
attachments or CC and it seems to require VBA code to do this. I'm not
allowed to do any coding in my current environment so these posts and the MVP
article do not help me. I have a customer who needs to know if she can do the
any or all of the following without using VB code:

Mail merge in word to email messages and/or
1. Customize individual messages when sending (the workaround I figured is
to customize the onscreen message and then using the Merge to email dialog,
choose Current Record and do that message by messge)
2. Through the mail merge tool use a CC field
3. Through the mail merge tool include an Outlook signature (my workaround -
cut and paste from Outlook into Word)
4. Through the mail merge tool include an attachment (my workaround - get to
step 5 of the merge and then send each individually using the File, Send To
command - that gives the outgoing mail message screen where you can include
attachment and also CC)

She wants to basically use Outlook in Word to send multiple emails that are
largely the same with flexibility to customize each before sending.

I do not believe it is possible to do this using simply the Mail Merge tool
in Word and all my research supports this. Can someone please tell me if it
is possible to do this?

-
Thanks,
GillianHG
  #2  
Old January 22nd, 2005, 12:30 AM
Doug Robbins
external usenet poster
 
Posts: n/a
Default

If it serves the purpose, there is no legitimate reason to prevent people
from creating macros to perform tasks in an efficient manner.

That said, there is no reason that the process cannot be done manually -
Execute the mailmerge to a new document, then select and copy each section
in turn, paste into a new document, use FileSend to which will open mail
program, allowing you to add attachments, enter the addressee etc. etc. -
Very mind numbing and prone to errors.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"GillianHG" wrote in message
...
Hi - I've been reading posts here regarding mail merging to Outlook with
attachments or CC and it seems to require VBA code to do this. I'm not
allowed to do any coding in my current environment so these posts and the
MVP
article do not help me. I have a customer who needs to know if she can do
the
any or all of the following without using VB code:

Mail merge in word to email messages and/or
1. Customize individual messages when sending (the workaround I figured
is
to customize the onscreen message and then using the Merge to email
dialog,
choose Current Record and do that message by messge)
2. Through the mail merge tool use a CC field
3. Through the mail merge tool include an Outlook signature (my
workaround -
cut and paste from Outlook into Word)
4. Through the mail merge tool include an attachment (my workaround - get
to
step 5 of the merge and then send each individually using the File, Send
To
command - that gives the outgoing mail message screen where you can
include
attachment and also CC)

She wants to basically use Outlook in Word to send multiple emails that
are
largely the same with flexibility to customize each before sending.

I do not believe it is possible to do this using simply the Mail Merge
tool
in Word and all my research supports this. Can someone please tell me if
it
is possible to do this?

-
Thanks,
GillianHG



  #3  
Old March 17th, 2006, 12:47 AM posted to microsoft.public.word.mailmerge.fields
external usenet poster
 
Posts: n/a
Default NO CODE - mail merge to Outlook with attachment with CC

Another slightly less tedious way is, working offline, to use the Mail Merge
Wizard in Word to generate the emails. Then switch to Outlook where they
will be found in the Outbox. Now add the attachment to each, manually, and
when done go online again.

"Doug Robbins" wrote:

If it serves the purpose, there is no legitimate reason to prevent people
from creating macros to perform tasks in an efficient manner.

That said, there is no reason that the process cannot be done manually -
Execute the mailmerge to a new document, then select and copy each section
in turn, paste into a new document, use FileSend to which will open mail
program, allowing you to add attachments, enter the addressee etc. etc. -
Very mind numbing and prone to errors.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"GillianHG" wrote in message
...
Hi - I've been reading posts here regarding mail merging to Outlook with
attachments or CC and it seems to require VBA code to do this. I'm not
allowed to do any coding in my current environment so these posts and the
MVP
article do not help me. I have a customer who needs to know if she can do
the
any or all of the following without using VB code:

Mail merge in word to email messages and/or
1. Customize individual messages when sending (the workaround I figured
is
to customize the onscreen message and then using the Merge to email
dialog,
choose Current Record and do that message by messge)
2. Through the mail merge tool use a CC field
3. Through the mail merge tool include an Outlook signature (my
workaround -
cut and paste from Outlook into Word)
4. Through the mail merge tool include an attachment (my workaround - get
to
step 5 of the merge and then send each individually using the File, Send
To
command - that gives the outgoing mail message screen where you can
include
attachment and also CC)

She wants to basically use Outlook in Word to send multiple emails that
are
largely the same with flexibility to customize each before sending.

I do not believe it is possible to do this using simply the Mail Merge
tool
in Word and all my research supports this. Can someone please tell me if
it
is possible to do this?

-
Thanks,
GillianHG




  #4  
Old February 10th, 2010, 02:53 PM posted to microsoft.public.word.mailmerge.fields
BruceN
external usenet poster
 
Posts: 1
Default NO CODE - mail merge to Outlook with attachment with CC

Brian's post was very helpfu. Moreover, by ading the following text to the
email body, "cc: Variable Name and Address" with the name and address of
the individual who I want to cc: for this particular addressee; it makes it
easy when I go through the stacked messages in my Outbox to add the
appropriate cc:, and then click "Send". When I go back "Online", all the
messages go out to the right folks.
Bruce
----------

"BrianH" wrote:

Another slightly less tedious way is, working offline, to use the Mail Merge
Wizard in Word to generate the emails. Then switch to Outlook where they
will be found in the Outbox. Now add the attachment to each, manually, and
when done go online again.

"Doug Robbins" wrote:

If it serves the purpose, there is no legitimate reason to prevent people
from creating macros to perform tasks in an efficient manner.

That said, there is no reason that the process cannot be done manually -
Execute the mailmerge to a new document, then select and copy each section
in turn, paste into a new document, use FileSend to which will open mail
program, allowing you to add attachments, enter the addressee etc. etc. -
Very mind numbing and prone to errors.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"GillianHG" wrote in message
...
Hi - I've been reading posts here regarding mail merging to Outlook with
attachments or CC and it seems to require VBA code to do this. I'm not
allowed to do any coding in my current environment so these posts and the
MVP
article do not help me. I have a customer who needs to know if she can do
the
any or all of the following without using VB code:

Mail merge in word to email messages and/or
1. Customize individual messages when sending (the workaround I figured
is
to customize the onscreen message and then using the Merge to email
dialog,
choose Current Record and do that message by messge)
2. Through the mail merge tool use a CC field
3. Through the mail merge tool include an Outlook signature (my
workaround -
cut and paste from Outlook into Word)
4. Through the mail merge tool include an attachment (my workaround - get
to
step 5 of the merge and then send each individually using the File, Send
To
command - that gives the outgoing mail message screen where you can
include
attachment and also CC)

She wants to basically use Outlook in Word to send multiple emails that
are
largely the same with flexibility to customize each before sending.

I do not believe it is possible to do this using simply the Mail Merge
tool
in Word and all my research supports this. Can someone please tell me if
it
is possible to do this?

-
Thanks,
GillianHG




 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge and Outlook Contacts Mike Dalton Contacts 7 February 23rd, 2005 07:00 PM
Can Outlook identify the word 'attached' or 'attachment' in a mail StuartB40 General Discussion 1 January 18th, 2005 01:05 PM
Start MailMerge in Outlook2203 aj Contacts 5 January 7th, 2005 08:14 PM
Can I send a mail merge using contacts in Excel via Outlook? Kristen Contacts 1 October 8th, 2004 11:15 PM
Problem formatting ZIP code in mail merge Peter Serratore Setting up and Configuration 6 October 18th, 2003 01:50 AM


All times are GMT +1. The time now is 07:44 AM.


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