A Microsoft Outlook email forum. Outlook Banter

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 » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Can I automate a Mail Merge from Outlook



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old April 19th 08, 01:42 AM posted to microsoft.public.outlook.program_vba
Nunjafush
external usenet poster
 
Posts: 2
Default Can I automate a Mail Merge from Outlook

I currently have a mail merge process that works fine manually but it is
tedious to do many times every day, so I'm wondering if I can automate it
using VBA (I am an Oracle programmer, but I don't know VBA, so I'm hoping
this isn't going to be completely over my head).

What I am currently doing is creating a Job Card (for whenever an
appointment is made to see a client) by merging client contact details in
Outlook to a Word document (merging fields from Outlook such as name,
address, phone number, etc).

The process I would like to automate is from after I have selected the
client (ie, highlighting the client in the Outlook Contacts list).

The current manual process is:
1. In Outlook, click on Tools Mail Merge,
2. Select "Only selected contacts" (and it is only ever 1 client that I
select at a time),
3. Select "Existing document",
4. Browse for the document (and it is always the same document),
5. Click on OK,
6. Now we're in Word, click on the "Merge to New Document" button in the
Merge Toolbar,
7. Click on OK.

Is this too difficult for someone who doesn't know VBA?
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I merge two contact files, not mail merge Butch[_2_] Outlook - Using Contacts 3 September 20th 07 04:24 PM
Mail Merge Wizard does not enable Merge button Flower Gardener Outlook - General Queries 0 March 10th 07 04:43 AM
how to automate specifying the account to use when sending mail? admaybhate Outlook - General Queries 3 September 18th 06 11:49 AM
access macros to automate e-mail sending in outlook Trader Alex Outlook and VBA 1 April 13th 06 09:21 PM
Automate mail account creation? Doug Outlook - Installation 2 February 8th 06 06:03 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.