Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel
external usenet poster
 
Posts: 4
Default Excel hyperlink to specific word mail merge record

Hi,

I'm not even sure that this is possible but....................


I have a Mail Merge document that is linked to a Excel sheet. I use
this to send emails. My question is whether it is possible to create a

hyperlink in an excel cell that opens the mail merge document for that
specific record? I then need to edit this document before i send it.


I'm using Word/Excel 2000.


Thanks for any help,


Jeegna

  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 329
Default Excel hyperlink to specific word mail merge record

Hi Jeegna,

Unfortunately, hyperlinking to a specific record would necessitate bookmarking
that record, but the mailmerge process necessarily deletes any bookmarks in
the document.

If you know the exact details of the edit and the edit criteria, and the edit
criteria are reflected in your mailmerge data source, you could use field
codes in your main mailmerge document to incorporate the edit as part of the
merge.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
ups.com...
| Hi,
|
| I'm not even sure that this is possible but....................
|
|
| I have a Mail Merge document that is linked to a Excel sheet. I use
| this to send emails. My question is whether it is possible to create a
|
| hyperlink in an excel cell that opens the mail merge document for that
| specific record? I then need to edit this document before i send it.
|
|
| I'm using Word/Excel 2000.
|
|
| Thanks for any help,
|
|
| Jeegna
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel for mail merge Nelly Doone Excel Worksheet Functions 2 July 17th 06 10:49 PM
how do I use mail merge in excel for word documents Lisa J Duffy Excel Discussion (Misc queries) 1 August 4th 05 01:40 PM
Mail merge to word James42 Excel Discussion (Misc queries) 0 June 10th 05 01:32 AM
Different graphic for each record in mail merge document Alex St-Pierre Charts and Charting in Excel 1 May 4th 05 07:26 PM
Numbers after decimal point excel to word mail merge Andy P Excel Worksheet Functions 1 March 15th 05 11:48 AM


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

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"