Reply
 
Thread Tools Display Modes
  #1   Report Post  
CidtheSquid CidtheSquid is offline
Junior Member
 
Posts: 1
Default Manually Inputting Mail Merge Links

Hi everyone!
I have lots of similar excel documents and happily mail merge to Word using the mail merge wizard successfully.

My problem is I want to create one Word document (like a template) that can be used with all the Excel documents, this would work for the generic columns/fields. BUT... there are a quite few columns (fields) that differ on each document and it's a pain to keep inserting them on to every document.

Is there a way of manually typing in the mail merge link?

I have tried using formulas in Excel to replicate the mail merge links using the columns headers and adding in the mergefield so they are in the format of what the mail merge wizard automatically inserts. The problem is none of the links are 'active' and when the merge starts they remain as text in the Word document.

Hope this isn't to confusing
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge pictures - missing links Meltad Mailmerge 5 September 9th 06 07:17 AM
Mail Merge doesn't execute until manually Opening the desired document [email protected] Mailmerge 1 February 28th 06 06:19 PM
Formatting Paste Links/Mail Merge jdc24 Mailmerge 1 May 20th 05 02:10 PM
Mail Merge not running properly from Access Function but runs properly when opened manually Brian Alley Mailmerge 1 February 22nd 05 12:58 AM
Mail Merge inputting Company titles? BTClan Mailmerge 1 December 30th 04 07:52 AM


All times are GMT +1. The time now is 12:25 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"