Solved

Outlook 2010 mail merge through VPN

Posted on 2011-03-11
7
419 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn more about how the humble email signature can be used as more than just an electronic business card. When used correctly, a signature can easily be tailored for different purposes by different departments within an organization.
Resolve DNS query failed errors for Exchange
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

911 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

28 Experts available now in Live!

Get 1:1 Help Now