Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jul 2008
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge - Memo options (MS-Office 2003)

    Hi,

    I am currently using a contact list created in excel and using mail merge in word to send mail to them from a standard document template.

    My Requirements:

    1) I need a particular field from the excel file to be displayed as Subject in all the mail, which differs for each mail.
    2) I need to set reply to option for all those mails sent using mail merge, so that if anybody replies to that mail it should be directed to the particular mail id set by me.

    Thanks in advance to all saviours !!!!!!!!!!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail Merge - Memo options (MS-Office 2003)

    Welcome to Woody's Lounge!

    Mail merge in Word offers neither of these options, as far as I know.
    If you use Outlook, one option is to write Visual Basic code to automate Outlook from Word. You can then control every aspect of the e-mails, including the subject.
    There are also third-party utilities that may do what you want, for example MAPILab - Mail Merge Toolkit.

  3. #3
    Lounger
    Join Date
    Jul 2008
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge - Memo options (MS-Office 2003)

    Hi Hans,

    Thanks for the prompt response.

    But I don't have enough knowledge in writing VB code for Outlook or Word. Is there anyway can I learn this apart trying download....

    Thanks+Regards
    MS

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail Merge - Memo options (MS-Office 2003)

    Automation is not a trivial subject - you need to be familiar with VBA in each of the applications involved in the process.
    Microsoft has a help file available for download, with theory and examples: Microsoft Office 2000 automation Help file (applies to Office 2003 too).
    Automation 101 by our moderator WendellB contains a short introduction and useful links.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •