Solved

Outlook 2010 mail merge through VPN

Posted on 2011-03-11
7
410 Views
Last Modified: 2013-11-05
I have a rather complicated question and I will try to make it understandable in English, which is not my native language.

I have a small company with an office and I also work from my home with a VPN connection to the Office Server running SBS 2003.

Up to now, I used Office 2003. For offers to customer and enquiries to suppliers, I have used Word dot files, linked to an Access 2003 database. Through Word 2003 I sent personalized e-mails with Outlook 2003 mail merge.
This worked in the office but also from my home through VPN. I simply opened the Word.dot file 9with the link to the database. With mail merge and Outlook I could send separate messages to either customers or suppliers.
I recently upgraded to Office 2010 on both locations and now this method is not working from my home anymore? I converted the Access database to the 2010 version. I also converted the Word.dot files to the Word.dotm files but I cannot send my messages anymore through Outlook 2010.
I have checked macro settings and other security setting because I assume it is related to security setting but I am not sure of course.
I use the Dutch language version of Outlook.
0
Comment
Question by:jrvd
  • 4
7 Comments
 
LVL 5

Expert Comment

by:zazagor
ID: 35156016
Hi,

What kind of VPN? SSL VPN?
Try to add the ip of you VPN site/server to "Trusted Sites" in Internet Explorer.
Try using the Outlook OWA. Does that work?

//zaZagor
0
 

Author Comment

by:jrvd
ID: 35156255
Thanks for your reply. To be honest, I don't know what kind of VPN I have, just the standard VPN I guess. How can I see what kind of VPN I have?

I do not use Internet Explorer in this procedure so can it still make a difference if I add the IP to the trusted zone?

I have always assumed that Outlook OWA does not have all the functions I use for this and I must confess that I never actually tried it.

What I do is;

Open the VPN to the server in the office.
In file explorer, go the the Word.dot(x) file I need.
Open the dot(x) file so the link to the Access database is also activated (get some sql warnings but no big deal).
Now I have the Word file on the screen and through one the the tabs in Outlook I can select the recipients and send the e-mail with mail merge.
As said, I use the Dutch Outlook version so I don't know the English names of the functions and tabs I refer to.
0
 

Author Comment

by:jrvd
ID: 35165713
Tried Outlook OWA but that does not work but thanks anyway.
0
 

Author Comment

by:jrvd
ID: 35166620
When I use a plain text file, it takes a long time but the e-mail is sent. Meanwhile I assume it is ralated to Outlook 2010 not being the standard e-mail client.

I am running Windows 7 and I have put Windows Mail back from Vista to Windows 7 so perhaps this is causing the trouble I now have with Outlook 2010. I checked and Outlook 2010 is set as standard client. Just selected it again, just to be sure ;-).

In my other PC in the Office I have done the same thing with Windows Mail and there mailmerge works fine so perhaps I should re-install Office 2010 or remove Windows Mail. Maybe the sequence on my PC in the office was different but I can't remember that.
0
 

Accepted Solution

by:
jrvd earned 0 total points
ID: 35177437
I re-installed Office 2010 and the problem seems to be solved. I think it is caused by the work around to get Windows Mail back in Windows 7.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
Outlook Free & Paid Tools
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now