Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
lgruszynski lgruszynski is offline
external usenet poster
 
Posts: 3
Default Is it possible to email a Directory created in Word 2003?

Hello


I have created a directory mail merge in which I have one letter for each
contact that groups invoice information for each contact. Is there a way to
be able to merge this into Outlook so it can be emailed to each contact
listed once?



Excel file is set up as follows:

Contact Invoice # Invoice Amt Email Address


Thank you in advance for any assistance!

--
Leslie
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Is it possible to email a Directory created in Word 2003?

Hi lgruszynski,

Depending on what you're trying to do, you might find the approach in my Word 97-2007 Catalogue/Directory Mailmerge Tutorial useful.
It's available at:
http://lounge.windowssecrets.com/ind...owtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

--
Cheers
macropod
[Microsoft MVP - Word]


"lgruszynski" wrote in message ...
Hello


I have created a directory mail merge in which I have one letter for each
contact that groups invoice information for each contact. Is there a way to
be able to merge this into Outlook so it can be emailed to each contact
listed once?



Excel file is set up as follows:

Contact Invoice # Invoice Amt Email Address


Thank you in advance for any assistance!

--
Leslie


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Is it possible to email a Directory created in Word 2003?

See the following page of fellow MVP Graham Mayors website:

http://www.gmayor.com/ManyToOne.htm

The code in that add-in could be modified so that it would email out each of
the documents, or leave it as is to create individual documents which you
then mail out using the method in 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, originally posted via msnews.microsoft.com

"lgruszynski" wrote in message
...
Hello


I have created a directory mail merge in which I have one letter for each
contact that groups invoice information for each contact. Is there a way
to
be able to merge this into Outlook so it can be emailed to each contact
listed once?



Excel file is set up as follows:

Contact Invoice # Invoice Amt Email Address


Thank you in advance for any assistance!

--
Leslie


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Is it possible to email a Directory created in Word 2003?

I have created, but not yet thoroughly tested a modifiction to the addin at
http://www.gmayor.com/ManyToOne.htm that incorporates the option to mail
merge the result to email.

Send me an email if you want to try it.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Doug Robbins - Word MVP" wrote in message
...
See the following page of fellow MVP Graham Mayors website:

http://www.gmayor.com/ManyToOne.htm

The code in that add-in could be modified so that it would email out each
of the documents, or leave it as is to create individual documents which
you then mail out using the method in 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, originally posted via msnews.microsoft.com

"lgruszynski" wrote in message
...
Hello


I have created a directory mail merge in which I have one letter for each
contact that groups invoice information for each contact. Is there a way
to
be able to merge this into Outlook so it can be emailed to each contact
listed once?



Excel file is set up as follows:

Contact Invoice # Invoice Amt Email Address


Thank you in advance for any assistance!

--
Leslie



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
lgruszynski lgruszynski is offline
external usenet poster
 
Posts: 3
Default Is it possible to email a Directory created in Word 2003?

Thank you all for your suggestions! I will try these out today..

Leslie
--
Leslie


"lgruszynski" wrote:

Hello


I have created a directory mail merge in which I have one letter for each
contact that groups invoice information for each contact. Is there a way to
be able to merge this into Outlook so it can be emailed to each contact
listed once?



Excel file is set up as follows:

Contact Invoice # Invoice Amt Email Address


Thank you in advance for any assistance!

--
Leslie



  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
lgruszynski lgruszynski is offline
external usenet poster
 
Posts: 3
Default Is it possible to email a Directory created in Word 2003?

HI Doug

These 2 tools were exactly what I was looking for and the email piece worked
great!!! I tested it out with the files provided...but I did run into an
issue with the Many to One macro when I attempted to use it on one of my real
data files. It produces the merged files in the C:MergeFiles Folder...I have
one key called "Account" and then the repeating fields are "Brand" and
"PropertyName" I've played around with it for a bit, but am consistently
getting 1 of 2 error messages. Either in my brand field I get "5941 - the
requested memebr of the collection does not exist" and the account and
property info pulls in correctly...or in the PropertyName field, I get the
message "Error! MergeField was not found in header record of data source."
and the Brand and Account information pulls in fine. Any ideas?


Leslie


"lgruszynski" wrote:

Thank you all for your suggestions! I will try these out today..

Leslie
--
Leslie


"lgruszynski" wrote:

Hello


I have created a directory mail merge in which I have one letter for each
contact that groups invoice information for each contact. Is there a way to
be able to merge this into Outlook so it can be emailed to each contact
listed once?



Excel file is set up as follows:

Contact Invoice # Invoice Amt Email Address


Thank you in advance for any assistance!

--
Leslie

  #7   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Is it possible to email a Directory created in Word 2003?

It sounds like there maybe some inconsistencies in your data source.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"lgruszynski" wrote in message
...
HI Doug

These 2 tools were exactly what I was looking for and the email piece
worked
great!!! I tested it out with the files provided...but I did run into an
issue with the Many to One macro when I attempted to use it on one of my
real
data files. It produces the merged files in the C:MergeFiles Folder...I
have
one key called "Account" and then the repeating fields are "Brand" and
"PropertyName" I've played around with it for a bit, but am consistently
getting 1 of 2 error messages. Either in my brand field I get "5941 - the
requested memebr of the collection does not exist" and the account and
property info pulls in correctly...or in the PropertyName field, I get the
message "Error! MergeField was not found in header record of data source."
and the Brand and Account information pulls in fine. Any ideas?


Leslie


"lgruszynski" wrote:

Thank you all for your suggestions! I will try these out today..

Leslie
--
Leslie


"lgruszynski" wrote:

Hello


I have created a directory mail merge in which I have one letter for
each
contact that groups invoice information for each contact. Is there a
way to
be able to merge this into Outlook so it can be emailed to each contact
listed once?



Excel file is set up as follows:

Contact Invoice # Invoice Amt Email Address


Thank you in advance for any assistance!

--
Leslie


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing newsletter created in MS Word from an email Newslettergirl Microsoft Word Help 1 February 28th 07 02:03 AM
How can I create an index for a directory created from mail merge? DDJENN Mailmerge 1 November 17th 05 05:13 AM
How do I access a directory created in Mailmerge? TrinityELC Mailmerge 2 September 13th 05 05:29 AM
Why can't directory or file be created? grt Microsoft Word Help 2 August 21st 05 05:56 PM
Why do I suddenly get "Directory of file cannot be created" Terrence Los Angeles Microsoft Word Help 2 December 5th 04 01:41 PM


All times are GMT +1. The time now is 06:51 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"