![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |